---查询某一天的数据
SELECT amount,* FROM mar_withdrawal_recharge WHERE status=1 AND
CAST(audit_time as DATE)=DATE '2020-07-18'
--查询今天的数据
SELECT amount,* FROM mar_withdrawal_recharge WHERE status=1 AND
audit_time>=current_date
-查询所有的表
SELECT * FROM pg_tables
WHERE tablename NOT LIKE 'pg%'
AND tablename NOT LIKE 'sql_%'
ORDER BY tablename;
--获取某个表tablename 所有字段名称 , 类型,备注,是否为空 等
SELECT
col_description(a.attrelid,a.attnum) as comment,
a.attname as name,
pg_type.typname as typename,
a.attnotnull as notnull
FROM pg_class as c,pg_attribute as a inner join pg_type on pg_type.oid = a.atttypid
where c.relname = 'base_resource' and a.attrelid = c.oid and a.attnum>0
url: jdbc:postgresql://192.168.110.135:54320/tontisa_xq
username: tontisa_xq
password: