3784502783

f Andrzej Leśnicki

Laboratorium Baz Danych, PostgreSQL. Ćwiczenie 1

17/20

Dodatek 1.2. Lista poleceń wewnętrznych (meta-polecenia) języka PostgreSQL (uzyskana poleceniem \?)

General \copyright \g [FILE] or; \h [NAME]

show PostgreSQL usage and distribution terms execute query (and send results to file or |pipe) help on syntax of SQL commands, * for all commands quit psql

Query Buffer \e [FILE]

\ef [FUNCNAME]

\s [FILE]

\w FILE

edit the query buffer (or file) with external editor

edit fiinction definition with external editor

show the contents of the query buffer

reset (elear) the query buffer

display history or save it to file

write query buffer to file

Input/Output

\copy...

\echo [STRING] \i FILE \o [FILE]

\qecho [STRING]

perform SQL COPY with data stream to the Client host

write string to standard output

execute commands from file

send all query results to file or |pipe

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