pgsql数据库默认配置事务类型_PostgreSQL 修改设置数据库的默认用户以及权限.

postgres=# \?General

\copyright show PostgreSQL usage and distribution terms

\crosstabview [COLUMNS] execute query and display resultsincrosstab

\errverbose show most recent error message at maximum verbosity

\g [FILE] or ; execute query (and send results to file or|pipe)

\gexec execute query, then execute each valueinits result

\gset [PREFIX] execute query and store resultsinpsql variables

\gx [FILE]as\g, but forces expanded output mode

\q quit psql

\watch [SEC] execute query every SEC seconds

Help

\?[commands] show help on backslash commands

\? options show help on psql command-line options

\?variables show help on special variables

\h [NAME] help on syntax of SQL commands,* forall commands

Query Buffer

\e [FILE] [LINE] edit the query buffer (or file) with external editor

\ef [FUNCNAME [LINE]] edit function definition with external editor

\ev [VIEWNAME [LINE]] edit view 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

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

\echo [STRING] writestringto standard output

\i FILE execute commandsfromfile

\ir FILEas\i, but relative to location of current script

\o [FILE] send all query results to file or|pipe

\qecho [STRING] writestringto query output stream (see \o)

Conditional

\ifEXPR begin conditional block

\elif EXPR alternative within current conditional block

\elsefinal alternative within current conditional block

\endif end conditional block

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[S] [PATTERN] list aggregates

\dA[+] [PATTERN] list access methods

\db[+] [PATTERN] list tablespaces

\dc[S+] [PATTERN] list conversions

\dC[+] [PATTERN] list casts

\dd[S] [PATTERN] showobjectdescriptions not displayed elsewhere

\dD[S+] [PATTERN] list domains

\ddp [PATTERN] listdefaultprivileges

\dE[S+] [PATTERN] list foreign tables

\det[+] [PATTERN] list foreign tables

\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[S+] [PATTERN] list roles

\di[S+] [PATTERN] list indexes

\dl list large objects, sameas\lo_list

\dL[S+] [PATTERN] list procedural languages

\dm[S+] [PATTERN] list materialized views

\dn[S+] [PATTERN] list schemas

\do[S] [PATTERN] list operators

\dO[S+] [PATTERN] list collations

\dp [PATTERN] list table, view, and sequence access privileges

\drds [PATRN1 [PATRN2]] list per-database role settings

\dRp[+] [PATTERN] list replication publications

\dRs[+] [PATTERN] list replication subscriptions

\ds[S+] [PATTERN] list sequences

\dt[S+] [PATTERN] list tables

\dT[S+] [PATTERN] list data types

\du[S+] [PATTERN] list roles

\dv[S+] [PATTERN] list views

\dx[+] [PATTERN] list extensions

\dy [PATTERN] listeventtriggers

\l[+] [PATTERN] list databases

\sf[+] FUNCNAME show a function‘s definition

\sv[+] VIEWNAME show a view‘s definition

\z [PATTERN] same as\dp

Formatting

\a toggle between unaligned and aligned output mode

\C [STRING]set table title, or unset ifnone

\f [STRING] show orset field separator forunaligned query output

\H toggle HTML output mode (currently off)

\pset [NAME [VALUE]]settable output option

(NAME := {border|columns|expanded|fieldsep|fieldsep_zero|footer|format|linestyle|null|numericlocale|pager|pager_min_lines|recordsep|recordsep_zero|tableattr|title|tuples_only|unicode_border_linestyle|unicode_column_linestyle|unicode_header_linestyle})

\t [on|off] show only rows (currently off)

\T [STRING]set HTML

\x [on|off|auto] toggle expanded output (currently off)

Connection

\c[onnect] {[DBNAME|- USER|- HOST|- PORT|-] |conninfo}

connect tonew database (currently "postgres")

\conninfo display information about current connection

\encoding [ENCODING] show orsetclient encoding

\password [USERNAME] securely change the passwordfora user

Operating System

\cd [DIR] change the current working directory

\setenv NAME [VALUE]setor unset environment variable

\timing [on|off] toggle timing of commands (currently off)

\! [COMMAND] execute command inshell or start interactive shell

Variables

\prompt [TEXT] NAME prompt user toset internalvariable

\set [NAME [VALUE]] set internal variable, or list all ifno parameters

\unset NAME unset (delete)internalvariable

Large Objects

\lo_export LOBOID FILE

\lo_import FILE [COMMENT]

\lo_list

\lo_unlink LOBOID largeobject operations