imported>Vix |
imported>Vix |
| Строка 1: |
Строка 1: |
| General
| | ==Драйвера от Microsoft== |
| \copyright show PostgreSQL usage and distribution terms
| | [http://www.catalog.update.microsoft.com/Search.aspx?q=hp%201100 центр обновлений] |
| \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
| | *[https://technet.microsoft.com/ru-ru/library/ff800798(v=ws.11).aspx как использовать обновления] |
| \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
| | ==Как перенести Windows 7 на другой компьютер с установленными программами?== |
| \copy ... perform SQL COPY with data stream to the client host
| | [[Win7]] |
| \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
| | ==[[Перенос профиля пользователя windows 7,8]]== |
| (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
| | ==[[WinXp разрешение установки драйверов пользователю]]== |
| \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)
| |
| <nowiki> \T [STRING] set HTML <table> tag attributes, or unset if none
| |
| \x [on|off] toggle expanded output (currently off)</nowiki>
| |
|
| |
|
| Connection
| | ==[[Windows terminal server]]== |
| \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
| | ==[[Восстановление ключа на Крипто Про 3.6.x]]== |
| \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
| | ==[[Windows 8 или тихий ужос для пользователя]]== |
| \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
| | ==[[Домены Win - обходы]]== |
| \lo_export LOBOID FILE
| |
| \lo_import FILE [COMMENT]
| |
| \lo_list
| |
| \lo_unlink LOBOID large object operations
| |
|
| |
|
| '''ДОПОЛНИТЕЛЬНОЕ:'''
| | ==[[OEM-активация Windows Vista/7/8/8.1 под гипервизором QEMU]]== |
| <hr>
| | |
| * [https://www.oslogic.ru/knowledge/598/shpargalka-po-osnovnym-komandam-postgresql/ Шпаргалка по основным командам PostgreSQL]
| | ==[[Hotfix - terminal server win]]== |
| | |
| | ==[[Cmd codepage]]== |
| | |
| | ==[https://docs.microsoft.com/ru-ru/?mfr=true Документация]== |
| | ==[[Запуск Windows под Linux KVM]]== |
| | |
| | ==[[Win2003]]== |
