\dT
Lists data types. If pattern is specified, only types whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each type is listed with its internal name and size, its allowed values if it is an enum type, and its associated permissions. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects.
Reading PG 18·Select a recorded version
- Client
- psql 18.7
- Case-sensitive spelling
- \dT
- command
- \dT
- manual path
- app-psql.html#APP-PSQL-META-COMMAND-DT
- modifiers
- map[command:\dT modifiers:Sx+]
- signature
- \dT[Sx+] [ pattern ]
- spellings
- \dT
Definition PG 18
\dT[Sx+] [pattern]Lists data types. If
patternis specified, only types whose names match the pattern are listed. Ifxis appended to the command name, the results are displayed in expanded mode. If+is appended to the command name, each type is listed with its internal name and size, its allowed values if it is anenumtype, and its associated permissions. By default, only user-created objects are shown; supply a pattern or theSmodifier to include system objects.
Exact case-sensitive spellings
\dT
Spellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \dT | Sx+ |
Compare versions
Complete source facts
documentation revision
{"inputs":[{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","version":"18.7"},{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"cb475c53a16d9e06358f5e6c9c5649645db92568cfd319f230c62c9f57ae090b","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · 1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915
Text language: en · 1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915