postgresql查看表及列 postgresql
程序员文章站
2024-03-23 23:46:40
...
查询列
SELECT
*
FROM
information_schema. COLUMNS
WHERE
TABLE_NAME = 'daily_active_report'
AND COLUMN_NAME = 'coupon_name';
查询表
SELECT
*
FROM
information_schema. tables
WHERE
TABLE_NAME = 'daily_active_report'