Displays all database objects, with comments : Postgre SQL Command « Postgre SQL « PostgreSQL






Displays all database objects, with comments


-- Displays all database objects, with comments.
\dd

pg_catalog | tintervalle                        | function  | less-than-or-equal
pg_catalog | tintervalleneq                     | function  | length equal
pg_catalog | tintervallenge                     | function  | length greater-than-or-equal
pg_catalog | tintervallengt                     | function  | length greater-than
pg_catalog | tintervallenle                     | function  | length less-than-or-equal
pg_catalog | tintervallenlt                     | function  | length less-than
pg_catalog | tintervallenne                     | function  | length not equal to
pg_catalog | tintervallt                        | function  | less-than
pg_catalog | tintervalne                        | function  | not equal
pg_catalog | tintervalov                        | function  | overlaps
pg_catalog | tintervalrecv                      | function  | I/O
pg_catalog | tintervalrel                       | function  | tinterval to reltime
pg_catalog | tintervalsame                      | function  | same as?
pg_catalog | tintervalsend                      | function  | I/O
pg_catalog | tintervalstart                     | function  | start of interval
pg_catalog | to_ascii                           | function  | encode text from DB encoding to ASCII text
pg_catalog | to_ascii                           | function  | encode text from encoding to ASCII text
pg_catalog | to_char                            | function  | format float4 to text
pg_catalog | to_char                            | function  | format float8 to text
pg_catalog | to_char                            | function  | format int4 to text
pg_catalog | to_char                            | function  | format int8 to text
pg_catalog | to_char                            | function  | format interval to text
pg_catalog | to_char                            | function  | format numeric to text
pg_catalog | to_char                            | function  | format timestamp to text
pg_catalog | to_char                            | function  | format timestamp with time zone to text
pg_catalog | to_date                            | function  | convert text to date
pg_catalog | to_hex                             | function  | convert int4 number to hex
pg_catalog | to_hex                             | function  | convert int8 number to hex
pg_catalog | to_number                          | function  | convert text to numeric
pg_catalog | to_timestamp                       | function  | convert UNIX epoch to timestamptz
pg_catalog | to_timestamp                       | function  | convert text to timestamp with time zone
pg_catalog | translate                          | function  | map a set of character appearing in string
pg_catalog | trunc                              | function  | MAC manufacturer fields
pg_catalog | trunc                              | function  | truncate to integer
pg_catalog | trunc                              | function  | value truncated to 'scale'
pg_catalog | trunc                              | function  | value truncated to 'scale' of zero
pg_catalog | unknownrecv                        | function  | I/O
pg_catalog | unknownsend                        | function  | I/O
pg_catalog | upper                              | function  | uppercase
pg_catalog | varbit                             | function  | adjust varbit() to typmod length
pg_catalog | varbit_recv                        | function  | I/O
pg_catalog | varbit_send                        | function  | I/O
pg_catalog | varbitcmp                          | function  | compare
pg_catalog | varbiteq                           | function  | equal
pg_catalog | varbitge                           | function  | greater than or equal
pg_catalog | varbitgt                           | function  | greater than
pg_catalog | varbitle                           | function  | less than or equal
pg_catalog | varbitlt                           | function  | less than
pg_catalog | varbitne                           | function  | not equal
pg_catalog | varchar                            | function  | adjust varchar() to typmod length
pg_catalog | varchar                            | function  | convert name to varchar
pg_catalog | varcharrecv                        | function  | I/O
pg_catalog | varcharsend                        | function  | I/O
pg_catalog | version                            | function  | PostgreSQL version string
pg_catalog | width                              | function  | box width
pg_catalog | width_bucket                       | function  | bucket number of operand in equidepth histogram
pg_catalog | xid                                | data type | transaction id
pg_catalog | xideq                              | function  | equal
pg_catalog | xideqint4                          | function  | equal
pg_catalog | xidrecv                            | function  | I/O
pg_catalog | xidsend                            | function  | I/O
1459 rows)

           
       








Related examples in the same category

1.Command can be used to view all sequences in the currently connected database
2.Displays all databases available, with comments
3.Listing psql slash commands
4.The variable list
5.Displays all database objects in the connected database, with comments
6.Displays all tables in the connected database, with comments
7.Displays all indices in the connected database, with comments
8.Displays all sequences in the connected database, with comments
9.Displays all views in the connected database, with comments
10.Displays all functions in the connected database, with comments
11.Displays all operators in the connected database, with comments
12.Displays all data types in the connected database, with comments
13.To get out of psql
14.timestamp with time zone postmaster start time