3784502784

f Andrzej Leśnicki Laboratorium Baz Danych, PostgreSQL. Ćwiczenie 1

list data types list roles (users) list views list all databases same as \dp

\dT[S+] [PATTERN] \du[+] [PATTERN] \dv[S+] [PATTERN] \1[+]

\z [PATTERN]

Formatting

\a

\C [STRING]

\f [STRING]

\H

\pset NAME [YALUE]

\t [on|off]

\T [STRING] \x [on|off]

toggle between unaligned and aligned output modę set table title, or unset if nonę

show or set field separator for unaligned query output toggle HTML output modę (currently off) set table output option

(NAME := {format|border|expanded|fieldsep|footer|null| numericlocale|recordsep|tuples_only|title|tableattr|pager}) show only rows (currently off) set HTML <table> tag attributes, or unset if nonę toggle expanded output (currently off)

Connection

\c[onnect] [DBNAME|- USER|- HOST|- PORT|-]

connect to new database (currently "student 123") \encoding [ENCODING] show or set client encoding \password [USERNAME] securely change the password for a user

Operating System \cd [DIR]

\timing [on|off]

W [COMMAND]

change the current working directory toggle timing of commands (currently off) 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

Mo unlink LOBOID large object operations