SQLсервер в Linux -самостоятельное освоение пакета


Листинг 4 2 Получение списка команд psql booktown=# \?



Листинг 4.2. Получение списка команд psql booktown=# \?

\а toggle between unaligned and aligned mode

\c[onnect] [dbname|- [user]]

connect to new database (currently 'booktown')

\C <title> table title

\copy... perform SQL COPY with data stream to the client machine

\copyright show PostgreSQL usage and distribution terms

\d <table> describe table (or view, index, sequence)

\d{t|i|s|v} list tables/indices/sequences/views

\d{p|S|l} list permissions/system tables/lobjects

\da list aggregates

\dd [object] list comment for table, type, function, or operator

\df list functions

\do list operators

\dT list data types

\e [file] edit the current query buffer or [file] with external editor

\echo <text> write text to stdout

\encoding <encoding> set client encoding

\f <sep> change field separator

\g [file] send query to backend (and results in [file] or (pipe)

\h [cmd] help on syntax of sql commands. * for all commands

\H toggle HTML mode (currently off)

\i<file> read and execute queries from <file>

\l list all databases

\lo_export. \lo_import, \lo_list. \lo_unlink

Targe object operations

\o [file] send all query results to [file], or (pipe

\p show the content of the current query buffer

\pset <opt> set table output <opt> = {format|border|expanded|fieldsep|

null|recordsep|tuples_only|title|tableattr|pagerj

\q quit psql

\qecho <text> write text to query output stream (see \o) .

\r reset (clear) the query buffer

\s [file] print history or save it in [file] \set <var> <value> set internal variable

\t show only rows (currently off)

\T <tags> HTML table tags

\unset <var> unset (delete) internal variable

\w <file> write current query buffer to a <file>

\x toggle expanded output (currently off)

\z list table access permissions

\! [cmd] shell escape or command









Начало  Назад  Вперед