PostgreSQL краткая справка по помощи: различия между версиями

Материал из support.qbpro.ru
imported>Vix
(Новая страница: «General \copyright show PostgreSQL usage and distribution terms \g [FILE] or ; execute query (and send results to file or |pipe) \h [NAM…»)
 
imported>Vix
Нет описания правки
 
Строка 84: Строка 84:
   \lo_list
   \lo_list
   \lo_unlink LOBOID      large object operations
   \lo_unlink LOBOID      large object operations
'''ДОПОЛНИТЕЛЬНОЕ:'''
<hr>
* [https://www.oslogic.ru/knowledge/598/shpargalka-po-osnovnym-komandam-postgresql/ Шпаргалка по основным командам PostgreSQL]

Текущая версия от 22:38, 17 октября 2019

General

 \copyright             show PostgreSQL usage and distribution terms
 \g [FILE] or ;         execute query (and send results to file or |pipe)
 \h [NAME]              help on syntax of SQL commands, * for all commands
 \q                     quit psql

Query Buffer

 \e [FILE]              edit the query buffer (or file) with external editor
 \ef [FUNCNAME]         edit function definition with external editor
 \p                     show the contents of the query buffer
 \r                     reset (clear) the query buffer
 \s [FILE]              display history or save it to file
 \w FILE                write query buffer to file

Input/Output

 \copy ...              perform SQL COPY with data stream to the client host
 \echo [STRING]         write string to standard output
 \i FILE                execute commands from file
 \o [FILE]              send all query results to file or |pipe
 \qecho [STRING]        write string to query output stream (see \o)

Informational

 (options: S = show system objects, + = additional detail)
 \d[S+]                 list tables, views, and sequences
 \d[S+]  NAME           describe table, view, sequence, or index
 \da[+]  [PATTERN]      list aggregates
 \db[+]  [PATTERN]      list tablespaces
 \dc[S]  [PATTERN]      list conversions
 \dC     [PATTERN]      list casts
 \dd[S]  [PATTERN]      show comments on objects
 \dD[S]  [PATTERN]      list domains
 \des[+] [PATTERN]      list foreign servers
 \deu[+] [PATTERN]      list user mappings
 \dew[+] [PATTERN]      list foreign-data wrappers
 \df[antw][S+] [PATRN]  list [only agg/normal/trigger/window] functions
 \dF[+]  [PATTERN]      list text search configurations
 \dFd[+] [PATTERN]      list text search dictionaries
 \dFp[+] [PATTERN]      list text search parsers
 \dFt[+] [PATTERN]      list text search templates
 \dg[+]  [PATTERN]      list roles (groups)
 \di[S+] [PATTERN]      list indexes
 \dl                    list large objects, same as \lo_list
 \dn[+]  [PATTERN]      list schemas
 \do[S]  [PATTERN]      list operators
 \dp     [PATTERN]      list table, view, and sequence access privileges
 \ds[S+] [PATTERN]      list sequences
 \dt[S+] [PATTERN]      list tables
 \dT[S+] [PATTERN]      list data types
 \du[+]  [PATTERN]      list roles (users)
 \dv[S+] [PATTERN]      list views
 \l[+]                  list all databases
 \z      [PATTERN]      same as \dp

Formatting

 \a                     toggle between unaligned and aligned output mode
 \C [STRING]            set table title, or unset if none
 \f [STRING]            show or set field separator for unaligned query output
 \H                     toggle HTML output mode (currently off)
 \pset NAME [VALUE]     set table output option (NAME := {format|border|expanded|fieldsep|footer|null|
                        numericlocale|recordsep|tuples_only|title|tableattr|pager})
 \t [on|off]            show only rows (currently off)
 \T [STRING]            set HTML <table> tag attributes, or unset if none
 \x [on|off]            toggle expanded output (currently off)

Connection

 \c[onnect] [DBNAME|- USER|- HOST|- PORT|-]
                        connect to new database (currently "postgres")
 \encoding [ENCODING]   show or set client encoding
 \password [USERNAME]   securely change the password for a user

Operating System

 \cd [DIR]              change the current working directory
 \timing [on|off]       toggle timing of commands (currently off)
 \! [COMMAND]           execute command in shell or start interactive shell

Variables

 \prompt [TEXT] NAME    prompt user to set internal variable
 \set [NAME [VALUE]]    set internal variable, or list all if no parameters
 \unset NAME            unset (delete) internal variable

Large Objects

 \lo_export LOBOID FILE
 \lo_import FILE [COMMENT]
 \lo_list
 \lo_unlink LOBOID      large object operations

ДОПОЛНИТЕЛЬНОЕ: