diff options
author | Peter Eisentraut <peter_e@gmx.net> | 2016-11-03 12:00:00 -0400 |
---|---|---|
committer | Peter Eisentraut <peter_e@gmx.net> | 2016-11-03 14:02:46 -0400 |
commit | a0f357e570ce01cf017f02d9f05ab2272663d695 (patch) | |
tree | 85d179f232cb861b6f4924a193861101f03b0b64 /doc/src | |
parent | 1d15d0db50a5f39ab69c1fe60f2d5dcc7e2ddb9c (diff) | |
download | postgresql-a0f357e570ce01cf017f02d9f05ab2272663d695.tar.gz postgresql-a0f357e570ce01cf017f02d9f05ab2272663d695.zip |
psql: Split up "Modifiers" column in \d and \dD
Make separate columns "Collation", "Nullable", "Default".
Reviewed-by: Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/ref/create_index.sgml | 6 | ||||
-rw-r--r-- | doc/src/sgml/ref/psql-ref.sgml | 11 |
2 files changed, 8 insertions, 9 deletions
diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index e9f47c44145..fcb7a60ce3e 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -459,9 +459,9 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class= <programlisting> postgres=# \d tab Table "public.tab" - Column | Type | Modifiers ---------+---------+----------- - col | integer | + Column | Type | Collation | Nullable | Default +--------+---------+-----------+----------+--------- + col | integer | | | Indexes: "idx" btree (col) INVALID </programlisting> diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 4806e77be7a..2410bee4eb8 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -4081,12 +4081,11 @@ CREATE TABLE Now look at the table definition again: <programlisting> testdb=> <userinput>\d my_table</userinput> - Table "my_table" - Attribute | Type | Modifier ------------+---------+-------------------- - first | integer | not null default 0 - second | text | - + Table "public.my_table" + Column | Type | Collation | Nullable | Default +--------+---------+-----------+----------+--------- + first | integer | | not null | 0 + second | text | | | </programlisting> Now we change the prompt to something more interesting: <programlisting> |