Displays all data types in the connected database, with comments : Postgre SQL Command « Postgre SQL « PostgreSQL






Displays all data types in the connected database, with comments


postgres=#
postgres=# --Displays all data types in the connected database, with comments.
postgres=# \dT+
                                                           List of data types
   Schema   |            Name             |  Internal name   | Size |                            Description
------------+-----------------------------+------------------+------+-------------------------------------------------------------------
 pg_catalog | "any"                       | any              | 4    |
 pg_catalog | "char"                      | char             | 1    | single character
 pg_catalog | "trigger"                   | trigger          | 4    |
 pg_catalog | "unknown"                   | unknown          | var  |
 pg_catalog | abstime                     | abstime          | 4    | absolute, limited-range date and time (Unix system time)
 pg_catalog | aclitem                     | aclitem          | 12   | access control list
 pg_catalog | anyarray                    | anyarray         | var  |
 pg_catalog | anyelement                  | anyelement       | 4    |
 pg_catalog | bigint                      | int8             | 8    | ~18 digit integer, 8-byte storage
 pg_catalog | bit                         | bit              | var  | fixed-length bit string
 pg_catalog | bit varying                 | varbit           | var  | variable-length bit string
 pg_catalog | boolean                     | bool             | 1    | boolean, 'true'/'false'
 pg_catalog | box                         | box              | 32   | geometric box '(lower left,upper right)'
 pg_catalog | bytea                       | bytea            | var  | variable-length string, binary values escaped
 pg_catalog | character                   | bpchar           | var  | char(length), blank-padded string, fixed storage length
 pg_catalog | character varying           | varchar          | var  | varchar(length), non-blank-padded string, variable storage length
 pg_catalog | cid                         | cid              | 4    | command identifier type, sequence in transaction id
 pg_catalog | cidr                        | cidr             | var  | network IP address/netmask, network address
 pg_catalog | circle                      | circle           | 24   | geometric circle '(center,radius)'
 pg_catalog | cstring                     | cstring          | var  |
 pg_catalog | date                        | date             | 4    | ANSI SQL date
 pg_catalog | double precision            | float8           | 8    | double-precision floating point number, 8-byte storage
 pg_catalog | inet                        | inet             | var  | IP address/netmask, host address, netmask optional
 pg_catalog | int2vector                  | int2vector       | var  | array of int2, used in system tables
 pg_catalog | integer                     | int4             | 4    | -2 billion to 2 billion integer, 4-byte storage
 pg_catalog | internal                    | internal         | 4    |
 pg_catalog | interval                    | interval         | 16   | @ <number> <units>, time interval
 pg_catalog | language_handler            | language_handler | 4    |
 pg_catalog | line                        | line             | 32   | geometric line (not implemented)'
 pg_catalog | lseg                        | lseg             | 32   | geometric line segment '(pt1,pt2)'
 pg_catalog | macaddr                     | macaddr          | 6    | XX:XX:XX:XX:XX:XX, MAC address
 pg_catalog | money                       | money            | 4    | monetary amounts, $d,ddd.cc
 pg_catalog | name                        | name             | 64   | 63-character type for storing system identifiers
 pg_catalog | numeric                     | numeric          | var  | numeric(precision, decimal), arbitrary precision number
 pg_catalog | oid                         | oid              | 4    | object identifier(oid), maximum 4 billion
 pg_catalog | oidvector                   | oidvector        | var  | array of oids, used in system tables
 pg_catalog | opaque                      | opaque           | 4    |
 pg_catalog | path                        | path             | var  | geometric path '(pt1,...)'
 pg_catalog | point                       | point            | 16   | geometric point '(x, y)'
 pg_catalog | polygon                     | polygon          | var  | geometric polygon '(pt1,...)'
 pg_catalog | real                        | float4           | 4    | single-precision floating point number, 4-byte storage
 pg_catalog | record                      | record           | var  |
 pg_catalog | refcursor                   | refcursor        | var  | reference cursor (portal name)
 pg_catalog | regclass                    | regclass         | 4    | registered class
 pg_catalog | regoper                     | regoper          | 4    | registered operator
 pg_catalog | regoperator                 | regoperator      | 4    | registered operator (with args)
 pg_catalog | regproc                     | regproc          | 4    | registered procedure
 pg_catalog | regprocedure                | regprocedure     | 4    | registered procedure (with args)
 pg_catalog | regtype                     | regtype          | 4    | registered type
 pg_catalog | reltime                     | reltime          | 4    | relative, limited-range time interval (Unix delta time)
 pg_catalog | smallint                    | int2             | 2    | -32 thousand to 32 thousand, 2-byte storage
 pg_catalog | smgr                        | smgr             | 2    | storage manager
 pg_catalog | text                        | text             | var  | variable-length string, no limit specified
 pg_catalog | tid                         | tid              | 6    | (Block, offset), physical location of tuple
-- More  --
           
       








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, with comments
6.Displays all database objects in the connected database, with comments
7.Displays all tables in the connected database, with comments
8.Displays all indices in the connected database, with comments
9.Displays all sequences in the connected database, with comments
10.Displays all views in the connected database, with comments
11.Displays all functions in the connected database, with comments
12.Displays all operators in the connected database, with comments
13.To get out of psql
14.timestamp with time zone postmaster start time