aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorPeter Eisentraut <peter_e@gmx.net>2016-11-03 12:00:00 -0400
committerPeter Eisentraut <peter_e@gmx.net>2016-11-03 14:02:46 -0400
commita0f357e570ce01cf017f02d9f05ab2272663d695 (patch)
tree85d179f232cb861b6f4924a193861101f03b0b64 /doc/src
parent1d15d0db50a5f39ab69c1fe60f2d5dcc7e2ddb9c (diff)
downloadpostgresql-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.sgml6
-rw-r--r--doc/src/sgml/ref/psql-ref.sgml11
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=&gt; <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>