psqlコマンド一覧

PostgreSQL

PostgreSQLをプロンプトから操作するときに使うpsqlコマンドのヘルプのコピペ

General

コマンド 効果
\c[onnect] [DBNAME｜- USER｜- HOST｜- PORT｜-] connect to new database (currently "postgres")
\cd [DIR] change the current working directory
\copyright show PostgreSQL usage and distribution terms
\encoding [ENCODING] show or set client encoding
\h [NAME] help on syntax of SQL commands, * for all commands
\prompt [TEXT] NAME prompt user to set internal variable
\q quit psql
\set [NAME [VALUE]] set internal variable, or list all if no parameters
\timing toggle timing of commands (currently off)
\unset NAME unset (delete) internal variable
\! [COMMAND] execute command in shell or start interactive shell

Query Buffer

コマンド 効果
\e [FILE] edit the query buffer (or file) with external editor
\g [FILE] send query buffer to server (and results to file or ｜pipe)
\p show the contents of the query buffer
\r reset (clear) the query buffer
\w FILE write query buffer to file

Input/Output

コマンド 効果
\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

コマンド 効果
\d [NAME] describe table, index, sequence, or view
\d{t｜i｜s｜v｜S} [PATTERN] (add "+" for more detail)list tables/indexes/sequences/views/system tables
\da [PATTERN] list aggregate functions
\db [PATTERN] list tablespaces (add "+" for more detail)
\dc [PATTERN] list conversions
\dC list casts
\dd [PATTERN] show comment for object
\dD [PATTERN] list domains
\df [PATTERN] list functions (add "+" for more detail)
\dF [PATTERN] list text search configurations (add "+" for more detail)
\dFd [PATTERN] list text search dictionaries (add "+" for more detail)
\dFt [PATTERN] list text search templates
\dFp [PATTERN] list text search parsers (add "+" for more detail)
\dg [PATTERN] list groups
\dn [PATTERN] list schemas (add "+" for more detail)
\do [NAME] list operators
\dl list large objects, same as \lo_list
\dp [PATTERN] list table, view, and sequence access privileges
\dT [PATTERN] list data types (add "+" for more detail)
\du [PATTERN] list users
\l list all databases (add "+" for more detail)
\z [PATTERN] list table, view, and sequence access privileges (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｜numeric｜ocale｜recordsep｜tuples_only｜title｜tableattr｜pager})
\t show only rows (currently off)
\T [STRING] set HTML table tag attributes, or unset if none
\x toggle expanded output (currently off)

Copy, Large Object

コマンド 効果
\copy ... perform SQL COPY with data stream to the client host
\lo_export LOBOID FILE
\lo_import FILE [COMMENT]
\lo_list ?
\lo_unlink LOBOID large object operations

Vimで画面分割コマンド

Vim

複数のファイル編集するときとかvimを分割して同時に編集

コマンド 効果
:split(:sp) 画面を横に分割
:vsplit(:vsp) 画面を縦に分割
:split Tab,:vsplit Tab 分割したウィンドウで開くファイルを選べる
C-w h,j,k,l C-wでウィンドウ移動モードになり各キーに対応した方向のウィンドウに移動(無い場合無効)
:q カーソルのあるウィンドウを閉じる
:only カーソルのあるウィンドウ以外を閉じる
:qall すべてのウィンドウを閉じる