主页 / dba / 问题 / 232826
Accepted
MortenSickel
Asked: 2019-03-23 00:22:57 +0800 CST

psql 表描述

  • 772

在 psql 中，如果我这样做\d+，我会得到类似的东西

 Schema |          Name           |   Type   | Owner  |    Size    |     Description 
--------+-------------------------+----------+--------+------------+-------------
 norsar | Routing Result          | table    | morten | 16 kB      | 
 norsar | Routing Result_id_seq   | sequence | morten | 8192 bytes |

等等。最后一个字段“描述”始终为空白。该字段在哪里读取其内容？- 因此，我如何在表格上设置描述？在某些情况下，这可能非常有用 - 如果我这样做，对显示的列的描述也是如此\d+ <tablename>。

我试过\set ECHO_HIDDEN ON了，但这并没有使它更清楚。

postgresql

1 个回答

  1. Best Answer

    这显示了您使用命令定义的注释comment on：

    下表定义：

    create table foo
(
  id integer primary key, 
  name text not null
);

comment on table foo is 'This is the famous foo table';
comment on column foo.id is 'This is the primary key';
comment on column foo.name is 'This is the name of the thing';

    然后会出现这样的：

    postgres> \d+
                                List of relations
 Schema |   Name    | Type  | Owner  |    Size    |         Description
--------+-----------+-------+--------+------------+------------------------------
 public | foo       | table | thomas | 8192 bytes | This is the famous foo table
(1 row)

postgres> \d+ foo
                                             Table "public.foo"
 Column |  Type   | Collation | Nullable | Default | Storage  | Stats target |          Description
--------+---------+-----------+----------+---------+----------+--------------+-------------------------------
 id     | integer |           | not null |         | plain    |              | This is the primary key
 name   | text    |           | not null |         | extended |              | This is the name of the thing
Indexes:
    "foo_pkey" PRIMARY KEY, btree (id)


postgres>
    • 3

相关问题