Postgresql 中查询表格列名和类型的sql语句

最新推荐文章于 2024-08-16 08:03:28 发布

iteye_19068

最新推荐文章于 2024-08-16 08:03:28 发布

阅读量1.1k

点赞数

分类专栏： postgresql 文章标签： SQL PostgreSQL C C++ C#

本文链接：https://blog.csdn.net/iteye_19068/article/details/81719445

版权

postgresql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

SELECT a.attname as col_name,a.atttypid as col_type FROM pg_catalog.pg_attribute a WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = ( SELECT c.oid FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relname ~ '^(tableName )$' AND pg_catalog.pg_table_is_visible(c.oid))

可以得到所有列的列名以及列类型，列类型对应的值如下：

bigint            = 20;
smallint            = 21;
integer            = 23;
character        = 1042;
character_var    = 1043;
timestamp        = 1114;
double            = 701;