postgreSQL常用语法_表结构

1. 查看表结构信息

select
  col.table_schema,
  col.table_name,
  col.ordinal_position,
  col.column_name,
  col.data_type,
  col.character_maximum_length,
  col.numeric_precision,
  col.numeric_scale,
  col.is_nullable,
  col.column_default,
  des.description
from
  information_schema.columns col left join pg_description des on
        col.table_name::regclass = des.objoid
      and col.ordinal_position = des.objsubid
where
    table_schema = 'public'
  and table_name = 'xxx'
order by
  ordinal_position;

2. 查看表名称

SELECT tablename FROM pg_tables;  

3. 待更新