PostgreSQL View the table structure

最新推荐文章于 2024-09-16 23:20:37 发布

ZhongWeicheng

最新推荐文章于 2024-09-16 23:20:37 发布

阅读量943

点赞数

分类专栏： PostgreSQL 文章标签： postgresql

本文链接：https://blog.csdn.net/staricqxyz/article/details/10466203

版权

PostgreSQL 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

command line

testdb=> \dt
         List of relations
 Schema |   Name    | Type  | Owner 
--------+-----------+-------+-------
 public | orderinfo | table | zwc
(1 row)

testdb=> 
testdb=> \d orderinfo
                                    Table "public.orderinfo"
    Column    |     Type     |                            Modifiers                             
--------------+--------------+------------------------------------------------------------------
 orderinfo_id | integer      | not null default nextval('orderinfo_orderinfo_id_seq'::regclass)
 customer_id  | integer      | not null
 date_placed  | date         | not null
 date_shipped | date         | 
 shipping     | numeric(7,2) | 
Indexes:
    "orderinfo_pk" PRIMARY KEY, btree (orderinfo_id)

SQL

testdb=> SELECT
testdb-> A .attname AS field,
testdb-> T .typname AS TYPE,
testdb-> A .attlen AS LENGTH,
testdb-> A .attnotnull AS NOTNULL
testdb-> FROM
testdb-> pg_class C,
testdb-> pg_attribute A,
testdb-> pg_type T
testdb-> WHERE
testdb-> C .relname = 'orderinfo'
testdb-> AND A .attnum > 0
testdb-> AND A .attrelid = C .oid
testdb-> AND A .atttypid = T .oid;
    field     |  type   | length | notnull 
--------------+---------+--------+---------
 orderinfo_id | int4    |      4 | t
 customer_id  | int4    |      4 | t
 date_placed  | date    |      4 | t
 date_shipped | date    |      4 | f
 shipping     | numeric |     -1 | f
(5 rows)