Search PostgreSQL documentation

\dAppsql CommandsPG18\dAp[x+] [access-method-pattern [operator-family-pattern]] Lists support functions associated with operator families (see Section 36.16.3). If access-method-pattern is specified, only functi…psql › Usage › Meta-Commands \dCpsql CommandsPG18\dC[x+] [ pattern ] Lists type casts. If pattern is specified, only casts whose source or target types match the pattern are listed. If x is appended to the command name, the results are dis…psql › Usage › Meta-Commands \dDpsql CommandsPG18\dD[Sx+] [ pattern ] Lists domains. If pattern is specified, only domains whose names match the pattern are shown. By default, only user-created objects are shown; supply a pattern or the S …psql › Usage › Meta-Commands \dEpsql CommandsPG18\dE[Sx+] [ pattern ]\di[Sx+] [ pattern ]\dm[Sx+] [ pattern ]\ds[Sx+] [ pattern ]\dt[Sx+] [ pattern ]\dv[Sx+] [ pattern ] In this group of commands, the letters E, i, m, s, t, and v stand for…psql › Usage › Meta-Commands \dFpsql CommandsPG18\dF[x+] [ pattern ] Lists text search configurations. If pattern is specified, only configurations whose names match the pattern are shown. If x is appended to the command name, the results …psql › Usage › Meta-Commands \dFdpsql CommandsPG18\dFd[x+] [ pattern ] Lists text search dictionaries. If pattern is specified, only dictionaries whose names match the pattern are shown. If x is appended to the command name, the results are…psql › Usage › Meta-Commands \dFppsql CommandsPG18\dFp[x+] [ pattern ] Lists text search parsers. If pattern is specified, only parsers whose names match the pattern are shown. If x is appended to the command name, the results are displayed…psql › Usage › Meta-Commands \dFtpsql CommandsPG18\dFt[x+] [ pattern ] Lists text search templates. If pattern is specified, only templates whose names match the pattern are shown. If x is appended to the command name, the results are displ…psql › Usage › Meta-Commands \dLpsql CommandsPG18\dL[Sx+] [ pattern ] Lists procedural languages. If pattern is specified, only languages whose names match the pattern are listed. By default, only user-created languages are shown; supply t…psql › Usage › Meta-Commands \dOpsql CommandsPG18\dO[Sx+] [ pattern ] Lists collations. If pattern is specified, only collations whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or…psql › Usage › Meta-Commands \dPpsql CommandsPG18\dP[itnx+] [ pattern ] Lists partitioned relations. If pattern is specified, only entries whose name matches the pattern are listed. The modifiers t (tables) and i (indexes) can be appended …psql › Usage › Meta-Commands \dRppsql CommandsPG18\dRp[x+] [ pattern ] Lists replication publications. If pattern is specified, only those publications whose names match the pattern are listed. If x is appended to the command name, the resu…psql › Usage › Meta-Commands \dRspsql CommandsPG18\dRs[x+] [ pattern ] Lists replication subscriptions. If pattern is specified, only those subscriptions whose names match the pattern are listed. If x is appended to the command name, the re…psql › Usage › Meta-Commands \dTpsql CommandsPG18\dT[Sx+] [ pattern ] 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 expand…psql › Usage › Meta-Commands \dXpsql CommandsPG18\dX[x] [ pattern ] Lists extended statistics. If pattern is specified, only those extended statistics whose names match the pattern are listed. If x is appended to the command name, the resu…psql › Usage › Meta-Commands \dapsql CommandsPG18\da[Sx] [ pattern ] Lists aggregate functions, together with their return type and the data types they operate on. If pattern is specified, only aggregates whose names match the pattern are …psql › Usage › Meta-Commands \dbpsql CommandsPG18\db[x+] [ pattern ] Lists tablespaces. If pattern is specified, only tablespaces whose names match the pattern are shown. If x is appended to the command name, the results are displayed in e…psql › Usage › Meta-Commands \dcpsql CommandsPG18\dc[Sx+] [ pattern ] Lists conversions between character-set encodings. If pattern is specified, only conversions whose names match the pattern are listed. By default, only user-created obje…psql › Usage › Meta-Commands \dconfigpsql CommandsPG18\dconfig[x+] [ pattern ] Lists server configuration parameters and their values. If pattern is specified, only parameters whose names match the pattern are listed. Without a pattern, only pa…psql › Usage › Meta-Commands \ddpsql CommandsPG18\dd[Sx] [ pattern ] Shows the descriptions of objects of type constraint, operator class, operator family, rule, and trigger. All other comments may be viewed by the respective backslash com…psql › Usage › Meta-Commands \ddppsql CommandsPG18\ddp[x] [ pattern ] Lists default access privilege settings. An entry is shown for each role (and schema, if applicable) for which the default privilege settings have been changed from the b…psql › Usage › Meta-Commands \despsql CommandsPG18\des[x+] [ pattern ] Lists foreign servers (mnemonic: “external servers”). If pattern is specified, only those servers whose name matches the pattern are listed. If x is appended to the comm…psql › Usage › Meta-Commands \detpsql CommandsPG18\det[x+] [ pattern ] Lists foreign tables (mnemonic: “external tables”). If pattern is specified, only entries whose table name or schema name matches the pattern are listed. If x is appende…psql › Usage › Meta-Commands \deupsql CommandsPG18\deu[x+] [ pattern ] Lists user mappings (mnemonic: “external users”). If pattern is specified, only those mappings whose user names match the pattern are listed. If x is appended to the com…psql › Usage › Meta-Commands \dewpsql CommandsPG18\dew[x+] [ pattern ] Lists foreign-data wrappers (mnemonic: “external wrappers”). If pattern is specified, only those foreign-data wrappers whose name matches the pattern are listed. If x is…psql › Usage › Meta-Commands \dfpsql CommandsPG18\df[anptwSx+] [ pattern [ arg_pattern ... ] ] Lists functions, together with their result data types, argument data types, and function types, which are classified as “agg” (aggregate), “nor…psql › Usage › Meta-Commands \dgpsql CommandsPG18\dg[Sx+] [ pattern ] Lists database roles. (Since the concepts of “users” and “groups” have been unified into “roles”, this command is now equivalent to \du.) By default, only user-created r…psql › Usage › Meta-Commands \dlpsql CommandsPG18\dl[x+] This is an alias for \lo_list, which shows a list of large objects. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command …psql › Usage › Meta-Commands \dnpsql CommandsPG18\dn[Sx+] [ pattern ] Lists schemas (namespaces). If pattern is specified, only schemas whose names match the pattern are listed. By default, only user-created objects are shown; supply a pat…psql › Usage › Meta-Commands \dopsql CommandsPG18\do[Sx+] [ pattern [ arg_pattern [ arg_pattern ] ] ] Lists operators with their operand and result types. If pattern is specified, only operators whose names match the pattern are listed. If…psql › Usage › Meta-Commands \dppsql CommandsPG18\dp[Sx] [ pattern ] Lists tables, views and sequences with their associated access privileges. If pattern is specified, only tables, views and sequences whose names match the pattern are lis…psql › Usage › Meta-Commands \drdspsql CommandsPG18\drds[x] [ role-pattern [ database-pattern ] ] Lists defined configuration settings. These settings can be role-specific, database-specific, or both. role-pattern and database-pattern are us…psql › Usage › Meta-Commands \drgpsql CommandsPG18\drg[Sx] [ pattern ] Lists information about each granted role membership, including assigned options (ADMIN, INHERIT and/or SET) and grantor. See the GRANT command for information about rol…psql › Usage › Meta-Commands \dupsql CommandsPG18\du[Sx+] [ pattern ] Lists database roles. (Since the concepts of “users” and “groups” have been unified into “roles”, this command is now equivalent to \dg.) By default, only user-created r…psql › Usage › Meta-Commands \dxpsql CommandsPG18\dx[x+] [ pattern ] Lists installed extensions. If pattern is specified, only those extensions whose names match the pattern are listed. If x is appended to the command name, the results are…psql › Usage › Meta-Commands \dypsql CommandsPG18\dy[x+] [ pattern ] Lists event triggers. If pattern is specified, only those event triggers whose names match the pattern are listed. If x is appended to the command name, the results are d…psql › Usage › Meta-Commands \epsql CommandsPG18\e or \edit [ filename ] [ line_number ] If filename is specified, the file is edited; after the editor exits, the file's content is copied into the current query buffer. If no filename is g…psql › Usage › Meta-Commands \echopsql CommandsPG18\echo text [ ... ] Prints the evaluated arguments to standard output, separated by spaces and followed by a newline. This can be useful to intersperse information in the output of scripts. F…psql › Usage › Meta-Commands \efpsql CommandsPG18\ef [ function_description [ line_number ] ] This command fetches and edits the definition of the named function or procedure, in the form of a CREATE OR REPLACE FUNCTION or CREATE OR REPLAC…psql › Usage › Meta-Commands \encodingpsql CommandsPG18\encoding [ encoding ] Sets the client character set encoding. Without an argument, this command shows the current encoding.psql › Usage › Meta-Commands