Þ ü) (8 )8 § ?8 ç8 9
9 *9 < ;9 5 x9 A ®9 k ð9 7 \: K : ^ à: 2 ?; 4 r; N §; c ö; Q Z< O ¬< > ü< O ;= @ = 6 Ì= N > G R> 8 > A Ó> T ? ? j? L ª? A ÷? @ 9@ H z@ A Ã@ + A _ 1A 5 A 9 ÇA M B ; OB @ B K ÌB J C o cC > ÓC N D F aD $ šD & ÍD 9 ôD 7 .E 2 fE 4 E ) ÎE ; øE B 4F ) wF * ¡F * ÌF 2 ÷F . *G , YG 4 G I »G - H & 3H > ZH & H ( ÀH J éH ( 4I % ]I , I $ °I N ÕI 9 $J G ^J 5 ŠJ P ÜJ K -K L yK 4 ÆK , ûK q (L A L ? ÜL A M > ^M Ö M # tN F N 8 ßN < O M UO 7 £O B ÛO : P 4 YP ? P % ÎP ( ôP
Q
+Q
9Q GQ dQ gQ {Q $ Q # šQ % ÌQ * òQ R # >R < bR R > ÀR ÿR 6 S VS
kS ¥ vS : T WT cT mT ~T T ³ T O aU Ä ±U < vW Á ³X ý uY s\ Å ÿ\ } Å] C^ T P` V ¥` G üb Dc Ëd q je O Üj } ,k ªm / Xn 1 n - ºn l èn Uo V ío ß Dr j $s 4 s Äs Ös I ês
4t ?t Ó Pt $u
9u Du A Yu  u ^y }y y ò ¹y ¥ ¬| , R~ * ž ¬ y e ë ß 2 Ë . þ
é - # ² H J ] ^ ñ  P ` t à ð w Y f Ý D ] Ý ; û  Ÿ 0 Ò » C ¿ A E R X k u | ,  ٠å ï û % ¡ j '¡ Á ¡ * T¢ K ¢ I Ë¢ 9 £ O£ = p£ C ®£ k ò£ % ^€ < € P Á€ Q ¥ f d¥ 1 Ë¥ $ ý¥ ? "Š = bŠ ? Š ; àŠ < § , Y§ H § E ϧ A š C Wš ? š ; Ûš a © $ y© ; © F Ú© !ª 8ª Nª Wª cª oª & |ª ' £ª 7 ˪ 0 « 4« D« W« & r« ) « ë Ì« Õ« e ß« E¬ V¬ k¬
¬ ¬ ² » Õ ê ® ® ® !µ *µ <µ Iµ Xµ hµ qµ Ä tµ 9¶
C¶ Q¶ Z¶ i¶ r¶ w¶
¶
¶ ¶ & ¶ Ô¶ චç ð¶ Ø· á·
ð·
þ· ž ž
/ž =ž Qž dž vž ž ž Œž Ξ àž
òž ¹ ¹ " $¹ G¹ h¹ ¹ ¢¹ & ž¹ ß¹ + è¹ º º %º .º 8º Dº
Iº Tº O cº ³º º ຠõº » » '» 9» A» W» " ]» 2 » ³» É» è» ü» Œ
0Œ ;Œ TŒ
nŒ |Œ Œ . ±Œ < àŒ $ œ ' Bœ s jœ ÞÅ ÿÅ ? Æ _Æ zÆ Æ , šÆ ÕÆ æÆ òÆ Ç Ç Ç >Ç EÇ ? ^Ç Ç R ¥È øÈ É Ê & .Ê UÊ È vÊ ?Ë FË WË ' ^Ë Ë Ë Ë §Ë ³Ë ¿Ë ØË äË ìË øË Ì m Ì Ì
Ì Ì ²Ì
ËÌ ÖÌ çÌ ) óÌ Í &Í ! EÍ gÍ Í 9 Í = ÔÍ C Î > VÎ N Î 9 äÎ ; Ï ZÏ iÏ
xÏ Ï Ï §Ï
Ï žÏ ÔÏ óÏ Ð ,Ð & 6Ð ]Ð qÐ vÐ œ Ð LÑ 6 bÑ Ò ¡Ò žÒ ÂÒ í BÓ 0Ô :Ô
@Ô KÔ SÔ `Ô
qÔ ] |Ô À ÚÔ Õ / »Õ & ëÕ = Ö Û PÖ < ,Ù iÞ , uÞ ¢Þ ! ®Þ ÐÞ ðÞ ýÞ ß "ß " >ß aß 9 ß # Œß N àß /à Jà hà à à C à Úà % ëà á #á :á Vá % uá ! á ) œá / çá # â . ;â ! jâ - â ºâ % Ûâ 4 ã 1 6ã - hã / ã " Æã éã ' ä 1ä . Qä ! ä $ ¢ä * Çä + òä A å & `å 0 å . žå ) çå ) æ ;æ % Jæ # pæ C æ Øæ ÷æ
ç ) ,ç $ Vç " {ç ç $ ¿ç ! äç ( è ' /è Wè # rè ! è ( žè áè úè é 6é Lé gé qé
é é ¬é Ìé Þé þé ê 0ê Dê eê ! ê £ê ¹ê 2 Ìê ÿê ë 1ë Në oë 5 ë ¿ë Óë óë . ì 5ì & Mì # tì ì ! žì Úì ïì í ) í Dí & [í í í ·í Ôí " æí î 1 î Dî . \î î
î £î ©î œî * Òî ýî $ ï <ï Iï Vï Yï jï qï zï ~ï ï
ï ï §ï ! ¹ï 4 Ûï
ð . ð Mð
]ð kð ð ð €ð »ð " Ëð îð ñ ñ ;ñ Qñ añ sñ ñ " ñ ¹ñ Ùñ õñ ò * $ò
Oò ]ò vò ò £ò ¶ò Ïò 0 éò > ó ) Yó " ó Šó ¿ó Äó 9 Íó 2 ô 6 :ô V qô & Èô & ïô õ õ %õ ! ?õ aõ gõ oõ xõ õ õ õ €õ šõ =÷ Ó V÷ *ø * Hø sø
ø J ø C æø O *ù zù I ú R Uú b šú < û U Hû r û } ü ` ü Y ðü V Jý ¡ý J :þ O
þ j Õþ _ @ÿ I ÿ b êÿ M Y Ö _ 0 d g õ ` ] ] Ÿ . k K C · F û a B [ € A b B M ¥ ó < Ã A J 8 8 Å D þ J C M V Ü ; 3 U o l Å 8 2
D k
; °
G ì
; 4 G p J ž l J p A » X ý ; V
6
g É
> 1 ; p G ¬ 8 ô f - < ? Ñ ± w E P œ L = [ d 2 < L Ô ] ! Ú Z ] { H Ù I " s l 4 à N 2 d U 6 í * $ D O š ¹ Ê ê í V 2 c 3 G Ê 5 2 H w { 5 ó Q ) 8 { V Ž Ø 8 D V n
w
£
À } Ë l I ¶! B# I$ â' 4 ( Õ Å) * m º- Å (. o î0 ÷ ^1 Ò V3 X )4 : ¿ ; Õ Ò= ? š> J è> G 3? {? € @ Ð @ - ~C
¬D C 2E vE E ] E úE F F ) !G KG dG S G ØG * ÛL M 1 $M Ñ VM (Q N ,S {T U Ë W € éW 4 X | ÃZ T @\ \ _ ®] £ ` Ä ²` c wa e Ûa w Ab Ñ ¹b s c ± ÿc ±d Äg j ^h Éj Ï ^k œ .n v ìn ¬ co / p i @q \ ªr Ó t t Ûz w P{ È{ á{
î{ ü{ | ! | 4 5| j| || | | µ| 3 Ì|
} Ä } * K~ ^ v~ _ Õ~ G 5 2 } H ° ^ ù
X 0 Þ M s ] t Ñ u F 3 Œ , ð Q H o M ž = G D 9 M Æ J
I _
T ©
Q þ
F P g , ÿ C , K p , Œ + é ( / 6 E = > =  @ A ` : 5 Õ + ; ' Ç ï
) 8 G
1 œ Ù
í û ³ ¶ Ÿ Þ ñ
, : Û = ! < P X _ i
R ¯ 3 ; B _ {
Š ¹ Ï â û $ $ I V f ¥ ! Ä $ æ $ - 0 ! ^ ; Œ - à ñ þ 9 @ M Z í : ú ( 5 ^ } % ¬ Ò + â . P G ' 9 À , ú 4 ' ! \ ~ + . Œ ë ' H - E v > Œ . û " * M , j© © I ·© . ª 2 0ª cª I pª ºª Ъ ݪ êª ÷ª - «
D« " O« D r« C ·« V û¬ R ß ® 3 ¡® ) Õ® ô ÿ® ô¯ ° ° E #° * i° ° ° š° »° # Ë° ï° ÿ°
± ± 0± x K± ı ѱ % æ± 7 ² D² ]² {² 9 ² ˲ Þ² # ÿ² # #³ & G³ G n³ \ ¶³ m Ž j Ž ìŽ j lµ _ ×µ 7¶ H¶ i¶ ¶ 1 ©¶ Û¶ è¶ ' ø¶ * · K· - j·
· / £· , Ó· ž ( ž K -ž ) y¹ L £¹ ðº ÿº » ,» ü Æ» ÃŒ ÓŒ ׌ ߌ ïŒ œ œ œ h »œ = $¿ : b¿ 0 ¿ [ ο *À 2à ¿È > ËÈ
É 6 É ' QÉ yÉ É # É ( ŽÉ ) ÝÉ " Ê T *Ê K Ê c ËÊ ( /Ë 0 XË 9 Ë ÃË ÓË f àË 0 GÌ 9 xÌ ! ²Ì - ÔÌ ' Í ? *Í ? jÍ $ ªÍ ' ÏÍ 3 ÷Í +Î ' JÎ $ rÎ 0 Î $ ÈÎ 0 íÎ 0 Ï 0 OÏ 3 Ï < ŽÏ ! ñÏ Ð 0 /Ð ! `Ð $ Ð * §Ð ! ÒÐ * ôÐ - Ñ o MÑ = œÑ U ûÑ ? QÒ C Ò C ÕÒ Ó B 2Ó 0 uÓ m ŠÓ B Ô ' WÔ + Ô Q «Ô < ýÔ ? :Õ 3 zÕ 2 ®Õ F áÕ F (Ö / oÖ B Ö ; âÖ E × G d× - ¬× . Ú× 0 Ø * :Ø * eØ Ø 0 Ø ÎØ áØ $ ýØ $ "Ù ' GÙ $ oÙ 6 Ù $ ËÙ B ðÙ ' 3Ú 3 [Ú Ú * ®Ú N ÙÚ ! (Û * JÛ - uÛ ' £Û - ËÛ Z ùÛ $ TÜ 0 yÜ $ ªÜ ? ÏÜ 0 Ý 0 @Ý 3 qÝ 6 ¥Ý < ÜÝ ! Þ ! ;Þ ! ]Þ ? Þ ! ¿Þ 6 áÞ ' ß K @ß 0 ß œß N Öß %à c ,à $ à I µà ÿà á
á A á % bá ; á $ Äá < éá &â ?â ^â . aâ ⠣⠬⠳⠺â Äâ Úâ ñâ 9 ã Q Jã ã : Žã $ ïã ä 6 0ä gä ! ä - ¥ä Óä ' ïä * å Bå Xå $ wå å žå ×å ' óå ' æ * Cæ - næ 6 æ Óæ < ìæ )ç ! Bç dç ! ç ¢ç ! »ç $ Ýç f è < iè < Šè 9 ãè 3 é Qé [é K ké < ·é K ôé x @ê 6 ¹ê - ðê ë %ë 3 ,ë - `ë ë ë ²ë ! Áë ãë íë ÷ë ì i Ÿ H w Æ ã V u Ç ? £ " 0 q ) \ í ÿ M ã ¿ ¡ ž K 7 ý \ Ý 2 j
T Ô @ f [ ` " # » ë 2 ð @ Ç d g ¢ g 0 > ³ | Ê & + f 8 à a O < i Ö º © > = Ü k = % ~ \ T V < c 6 ø Ï F O ÿ þ ø Æ e A ( P C w P ¬ m t µ Ž H ü v © h ? ž Ó È B Ù è f æ M µ { ª 5 3 ù Û u ä Y Š s § æ ¬ × { p ð F Þ ( ª Þ q W e 7 1 X ² œ 0 / U N è r D - « ¯ É á Ð & Q º Ø ) € Ø ! # ³ È $ 2 î R ç ! 6 Ò ¹ b 4 I ± 1
£ h ° } 9 ( ` S Õ n Õ r Z < @ Ú G = ì , ] ï ' ç E ß ] o Y é 3 * à k Ò ; Ü M t d ` : R A ® ^ L Ý S ë Y ÷ / } _ 6 X g X ² Á Z Š x F « N â Ê [ ñ j 3 ' J Œ C e k Ì œ ^ m § ñ _ û w * W v å n s ! D p z ý / Ô ä ï G Ù U S K ^ , : ¿ ¯ û & x ) q ê * · o ¥ ó
À ~ ¡ Ó l Q ° Ñ - Ñ ß D . i J à 4 å $ I v ó 4 Î y ì · j Ÿ 8 c G t T Z Ë W Â Ã ; ö õ ® ò } ú # â L Ä ~ K B ô 7 + Ï Í Ì ò J u ù H á ¹ Ð | a U { % n É l š + _ ¢ d y » o % | ± Í I E Å y a 9 c s P m Ë
p Ä 5 Œ Î þ V ; ü ê Ú ¶ A õ í . À Ž $ l " € L
:
O é x ö ? 8 ¥ [ , - z š ¶ C × N î Q Ö . ÷ Å Â > Á b B '
z
9 h E 1 Û ú 5 ô b R ] r
Connection options:
For more information, type "\?" (for internal commands) or "\help" (for SQL
commands) from within psql, or consult the psql section in the PostgreSQL
documentation.
Input and output options:
Output format options:
Parser: "%s"
Parser: "%s.%s" (options: S = show system objects, + = additional detail)
--help show this help, then exit
--version output version information, then exit
-1 ("one"), --single-transaction
execute command file as a single transaction
-A, --no-align unaligned table output mode
-E, --echo-hidden display queries that internal commands generate
-F, --field-separator=STRING
set field separator (default: "%s")
-H, --html HTML table output mode
-L, --log-file=FILENAME send session log to file
-P, --pset=VAR[=ARG] set printing option VAR to ARG (see \pset command)
-R, --record-separator=STRING
set record separator (default: newline)
-S, --single-line single-line mode (end of line terminates SQL command)
-T, --table-attr=TEXT set HTML table tag attributes (e.g., width, border)
-U, --username=USERNAME database user name (default: "%s")
-W, --password force password prompt (should happen automatically)
-X, --no-psqlrc do not read startup file (~/.psqlrc)
-a, --echo-all echo all input from script
-c, --command=COMMAND run only single command (SQL or internal) and exit
-d, --dbname=DBNAME database name to connect to (default: "%s")
-e, --echo-queries echo commands sent to server
-f, --file=FILENAME execute commands from file, then exit
-h, --host=HOSTNAME database server host or socket directory (default: "%s")
-l, --list list available databases, then exit
-n, --no-readline disable enhanced command line editing (readline)
-o, --output=FILENAME send query results to file (or |pipe)
-p, --port=PORT database server port (default: "%s")
-q, --quiet run quietly (no messages, only query output)
-s, --single-step single-step mode (confirm each query)
-t, --tuples-only print rows only
-v, --set=, --variable=NAME=VALUE
set psql variable NAME to VALUE
-w, --no-password never prompt for password
-x, --expanded turn on expanded table output
\! [COMMAND] execute command in shell or start interactive shell
\C [STRING] set table title, or unset if none
\H toggle HTML output mode (currently %s)
\T [STRING] set HTML tag attributes, or unset if none
\a toggle between unaligned and aligned output mode
\c[onnect] [DBNAME|- USER|- HOST|- PORT|-]
connect to new database (currently "%s")
\cd [DIR] change the current working directory
\copy ... perform SQL COPY with data stream to the client host
\copyright show PostgreSQL usage and distribution terms
\dC [PATTERN] list casts
\dD[S] [PATTERN] list domains
\dF[+] [PATTERN] list text search configurations
\dFd[+] [PATTERN] list text search dictionaries
\dFp[+] [PATTERN] list text search parsers
\dFt[+] [PATTERN] list text search templates
\dT[S+] [PATTERN] list data types
\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
\dd[S] [PATTERN] show comments on objects
\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
\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
\du [PATTERN] list roles (users)
\dv[S+] [PATTERN] list views
\e [FILE] edit the query buffer (or file) with external editor
\echo [STRING] write string to standard output
\ef [FUNCNAME] edit function definition with external editor
\encoding [ENCODING] show or set client encoding
\f [STRING] show or set field separator for unaligned query output
\g [FILE] or ; execute query (and send results to file or |pipe)
\h [NAME] help on syntax of SQL commands, * for all commands
\i FILE execute commands from file
\l[+] list all databases
\lo_export LOBOID FILE
\lo_import FILE [COMMENT]
\lo_list
\lo_unlink LOBOID large object operations
\o [FILE] send all query results to file or |pipe
\p show the contents of the query buffer
\password [USERNAME] securely change the password for a user
\prompt [TEXT] NAME prompt user to set internal variable
\pset NAME [VALUE] set table output option
(NAME := {format|border|expanded|fieldsep|footer|null|
numericlocale|recordsep|tuples_only|title|tableattr|pager})
\q quit psql
\qecho [STRING] write string to query output stream (see \o)
\r reset (clear) the query buffer
\s [FILE] display history or save it to file
\set [NAME [VALUE]] set internal variable, or list all if no parameters
\t [on|off] show only rows (currently %s)
\timing [on|off] toggle timing of commands (currently %s)
\unset NAME unset (delete) internal variable
\w FILE write query buffer to file
\x [on|off] toggle expanded output (currently %s)
\z [PATTERN] same as \dp
psql [OPTION]... [DBNAME [USERNAME]]
as user "%s" at port "%s" on host "%s" %d connection %d connections %s %s (%s, server %s)
%s: %s
%s: cannot copy from/to a directory
%s: could not delete variable "%s"
%s: could not open log file "%s": %s
%s: could not set printing parameter "%s"
%s: could not set variable "%s"
%s: current transaction is aborted
%s: invalid encoding name or conversion procedure not found
%s: not connected to a database
%s: pg_strdup: cannot duplicate null pointer (internal error)
%s: unknown transaction status
%s: warning: extra command-line argument "%s" ignored
(%lu row) (%lu rows) (No rows)
***(Single step mode: verify command)*******************************************
%s
***(press return to proceed or enter x and return to cancel)********************
********* QUERY **********
%s
**************************
, clustered , invalid , predicate (%s) , tablespace "%s" ABORT [ WORK | TRANSACTION ] ALTER AGGREGATE name ( type [ , ... ] ) RENAME TO new_name
ALTER AGGREGATE name ( type [ , ... ] ) OWNER TO new_owner
ALTER AGGREGATE name ( type [ , ... ] ) SET SCHEMA new_schema ALTER CONVERSION name RENAME TO newname
ALTER CONVERSION name OWNER TO newowner ALTER DATABASE name [ [ WITH ] option [ ... ] ]
where option can be:
CONNECTION LIMIT connlimit
ALTER DATABASE name RENAME TO newname
ALTER DATABASE name OWNER TO new_owner
ALTER DATABASE name SET TABLESPACE new_tablespace
ALTER DATABASE name SET configuration_parameter { TO | = } { value | DEFAULT }
ALTER DATABASE name SET configuration_parameter FROM CURRENT
ALTER DATABASE name RESET configuration_parameter
ALTER DATABASE name RESET ALL ALTER DOMAIN name
{ SET DEFAULT expression | DROP DEFAULT }
ALTER DOMAIN name
{ SET | DROP } NOT NULL
ALTER DOMAIN name
ADD domain_constraint
ALTER DOMAIN name
DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ]
ALTER DOMAIN name
OWNER TO new_owner
ALTER DOMAIN name
SET SCHEMA new_schema ALTER FOREIGN DATA WRAPPER name
[ VALIDATOR valfunction | NO VALIDATOR ]
[ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ]) ]
ALTER FOREIGN DATA WRAPPER name OWNER TO new_owner ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] )
action [ ... ] [ RESTRICT ]
ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] )
RENAME TO new_name
ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] )
OWNER TO new_owner
ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] )
SET SCHEMA new_schema
where action is one of:
CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
IMMUTABLE | STABLE | VOLATILE
[ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER
COST execution_cost
ROWS result_rows
SET configuration_parameter { TO | = } { value | DEFAULT }
SET configuration_parameter FROM CURRENT
RESET configuration_parameter
RESET ALL ALTER GROUP groupname ADD USER username [, ... ]
ALTER GROUP groupname DROP USER username [, ... ]
ALTER GROUP groupname RENAME TO newname ALTER INDEX name RENAME TO new_name
ALTER INDEX name SET TABLESPACE tablespace_name
ALTER INDEX name SET ( storage_parameter = value [, ... ] )
ALTER INDEX name RESET ( storage_parameter [, ... ] ) ALTER OPERATOR CLASS name USING index_method RENAME TO newname
ALTER OPERATOR CLASS name USING index_method OWNER TO newowner ALTER OPERATOR FAMILY name USING index_method ADD
{ OPERATOR strategy_number operator_name ( op_type, op_type )
| FUNCTION support_number [ ( op_type [ , op_type ] ) ] funcname ( argument_type [, ...] )
} [, ... ]
ALTER OPERATOR FAMILY name USING index_method DROP
{ OPERATOR strategy_number ( op_type [ , op_type ] )
| FUNCTION support_number ( op_type [ , op_type ] )
} [, ... ]
ALTER OPERATOR FAMILY name USING index_method RENAME TO newname
ALTER OPERATOR FAMILY name USING index_method OWNER TO newowner ALTER OPERATOR name ( { lefttype | NONE } , { righttype | NONE } ) OWNER TO newowner ALTER ROLE name [ [ WITH ] option [ ... ] ]
where option can be:
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
| CREATEUSER | NOCREATEUSER
| INHERIT | NOINHERIT
| LOGIN | NOLOGIN
| CONNECTION LIMIT connlimit
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
| VALID UNTIL 'timestamp'
ALTER ROLE name RENAME TO newname
ALTER ROLE name SET configuration_parameter { TO | = } { value | DEFAULT }
ALTER ROLE name SET configuration_parameter FROM CURRENT
ALTER ROLE name RESET configuration_parameter
ALTER ROLE name RESET ALL ALTER SCHEMA name RENAME TO newname
ALTER SCHEMA name OWNER TO newowner ALTER SEQUENCE name [ INCREMENT [ BY ] increment ]
[ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ]
[ START [ WITH ] start ]
[ RESTART [ [ WITH ] restart ] ]
[ CACHE cache ] [ [ NO ] CYCLE ]
[ OWNED BY { table.column | NONE } ]
ALTER SEQUENCE name OWNER TO new_owner
ALTER SEQUENCE name RENAME TO new_name
ALTER SEQUENCE name SET SCHEMA new_schema ALTER SERVER servername [ VERSION 'newversion' ]
[ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ]
ALTER SERVER servername OWNER TO new_owner ALTER TABLE [ ONLY ] name [ * ]
action [, ... ]
ALTER TABLE [ ONLY ] name [ * ]
RENAME [ COLUMN ] column TO new_column
ALTER TABLE name
RENAME TO new_name
ALTER TABLE name
SET SCHEMA new_schema
where action is one of:
ADD [ COLUMN ] column type [ column_constraint [ ... ] ]
DROP [ COLUMN ] column [ RESTRICT | CASCADE ]
ALTER [ COLUMN ] column [ SET DATA ] TYPE type [ USING expression ]
ALTER [ COLUMN ] column SET DEFAULT expression
ALTER [ COLUMN ] column DROP DEFAULT
ALTER [ COLUMN ] column { SET | DROP } NOT NULL
ALTER [ COLUMN ] column SET STATISTICS integer
ALTER [ COLUMN ] column SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }
ADD table_constraint
DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ]
DISABLE TRIGGER [ trigger_name | ALL | USER ]
ENABLE TRIGGER [ trigger_name | ALL | USER ]
ENABLE REPLICA TRIGGER trigger_name
ENABLE ALWAYS TRIGGER trigger_name
DISABLE RULE rewrite_rule_name
ENABLE RULE rewrite_rule_name
ENABLE REPLICA RULE rewrite_rule_name
ENABLE ALWAYS RULE rewrite_rule_name
CLUSTER ON index_name
SET WITHOUT CLUSTER
SET WITH OIDS
SET WITHOUT OIDS
SET ( storage_parameter = value [, ... ] )
RESET ( storage_parameter [, ... ] )
INHERIT parent_table
NO INHERIT parent_table
OWNER TO new_owner
SET TABLESPACE new_tablespace ALTER TABLESPACE name RENAME TO newname
ALTER TABLESPACE name OWNER TO newowner ALTER TEXT SEARCH CONFIGURATION name
ADD MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]
ALTER TEXT SEARCH CONFIGURATION name
ALTER MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]
ALTER TEXT SEARCH CONFIGURATION name
ALTER MAPPING REPLACE old_dictionary WITH new_dictionary
ALTER TEXT SEARCH CONFIGURATION name
ALTER MAPPING FOR token_type [, ... ] REPLACE old_dictionary WITH new_dictionary
ALTER TEXT SEARCH CONFIGURATION name
DROP MAPPING [ IF EXISTS ] FOR token_type [, ... ]
ALTER TEXT SEARCH CONFIGURATION name RENAME TO newname
ALTER TEXT SEARCH CONFIGURATION name OWNER TO newowner ALTER TEXT SEARCH DICTIONARY name (
option [ = value ] [, ... ]
)
ALTER TEXT SEARCH DICTIONARY name RENAME TO newname
ALTER TEXT SEARCH DICTIONARY name OWNER TO newowner ALTER TEXT SEARCH PARSER name RENAME TO newname ALTER TEXT SEARCH TEMPLATE name RENAME TO newname ALTER TRIGGER name ON table RENAME TO newname ALTER TYPE name RENAME TO new_name
ALTER TYPE name OWNER TO new_owner
ALTER TYPE name SET SCHEMA new_schema ALTER USER MAPPING FOR { username | USER | CURRENT_USER | PUBLIC }
SERVER servername
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ALTER USER name [ [ WITH ] option [ ... ] ]
where option can be:
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
| CREATEUSER | NOCREATEUSER
| INHERIT | NOINHERIT
| LOGIN | NOLOGIN
| CONNECTION LIMIT connlimit
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
| VALID UNTIL 'timestamp'
ALTER USER name RENAME TO newname
ALTER USER name SET configuration_parameter { TO | = } { value | DEFAULT }
ALTER USER name SET configuration_parameter FROM CURRENT
ALTER USER name RESET configuration_parameter
ALTER USER name RESET ALL ALTER VIEW name ALTER [ COLUMN ] column SET DEFAULT expression
ALTER VIEW name ALTER [ COLUMN ] column DROP DEFAULT
ALTER VIEW name OWNER TO new_owner
ALTER VIEW name RENAME TO new_name
ALTER VIEW name SET SCHEMA new_schema ALTER [ PROCEDURAL ] LANGUAGE name RENAME TO newname
ALTER [ PROCEDURAL ] LANGUAGE name OWNER TO new_owner ANALYZE [ VERBOSE ] [ table [ ( column [, ...] ) ] ] Access privileges Argument data types Asynchronous notification "%s" received from server process with PID %d.
Attributes Available help:
BEGIN [ WORK | TRANSACTION ] [ transaction_mode [, ...] ]
where transaction_mode is one of:
ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
READ WRITE | READ ONLY Border style is %d.
CHECKPOINT CLOSE { name | ALL } CLUSTER [VERBOSE] tablename [ USING indexname ]
CLUSTER [VERBOSE] COMMENT ON
{
TABLE object_name |
COLUMN table_name.column_name |
AGGREGATE agg_name (agg_type [, ...] ) |
CAST (sourcetype AS targettype) |
CONSTRAINT constraint_name ON table_name |
CONVERSION object_name |
DATABASE object_name |
DOMAIN object_name |
FUNCTION func_name ( [ [ argmode ] [ argname ] argtype [, ...] ] ) |
INDEX object_name |
LARGE OBJECT large_object_oid |
OPERATOR op (leftoperand_type, rightoperand_type) |
OPERATOR CLASS object_name USING index_method |
OPERATOR FAMILY object_name USING index_method |
[ PROCEDURAL ] LANGUAGE object_name |
ROLE object_name |
RULE rule_name ON table_name |
SCHEMA object_name |
SEQUENCE object_name |
TABLESPACE object_name |
TEXT SEARCH CONFIGURATION object_name |
TEXT SEARCH DICTIONARY object_name |
TEXT SEARCH PARSER object_name |
TEXT SEARCH TEMPLATE object_name |
TRIGGER trigger_name ON table_name |
TYPE object_name |
VIEW object_name
} IS 'text' COMMIT PREPARED transaction_id COMMIT [ WORK | TRANSACTION ] COPY data transfer failed: %s COPY tablename [ ( column [, ...] ) ]
FROM { 'filename' | STDIN }
[ [ WITH ]
[ BINARY ]
[ OIDS ]
[ DELIMITER [ AS ] 'delimiter' ]
[ NULL [ AS ] 'null string' ]
[ CSV [ HEADER ]
[ QUOTE [ AS ] 'quote' ]
[ ESCAPE [ AS ] 'escape' ]
[ FORCE NOT NULL column [, ...] ]
COPY { tablename [ ( column [, ...] ) ] | ( query ) }
TO { 'filename' | STDOUT }
[ [ WITH ]
[ BINARY ]
[ OIDS ]
[ DELIMITER [ AS ] 'delimiter' ]
[ NULL [ AS ] 'null string' ]
[ CSV [ HEADER ]
[ QUOTE [ AS ] 'quote' ]
[ ESCAPE [ AS ] 'escape' ]
[ FORCE QUOTE column [, ...] ] CREATE AGGREGATE name ( input_data_type [ , ... ] ) (
SFUNC = sfunc,
STYPE = state_data_type
[ , FINALFUNC = ffunc ]
[ , INITCOND = initial_condition ]
[ , SORTOP = sort_operator ]
)
or the old syntax
CREATE AGGREGATE name (
BASETYPE = base_type,
SFUNC = sfunc,
STYPE = state_data_type
[ , FINALFUNC = ffunc ]
[ , INITCOND = initial_condition ]
[ , SORTOP = sort_operator ]
) CREATE CAST (sourcetype AS targettype)
WITH FUNCTION funcname (argtypes)
[ AS ASSIGNMENT | AS IMPLICIT ]
CREATE CAST (sourcetype AS targettype)
WITHOUT FUNCTION
[ AS ASSIGNMENT | AS IMPLICIT ]
CREATE CAST (sourcetype AS targettype)
WITH INOUT
[ AS ASSIGNMENT | AS IMPLICIT ] CREATE CONSTRAINT TRIGGER name
AFTER event [ OR ... ]
ON table_name
[ FROM referenced_table_name ]
{ NOT DEFERRABLE | [ DEFERRABLE ] { INITIALLY IMMEDIATE | INITIALLY DEFERRED } }
FOR EACH ROW
EXECUTE PROCEDURE funcname ( arguments ) CREATE DATABASE name
[ [ WITH ] [ OWNER [=] dbowner ]
[ TEMPLATE [=] template ]
[ ENCODING [=] encoding ]
[ LC_COLLATE [=] lc_collate ]
[ LC_CTYPE [=] lc_ctype ]
[ TABLESPACE [=] tablespace ]
[ CONNECTION LIMIT [=] connlimit ] ] CREATE DOMAIN name [ AS ] data_type
[ DEFAULT expression ]
[ constraint [ ... ] ]
where constraint is:
[ CONSTRAINT constraint_name ]
{ NOT NULL | NULL | CHECK (expression) } CREATE FOREIGN DATA WRAPPER name
[ VALIDATOR valfunction | NO VALIDATOR ]
[ OPTIONS ( option 'value' [, ... ] ) ] CREATE GROUP name [ [ WITH ] option [ ... ] ]
where option can be:
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
| CREATEUSER | NOCREATEUSER
| INHERIT | NOINHERIT
| LOGIN | NOLOGIN
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
| VALID UNTIL 'timestamp'
| IN ROLE rolename [, ...]
| IN GROUP rolename [, ...]
| ROLE rolename [, ...]
| ADMIN rolename [, ...]
| USER rolename [, ...]
| SYSID uid CREATE OPERATOR CLASS name [ DEFAULT ] FOR TYPE data_type
USING index_method [ FAMILY family_name ] AS
{ OPERATOR strategy_number operator_name [ ( op_type, op_type ) ]
| FUNCTION support_number [ ( op_type [ , op_type ] ) ] funcname ( argument_type [, ...] )
| STORAGE storage_type
} [, ... ] CREATE OPERATOR FAMILY name USING index_method CREATE OPERATOR name (
PROCEDURE = funcname
[, LEFTARG = lefttype ] [, RIGHTARG = righttype ]
[, COMMUTATOR = com_op ] [, NEGATOR = neg_op ]
[, RESTRICT = res_proc ] [, JOIN = join_proc ]
[, HASHES ] [, MERGES ]
) CREATE ROLE name [ [ WITH ] option [ ... ] ]
where option can be:
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
| CREATEUSER | NOCREATEUSER
| INHERIT | NOINHERIT
| LOGIN | NOLOGIN
| CONNECTION LIMIT connlimit
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
| VALID UNTIL 'timestamp'
| IN ROLE rolename [, ...]
| IN GROUP rolename [, ...]
| ROLE rolename [, ...]
| ADMIN rolename [, ...]
| USER rolename [, ...]
| SYSID uid CREATE SCHEMA schemaname [ AUTHORIZATION username ] [ schema_element [ ... ] ]
CREATE SCHEMA AUTHORIZATION username [ schema_element [ ... ] ] CREATE SERVER servername [ TYPE 'servertype' ] [ VERSION 'serverversion' ]
FOREIGN DATA WRAPPER fdwname
[ OPTIONS ( option 'value' [, ... ] ) ] CREATE TABLESPACE tablespacename [ OWNER username ] LOCATION 'directory' CREATE TEXT SEARCH CONFIGURATION name (
PARSER = parser_name |
COPY = source_config
) CREATE TEXT SEARCH DICTIONARY name (
TEMPLATE = template
[, option = value [, ... ]]
) CREATE TEXT SEARCH PARSER name (
START = start_function ,
GETTOKEN = gettoken_function ,
END = end_function ,
LEXTYPES = lextypes_function
[, HEADLINE = headline_function ]
) CREATE TEXT SEARCH TEMPLATE name (
[ INIT = init_function , ]
LEXIZE = lexize_function
) CREATE TRIGGER name { BEFORE | AFTER } { event [ OR ... ] }
ON table [ FOR [ EACH ] { ROW | STATEMENT } ]
EXECUTE PROCEDURE funcname ( arguments ) CREATE TYPE name AS
( attribute_name data_type [, ... ] )
CREATE TYPE name AS ENUM
( 'label' [, ... ] )
CREATE TYPE name (
INPUT = input_function,
OUTPUT = output_function
[ , RECEIVE = receive_function ]
[ , SEND = send_function ]
[ , TYPMOD_IN = type_modifier_input_function ]
[ , TYPMOD_OUT = type_modifier_output_function ]
[ , ANALYZE = analyze_function ]
[ , INTERNALLENGTH = { internallength | VARIABLE } ]
[ , PASSEDBYVALUE ]
[ , ALIGNMENT = alignment ]
[ , STORAGE = storage ]
[ , LIKE = like_type ]
[ , CATEGORY = category ]
[ , PREFERRED = preferred ]
[ , DEFAULT = default ]
[ , ELEMENT = element ]
[ , DELIMITER = delimiter ]
)
CREATE TYPE name CREATE USER MAPPING FOR { username | USER | CURRENT_USER | PUBLIC }
SERVER servername
[ OPTIONS ( option 'value' [ , ... ] ) ] CREATE USER name [ [ WITH ] option [ ... ] ]
where option can be:
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
| CREATEUSER | NOCREATEUSER
| INHERIT | NOINHERIT
| LOGIN | NOLOGIN
| CONNECTION LIMIT connlimit
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
| VALID UNTIL 'timestamp'
| IN ROLE rolename [, ...]
| IN GROUP rolename [, ...]
| ROLE rolename [, ...]
| ADMIN rolename [, ...]
| USER rolename [, ...]
| SYSID uid CREATE [ DEFAULT ] CONVERSION name
FOR source_encoding TO dest_encoding FROM funcname CREATE [ OR REPLACE ] FUNCTION
name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } defexpr ] [, ...] ] )
[ RETURNS rettype
| RETURNS TABLE ( colname coltype [, ...] ) ]
{ LANGUAGE langname
| WINDOW
| IMMUTABLE | STABLE | VOLATILE
| CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
| [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER
| COST execution_cost
| ROWS result_rows
| SET configuration_parameter { TO value | = value | FROM CURRENT }
| AS 'definition'
| AS 'obj_file', 'link_symbol'
} ...
[ WITH ( attribute [, ...] ) ] CREATE [ OR REPLACE ] RULE name AS ON event
TO table [ WHERE condition ]
DO [ ALSO | INSTEAD ] { NOTHING | command | ( command ; command ... ) } CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] VIEW name [ ( column_name [, ...] ) ]
AS query CREATE [ PROCEDURAL ] LANGUAGE name
CREATE [ TRUSTED ] [ PROCEDURAL ] LANGUAGE name
HANDLER call_handler [ VALIDATOR valfunction ] CREATE [ TEMPORARY | TEMP ] SEQUENCE name [ INCREMENT [ BY ] increment ]
[ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ]
[ START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]
[ OWNED BY { table.column | NONE } ] CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] name ON table [ USING method ]
( { column | ( expression ) } [ opclass ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] )
[ WITH ( storage_parameter = value [, ... ] ) ]
[ TABLESPACE tablespace ]
[ WHERE predicate ] CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name
[ (column_name [, ...] ) ]
[ WITH ( storage_parameter [= value] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]
[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]
[ TABLESPACE tablespace ]
AS query
[ WITH [ NO ] DATA ] CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name ( [
{ column_name data_type [ DEFAULT default_expr ] [ column_constraint [ ... ] ]
| table_constraint
| LIKE parent_table [ { INCLUDING | EXCLUDING } { DEFAULTS | CONSTRAINTS | INDEXES } ] ... }
[, ... ]
] )
[ INHERITS ( parent_table [, ... ] ) ]
[ WITH ( storage_parameter [= value] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]
[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]
[ TABLESPACE tablespace ]
where column_constraint is:
[ CONSTRAINT constraint_name ]
{ NOT NULL |
NULL |
UNIQUE index_parameters |
PRIMARY KEY index_parameters |
CHECK ( expression ) |
REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ]
[ ON DELETE action ] [ ON UPDATE action ] }
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
and table_constraint is:
[ CONSTRAINT constraint_name ]
{ UNIQUE ( column_name [, ... ] ) index_parameters |
PRIMARY KEY ( column_name [, ... ] ) index_parameters |
CHECK ( expression ) |
FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [, ... ] ) ]
[ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE action ] [ ON UPDATE action ] }
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
index_parameters in UNIQUE and PRIMARY KEY constraints are:
[ WITH ( storage_parameter [= value] [, ... ] ) ]
[ USING INDEX TABLESPACE tablespace ] Cannot add cell to table content: total cell count of %d exceeded.
Cannot add header to table content: column count of %d exceeded.
Cannot login Check Check constraints: Collation Column Column access privileges Command: %s
Description: %s
Syntax:
%s
Composite type "%s.%s" Connection
Create DB Create role Ctype DEALLOCATE [ PREPARE ] { name | ALL } DECLARE name [ BINARY ] [ INSENSITIVE ] [ [ NO ] SCROLL ]
CURSOR [ { WITH | WITHOUT } HOLD ] FOR query DELETE FROM [ ONLY ] table [ [ AS ] alias ]
[ USING usinglist ]
[ WHERE condition | WHERE CURRENT OF cursor_name ]
[ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ] DISCARD { ALL | PLANS | TEMPORARY | TEMP } DROP AGGREGATE [ IF EXISTS ] name ( type [ , ... ] ) [ CASCADE | RESTRICT ] DROP CAST [ IF EXISTS ] (sourcetype AS targettype) [ CASCADE | RESTRICT ] DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP DATABASE [ IF EXISTS ] name DROP DOMAIN [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP FUNCTION [ IF EXISTS ] name ( [ [ argmode ] [ argname ] argtype [, ...] ] )
[ CASCADE | RESTRICT ] DROP GROUP [ IF EXISTS ] name [, ...] DROP INDEX [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP OPERATOR CLASS [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ] DROP OPERATOR FAMILY [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ] DROP OPERATOR [ IF EXISTS ] name ( { lefttype | NONE } , { righttype | NONE } ) [ CASCADE | RESTRICT ] DROP OWNED BY name [, ...] [ CASCADE | RESTRICT ] DROP ROLE [ IF EXISTS ] name [, ...] DROP RULE [ IF EXISTS ] name ON relation [ CASCADE | RESTRICT ] DROP SCHEMA [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP SEQUENCE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP SERVER [ IF EXISTS ] servername [ CASCADE | RESTRICT ] DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP TABLESPACE [ IF EXISTS ] tablespacename DROP TEXT SEARCH CONFIGURATION [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP TEXT SEARCH PARSER [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP TRIGGER [ IF EXISTS ] name ON table [ CASCADE | RESTRICT ] DROP TYPE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP USER MAPPING [ IF EXISTS ] FOR { username | USER | CURRENT_USER | PUBLIC } SERVER servername DROP USER [ IF EXISTS ] name [, ...] DROP VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ] Default footer is off. Default footer is on. Default? Description Destination Dictionaries Did not find any relation named "%s".
Did not find any relation with OID %s.
Did not find any text search configuration named "%s".
Did not find any text search parser named "%s".
Disabled rules: Disabled triggers: END [ WORK | TRANSACTION ] EXECUTE name [ ( parameter [, ...] ) ] EXPLAIN [ ANALYZE ] [ VERBOSE ] statement Elements Encoding End parse Enter data to be copied followed by a newline.
End with a backslash and a period on a line by itself. Enter it again: Enter new password: Expanded display is off.
Expanded display is on.
FETCH [ direction { FROM | IN } ] cursorname
where direction can be empty or one of:
NEXT
PRIOR
FIRST
LAST
ABSOLUTE count
RELATIVE count
count
ALL
FORWARD
FORWARD count
FORWARD ALL
BACKWARD
BACKWARD count
BACKWARD ALL Failed.
Field separator is "%s".
Foreign-data wrapper Foreign-key constraints: Formatting
Function GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }
[,...] | ALL [ PRIVILEGES ] }
ON [ TABLE ] tablename [, ...]
TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { { SELECT | INSERT | UPDATE | REFERENCES } ( column [, ...] )
[,...] | ALL [ PRIVILEGES ] ( column [, ...] ) }
ON [ TABLE ] tablename [, ...]
TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { { USAGE | SELECT | UPDATE }
[,...] | ALL [ PRIVILEGES ] }
ON SEQUENCE sequencename [, ...]
TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { { CREATE | CONNECT | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }
ON DATABASE dbname [, ...]
TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { USAGE | ALL [ PRIVILEGES ] }
ON FOREIGN DATA WRAPPER fdwname [, ...]
TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { USAGE | ALL [ PRIVILEGES ] }
ON FOREIGN SERVER servername [, ...]
TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { EXECUTE | ALL [ PRIVILEGES ] }
ON FUNCTION funcname ( [ [ argmode ] [ argname ] argtype [, ...] ] ) [, ...]
TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { USAGE | ALL [ PRIVILEGES ] }
ON LANGUAGE langname [, ...]
TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }
ON SCHEMA schemaname [, ...]
TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { CREATE | ALL [ PRIVILEGES ] }
ON TABLESPACE tablespacename [, ...]
TO { [ GROUP ] rolename | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT role [, ...] TO rolename [, ...] [ WITH ADMIN OPTION ] General
General options:
Get headline Get next token Get token types Has OIDs ID INSERT INTO table [ ( column [, ...] ) ]
{ DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) [, ...] | query }
[ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ] Implicit? Index "%s.%s" Indexes: Informational
Inherits Init Init options Input/Output
Internal name Interrupted
Invalid command \%s. Try \? for help.
LISTEN name LOAD 'filename' LOCK [ TABLE ] [ ONLY ] name [, ...] [ IN lockmode MODE ] [ NOWAIT ]
where lockmode is one of:
ACCESS SHARE | ROW SHARE | ROW EXCLUSIVE | SHARE UPDATE EXCLUSIVE
| SHARE | SHARE ROW EXCLUSIVE | EXCLUSIVE | ACCESS EXCLUSIVE Language Large Objects
Large objects Left arg type Lexize List of aggregate functions List of casts List of conversions List of data types List of databases List of domains List of foreign servers List of foreign-data wrappers List of functions List of operators List of relations List of roles List of schemas List of tablespaces List of text search configurations List of text search dictionaries List of text search parsers List of text search templates List of user mappings Locale-adjusted numeric output is off. Location MOVE [ direction { FROM | IN } ] cursorname Member of Method Modifier Modifiers NOTIFY name Name No changes No connections No help available for "%-.*s".
Try \h with no arguments to see available help.
No inheritance No matching relations found.
No relations found.
Null display is "%s".
Object Object descriptions Operating System
Options Output format is %s.
Owner PREPARE TRANSACTION transaction_id PREPARE name [ ( datatype [, ...] ) ] AS statement Pager is always used. Pager is used for long output. Pager usage is off. Password encryption failed.
Password for user %s: Password: Passwords didn't match.
Previous connection kept
Query Buffer
Query buffer is empty. Query buffer reset (cleared). REASSIGN OWNED BY old_role [, ...] TO new_role REINDEX { INDEX | TABLE | DATABASE | SYSTEM } name [ FORCE ] RELEASE [ SAVEPOINT ] savepoint_name RESET configuration_parameter
RESET ALL REVOKE [ GRANT OPTION FOR ]
{ { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }
[,...] | ALL [ PRIVILEGES ] }
ON [ TABLE ] tablename [, ...]
FROM { [ GROUP ] rolename | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ { SELECT | INSERT | UPDATE | REFERENCES } ( column [, ...] )
[,...] | ALL [ PRIVILEGES ] ( column [, ...] ) }
ON [ TABLE ] tablename [, ...]
FROM { [ GROUP ] rolename | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ { USAGE | SELECT | UPDATE }
[,...] | ALL [ PRIVILEGES ] }
ON SEQUENCE sequencename [, ...]
FROM { [ GROUP ] rolename | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ { CREATE | CONNECT | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }
ON DATABASE dbname [, ...]
FROM { [ GROUP ] rolename | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ USAGE | ALL [ PRIVILEGES ] }
ON FOREIGN DATA WRAPPER fdwname [, ...]
FROM { [ GROUP ] rolename | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ USAGE | ALL [ PRIVILEGES ] }
ON FOREIGN SERVER servername [, ...]
FROM { [ GROUP ] rolename | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ EXECUTE | ALL [ PRIVILEGES ] }
ON FUNCTION funcname ( [ [ argmode ] [ argname ] argtype [, ...] ] ) [, ...]
FROM { [ GROUP ] rolename | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ USAGE | ALL [ PRIVILEGES ] }
ON LANGUAGE langname [, ...]
FROM { [ GROUP ] rolename | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }
ON SCHEMA schemaname [, ...]
FROM { [ GROUP ] rolename | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ CREATE | ALL [ PRIVILEGES ] }
ON TABLESPACE tablespacename [, ...]
FROM { [ GROUP ] rolename | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ ADMIN OPTION FOR ]
role [, ...] FROM rolename [, ...]
[ CASCADE | RESTRICT ] ROLLBACK PREPARED transaction_id ROLLBACK [ WORK | TRANSACTION ] ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] savepoint_name Record separator is "%s".
Record separator is . Referenced by: Report bugs to .
Result data type Result type Right arg type Role name Rules firing always: Rules firing on replica only: Rules: SAVEPOINT savepoint_name SET CONSTRAINTS { ALL | name [, ...] } { DEFERRED | IMMEDIATE } SET TRANSACTION transaction_mode [, ...]
SET SESSION CHARACTERISTICS AS TRANSACTION transaction_mode [, ...]
where transaction_mode is one of:
ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
READ WRITE | READ ONLY SET [ SESSION | LOCAL ] ROLE rolename
SET [ SESSION | LOCAL ] ROLE NONE
RESET ROLE SET [ SESSION | LOCAL ] SESSION AUTHORIZATION username
SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT
RESET SESSION AUTHORIZATION SET [ SESSION | LOCAL ] configuration_parameter { TO | = } { value | 'value' | DEFAULT }
SET [ SESSION | LOCAL ] TIME ZONE { timezone | LOCAL | DEFAULT } SHOW name
SHOW ALL SSL connection (cipher: %s, bits: %i)
SSL connection (unknown cipher)
START TRANSACTION [ transaction_mode [, ...] ]
where transaction_mode is one of:
ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
READ WRITE | READ ONLY Schema Sequence "%s.%s" Server Showing locale-adjusted numeric output. Showing only tuples. Size Source Source code Source type Special relation "%s.%s" Start parse Storage Succeeded.
Superuser TOAST table "%s.%s" TRUNCATE [ TABLE ] [ ONLY ] name [, ... ]
[ RESTART IDENTITY | CONTINUE IDENTITY ] [ CASCADE | RESTRICT ] Table Table "%s.%s" Table attribute is "%s".
Table attributes unset.
Tablespace Tablespace: "%s" Target type Target width for "wrapped" format is %d.
Template Text search configuration "%s" Text search configuration "%s.%s" Text search parser "%s" Text search parser "%s.%s" The connection to the server was lost. Attempting reset: The server (version %d.%d) does not support foreign servers.
The server (version %d.%d) does not support foreign-data wrappers.
The server (version %d.%d) does not support full text search.
The server (version %d.%d) does not support savepoints for ON_ERROR_ROLLBACK.
The server (version %d.%d) does not support tablespaces.
The server (version %d.%d) does not support user mappings.
Time: %.3f ms
Timing is off. Timing is on. Title is "%s".
Title is unset.
Token Token name Token types for parser "%s" Token types for parser "%s.%s" Triggers firing always: Triggers firing on replica only: Triggers: Try "%s --help" for more information.
Tuples only is off. Type Type "help" for help.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
UNLISTEN { name | * } UPDATE [ ONLY ] table [ [ AS ] alias ]
SET { column = { expression | DEFAULT } |
( column [, ...] ) = ( { expression | DEFAULT } [, ...] ) } [, ...]
[ FROM fromlist ]
[ WHERE condition | WHERE CURRENT OF cursor_name ]
[ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ] Usage:
Use "\q" to leave %s.
User name VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ table ]
VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ table [ (column [, ...] ) ] ] VALUES ( expression [, ...] ) [, ...]
[ ORDER BY sort_expression [ ASC | DESC | USING operator ] [, ...] ]
[ LIMIT { count | ALL } ]
[ OFFSET start [ ROW | ROWS ] ]
[ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ] Validator Value Variables
Version View "%s.%s" View definition: Volatility WARNING: %s version %d.%d, server version %d.%d.
Some psql features might not work.
WARNING: Console code page (%u) differs from Windows code page (%u)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
Wrote history to file "%s/%s".
You are currently not connected to a database.
You are now connected to database "%s" You are using psql, the command-line interface to PostgreSQL. [ WITH [ RECURSIVE ] with_query [, ...] ]
SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
* | expression [ [ AS ] output_name ] [, ...]
INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table
[ FROM from_item [, ...] ]
[ WHERE condition ]
[ GROUP BY expression [, ...] ]
[ HAVING condition [, ...] ]
[ WINDOW window_name AS ( window_definition ) [, ...] ]
[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
[ ORDER BY expression [ ASC | DESC | USING operator ] [ NULLS { FIRST | LAST } ] [, ...] ]
[ LIMIT { count | ALL } ]
[ OFFSET start [ ROW | ROWS ] ]
[ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]
[ FOR { UPDATE | SHARE } [ OF table_name [, ...] ] [ NOWAIT ] [...] ] [ WITH [ RECURSIVE ] with_query [, ...] ]
SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
* | expression [ [ AS ] output_name ] [, ...]
[ FROM from_item [, ...] ]
[ WHERE condition ]
[ GROUP BY expression [, ...] ]
[ HAVING condition [, ...] ]
[ WINDOW window_name AS ( window_definition ) [, ...] ]
[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
[ ORDER BY expression [ ASC | DESC | USING operator ] [ NULLS { FIRST | LAST } ] [, ...] ]
[ LIMIT { count | ALL } ]
[ OFFSET start [ ROW | ROWS ] ]
[ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]
[ FOR { UPDATE | SHARE } [ OF table_name [, ...] ] [ NOWAIT ] [...] ]
where from_item can be one of:
[ ONLY ] table_name [ * ] [ [ AS ] alias [ ( column_alias [, ...] ) ] ]
( select ) [ AS ] alias [ ( column_alias [, ...] ) ]
with_query_name [ [ AS ] alias [ ( column_alias [, ...] ) ] ]
function_name ( [ argument [, ...] ] ) [ AS ] alias [ ( column_alias [, ...] | column_definition [, ...] ) ]
function_name ( [ argument [, ...] ] ) AS ( column_definition [, ...] )
from_item [ NATURAL ] join_type from_item [ ON join_condition | USING ( join_column [, ...] ) ]
and with_query is:
with_query_name [ ( column_name [, ...] ) ] AS ( select )
TABLE { [ ONLY ] table_name [ * ] | with_query_name } \!: failed
\%s: could not change directory to "%s": %s
\%s: error
\%s: extra argument "%s" ignored
\%s: missing required argument
\connect: %s \copy: %s \copy: arguments required
\copy: parse error at "%s"
\copy: parse error at end of line
\copy: unexpected response (%d)
\df does not take a "w" option with server version %d.%d
\df only takes [antwS+] as options
\pset: allowed formats are unaligned, aligned, wrapped, html, latex, troff-ms
\pset: unknown option: %s
abort the current transaction aborted because of read failure agg aggregate cancel a transaction that was earlier prepared for two-phase commit canceled by user cannot locate temporary directory: %s change a database change a database role change a run-time parameter change role name or membership change the definition of a conversion change the definition of a domain change the definition of a foreign server change the definition of a foreign-data wrapper change the definition of a function change the definition of a procedural language change the definition of a schema change the definition of a sequence generator change the definition of a table change the definition of a tablespace change the definition of a text search configuration change the definition of a text search dictionary change the definition of a text search parser change the definition of a text search template change the definition of a trigger change the definition of a type change the definition of a user mapping change the definition of a view change the definition of an aggregate function change the definition of an index change the definition of an operator change the definition of an operator class change the definition of an operator family change the ownership of database objects owned by a database role child process exited with exit code %d child process exited with unrecognized status %d child process was terminated by exception 0x%X child process was terminated by signal %d child process was terminated by signal %s close a cursor cluster a table according to an index collect statistics about a database commit a transaction that was earlier prepared for two-phase commit commit the current transaction compute a set of rows connection to server was lost
contains support for command-line editing copy data between a file and a table could not change directory to "%s" could not find a "%s" to execute could not get current user name: %s
could not get home directory: %s
could not identify current directory: %s could not open temporary file "%s": %s
could not read binary "%s" could not read from input file: %s
could not read symbolic link "%s" could not save history to file "%s": %s
could not start /bin/sh
could not start editor "%s"
could not write COPY data: %s
create a new database create new rows in a table data type deallocate a prepared statement default %s define a cursor define a new aggregate function define a new cast define a new constraint trigger define a new data type define a new database role define a new domain define a new encoding conversion define a new foreign server define a new foreign-data wrapper define a new function define a new index define a new mapping of a user to a foreign server define a new operator define a new operator class define a new operator family define a new procedural language define a new rewrite rule define a new savepoint within the current transaction define a new schema define a new sequence generator define a new table define a new table from the results of a query define a new tablespace define a new text search configuration define a new text search dictionary define a new text search parser define a new text search template define a new trigger define a new view define access privileges define or change the comment of an object delete rows of a table destroy a previously defined savepoint discard session state empty a table or set of tables execute a prepared statement for table "%s.%s" force a transaction log checkpoint function garbage-collect and optionally analyze a database generate a notification history is not supported by this installation
immutable in assignment index invalid binary "%s" invalid command \%s
invalid output format (internal error): %d listen for a notification load or reload a shared library file local socket lock a table no no query buffer
normal not null off on operator out of memory out of memory
position a cursor prepare a statement for execution prepare the current transaction for two-phase commit primary key, psql is the PostgreSQL interactive terminal.
rebuild indexes remove a cast remove a conversion remove a data type remove a database remove a database role remove a domain remove a foreign server descriptor remove a foreign-data wrapper remove a function remove a procedural language remove a rewrite rule remove a schema remove a sequence remove a table remove a tablespace remove a text search configuration remove a text search dictionary remove a text search parser remove a text search template remove a trigger remove a user mapping for a foreign server remove a view remove access privileges remove an aggregate function remove an index remove an operator remove an operator class remove an operator family remove database objects owned by a database role restore the value of a run-time parameter to the default value retrieve rows from a query using a cursor retrieve rows from a table or view roll back to a savepoint rule sequence set constraint checking modes for the current transaction set the characteristics of the current transaction set the current user identifier of the current session set the session user identifier and the current user identifier of the current session show the execution plan of a statement show the value of a run-time parameter special stable start a transaction block stop listening for a notification table trigger unique, update rows of a table view volatile window yes Project-Id-Version: PostgreSQL 8.3
Report-Msgid-Bugs-To: pgsql-bugs@postgresql.org
POT-Creation-Date: 2009-06-16 20:59+0900
PO-Revision-Date: 2009-06-16 21:03+0900
Last-Translator: HOTTA Michihide
Language-Team: jpug-doc
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Plural-Forms: nplurals=2; plural=(n > 1);
æ¥ç¶ãªãã·ã§ã³:
詳现㯠psql ã®äžã§ "\?" (å
éšã³ãã³ãã®å Žå) ãŸã㯠"\help"
(SQL ã³ãã³ãã®å Žå) ãã¿ã€ãããããPostgreSQL ããã¥ã¡ã³ãã® psql ã®
ã»ã¯ã·ã§ã³ãåç
§ã®ããšã
å
¥åºåãªãã·ã§ã³ïŒ
åºåãã©ãŒããããªãã·ã§ã³:
ããŒãµïŒ"%s"
ããŒãµïŒ "%s.%s" (修食å: S = ã·ã¹ãã ãªããžã§ã¯ãã衚瀺 + = 詳现æ
å ±)
--help ãã«ãã衚瀺ããçµäºããŸã
--version ããŒãžã§ã³æ
å ±ã衚瀺ããçµäºããŸã
-1(æ°åã®ïŒ), --single-transaction
åäžã®ãã©ã³ã¶ã¯ã·ã§ã³ãšããŠã³ãã³ããã¡ã€ã«ãå®è¡
-A, --no-align æ¡æãããªãããŒãã«åºåã¢ãŒã
-E, --echo-hidden å
éšã³ãã³ããçæããã¯ãšãªãŒã衚瀺
-F, --field-separator=æåå ãã£ãŒã«ãåºåãæåãèšå®(ããã©ã«ã: "%s")
-H, --html HTML ããŒãã«åºåã¢ãŒã
-L, --log-file=ãã¡ã€ã«å ã»ãã·ã§ã³ãã°ããã¡ã€ã«ã«åãåºã
-P, --pset=å€æ°[=å€] 衚瀺ãªãã·ã§ã³ 'å€æ°' ã 'å€' ã«ã»ãã (\pset ã³ãã³ããåç
§)
-R, --record-separator=æåå
ã¬ã³ãŒãåºåãæåãèšå®(ããã©ã«ãïŒæ¹è¡)
-S, --single-line åäžè¡ã¢ãŒã(è¡æ«ã SQL ã³ãã³ãã®çµäºãšã¿ãªã)
-T, --table-attr=TEXT HTMLããŒãã«ã®ã¿ã°å±æ§ãã»ãã(width, borderç)
-U, --username=åå ããŒã¿ããŒã¹ã®ãŠãŒã¶å(ããã©ã«ã: "%s")
-W, --password ãã¹ã¯ãŒãããã³ããã匷å¶è¡šç€ºãã
ïŒèªåçã«è¡šç€ºãããã¯ãã§ãïŒ
-X åæåãã¡ã€ã« (~/.psqlrc) ãèªã¿ããŸãªã
-a, --echo-all ã¹ã¯ãªããããã®ãã¹ãŠã®å
¥åã衚瀺
-c, --command=ã³ãã³ã (SQLãŸãã¯å
éšã®)åäžã³ãã³ããäžã€ã ãå®è¡ããŠçµäº
-d, --dbname=DBå æ¥ç¶ããããŒã¿ããŒã¹åãæå®(ããã©ã«ã: "%s")
-e, --echo-queries ãµãŒããžéä¿¡ããã³ãã³ãã衚瀺
-f, --file=ãã¡ã€ã«å ãã¡ã€ã«ããã³ãã³ããèªã¿èŸŒãã§å®è¡åŸãçµäº
-h, --host=ãã¹ãå ããŒã¿ããŒã¹ãµãŒãã®ãã¹ããŸãã¯ãœã±ããã®ãã£ã¬ã¯ããª(ããã©ã«ã: "%s")
-l(ãšã«), --list 䜿çšå¯èœãªããŒã¿ããŒã¹äžèŠ§ã衚瀺ããŠçµäº
-n, --no-readline æ¡åŒµã³ãã³ãã©ã€ã³ç·šéæ©èœ(readline)ãç¡å¹ã«ãã
-o, --output=ãã¡ã€ã«å ã¯ãšãªãŒã®çµæããã¡ã€ã«(ãŸã㯠|ãã€ã)ã«éã
-p, --port=ããŒãçªå· ããŒã¿ããŒã¹ãµãŒãã®ããŒãçªå·(ããã©ã«ãïŒ "%s")
-q, --quiet éãã«å®è¡(ã¡ãã»ãŒãžãªãã§ãã¯ãšãªãŒåºåã®ã¿)
-s, --single-step ã·ã³ã°ã«ã¹ãããã¢ãŒã(åã¯ãšãªãŒããšã«ç¢ºèª)
-t, --tuples-only è¡ã®ã¿ã衚瀺
-v, --set=, --variable=åå=å€
psql å€æ° 'åå' ã« 'å€' ãã»ãã
-w, --no-password ãã¹ã¯ãŒãå
¥åãèŠæ±ããªã
-x, --expanded æ¡åŒµããŒãã«åºåãæå¹ã«ãã
\! [ã³ãã³ã] ã·ã§ã«ã§ã³ãã³ããå®è¡ããããã¯äŒè©±åã·ã§ã«ãèµ·å
\C ã¿ã€ãã« ããŒãã«ã®ã¿ã€ãã«ãã»ãããæå®ããªããã°è§£é€
\H HTML ã®åºåã¢ãŒãããã°ã«(çŸåš: %s)
\T [æåå] HTML ã® ã¿ã°ã®å±æ§ãã»ãããåŒæ°ããªããã°è§£é€ã
\a 'unaligned' ããã³ 'aligned' åºåã¢ãŒãã®ãã°ã«
\c[onnect] [DBå|- ãŠãŒã¶å|- ãã¹ãå|- ããŒãçªå·|-]
æ°ããããŒã¿ããŒã¹ã«æ¥ç¶ãã (çŸåš: "%s")
\cd [DIR] ã«ã¬ã³ããã£ã¬ã¯ããªãå€æŽ
\copy ... ã¯ã©ã€ã¢ã³ããã¹ãã«å¯ŸããããŒã¿ã¹ããªãŒã ã䜿ã£ãŠ
SQL ã³ããŒãè¡ã
\copyright PostgreSQL ã®äœ¿ãæ¹ãšé
åžæ¡ä»¶ã衚瀺
\dC [ãã¿ãŒã³] ãã£ã¹ãäžèŠ§ã衚瀺
\dD[S] [ãã¿ãŒã³] ãã¡ã€ã³äžèŠ§ã衚瀺
\dF[+] [ãã¿ãŒã³] ããã¹ãæ€çŽ¢èšå®äžèŠ§ã衚瀺
\dFd[+] [ãã¿ãŒã³] ããã¹ãæ€çŽ¢çšã®èŸæžäžèŠ§ã衚瀺
\dFp[+] [ãã¿ãŒã³] ããã¹ãæ€çŽ¢çšã®ããŒãµäžèŠ§ã衚瀺
\dFt[+] [ãã¿ãŒã³] ããã¹ãæ€çŽ¢çšã®ãã³ãã¬ãŒãäžèŠ§ã衚瀺
\dT[S+] [ãã¿ãŒã³] ããŒã¿åã®äžèŠ§ã衚瀺
\d[S+] ããŒãã«ããã¥ãŒãã·ãŒã±ã³ã¹ã®äžèŠ§ã衚瀺
\d[S+] åå ããŒãã«ããã¥ãŒãã·ãŒã±ã³ã¹ãã€ã³ããã¯ã¹ã®èª¬æã衚瀺
\da[+] [ãã¿ãŒã³] éçŽé¢æ°äžèŠ§ã衚瀺
\db[+] [ãã¿ãŒã³] ããŒãã«ã¹ããŒã¹äžèŠ§ã衚瀺
\dc[S] [ãã¿ãŒã³] å€æã«ãŒã«äžèŠ§ã衚瀺
\dd[S] [ãã¿ãŒã³] ãªããžã§ã¯ãã®ã³ã¡ã³ãã衚瀺
\des[+] [ãã¿ãŒã³] å€éšãµãŒãäžèŠ§ã衚瀺
\deu[+] [ãã¿ãŒã³] ãŠãŒã¶ãããã³ã°ã®äžèŠ§ã衚瀺
\dew[+] [ãã¿ãŒã³] å€éšããŒã¿ã©ãããŒã®äžèŠ§ã衚瀺
\df[antw][S+] [ãã¿ãŒã³] é¢æ°ïŒéçŽ/éåžž/ããªã¬/ãŠã£ã³ããŠã®ã¿ïŒäžèŠ§ã衚瀺
\dg [ãã¿ãŒã³] ããŒã«ïŒã°ã«ãŒãïŒã®äžèŠ§ã衚瀺
\di[S+] [ãã¿ãŒã³] ã€ã³ããã¯ã¹ã®äžèŠ§ã衚瀺
\dl ã©ãŒãžãªããžã§ã¯ãã®äžèŠ§ã衚瀺ã\lo_list ãšåãã
\dn[+] [ãã¿ãŒã³] ã¹ããŒãã®äžèŠ§ã衚瀺
\do[S] [åå] æŒç®åã®äžèŠ§ã衚瀺
\dp [ãã¿ãŒã³] ããŒãã«ããã¥ãŒãã·ãŒã±ã³ã¹ã®ã¢ã¯ã»ã¹æš©äžèŠ§ã衚瀺
\ds[S+] [ãã¿ãŒã³] ã·ãŒã±ã³ã¹ã®äžèŠ§ã衚瀺
\dt[S+] [ãã¿ãŒã³] ããŒãã«ã®äžèŠ§ã衚瀺
\du [ãã¿ãŒã³] ããŒã«ïŒãŠãŒã¶ïŒã®äžèŠ§ã衚瀺
\dv[S+] [ãã¿ãŒã³] ãã¥ãŒã®äžèŠ§ã衚瀺
\e [ãã¡ã€ã«] çŸåšã®ã¯ãšãªãŒãããã¡(ããã¡ã€ã«)ãå€éšãšãã£ã¿ã§ç·šé
\echo [æåå] æååãæšæºåºåã«æžãåºã
\e [é¢æ°å] é¢æ°å®çŸ©ãå€éšãšãã£ã¿ã§ç·šé
\encoding [ãšã³ã³ãŒãã£ã³ã°]
ã¯ã©ã€ã¢ã³ãã®ãšã³ã³ãŒãã£ã³ã°ã衚瀺ãŸãã¯ã»ãã
\f [æåå] ã¯ãšãªãŒåºåã®éã«æ¡æããè¡ããªã(unaligned)å Žåã«
䜿çšãããã£ãŒã«ãåºåãæåã衚瀺ãŸãã¯æå®
\g [ãã¡ã€ã«] ãŸã㯠; ã¯ãšãªãŒå®è¡ïŒããçµæããã¡ã€ã«ãŸã㯠|ãã€ã ãžæžãåºã)
\h [åå] SQL ã³ãã³ãã®æžåŒã®ãã«ãã* ã§å
šã³ãã³ã
\i ãã¡ã€ã« ãã¡ã€ã«ããã³ãã³ããèªã¿èŸŒãã§å®è¡
\l[+] ããŒã¿ããŒã¹ã®äžèŠ§ã衚瀺
\lo_export LOBOID ãã¡ã€ã«å
\lo_import ãã¡ã€ã«å [ã³ã¡ã³ã]
\lo_list
\lo_unlink LOBOID ã©ãŒãžãªããžã§ã¯ãã®æäœ
\o [ãã¡ã€ã«] ãã¹ãŠã®ã¯ãšãªãŒã®çµæããã¡ã€ã«ãŸã㯠|ãã€ã ãžéã
\p ã¯ãšãªãŒãããã¡ã®å
容ã衚瀺
\password [USERNAME] ãŠãŒã¶ã®ãã¹ã¯ãŒããå®å
šã«å€æŽãã
\prompt [ããã¹ã] å€æ°å ãŠãŒã¶ã«å
éšå€æ°ãã»ããããããä¿ã
\pset åå [å€] ããŒãã«åºåã®ãªãã·ã§ã³èšå®
(åå := {format|border|expanded|fieldsep|footer|null|
numericlocale|recordsep|tuples_only|title|tableattr|pager})
\q psql ãçµäº
\qecho [æåå] æååãã¯ãšãªãŒåºåã¹ããªãŒã ã«åºå(\o ãåç
§)
\r ã¯ãšãªãŒãããã¡ããªã»ããïŒã¯ãªã¢ïŒ
\s [ãã¡ã€ã«] ãã¹ããªã衚瀺ãŸãã¯ãã¡ã€ã«ã«ä¿å
\set [å€æ°å [å€]]
å
éšå€æ°ã®å€ãã»ãããåŒæ°ããªãå Žåã¯äžèŠ§è¡šç€ºã
\t [on|off] è¡ã®ã¿è¡šç€ºãã (çŸåš: %s)
\timing [on|off] ã³ãã³ãã®ã¿ã€ãã³ã°ãåãæ¿ã(çŸåš: %s)
\unset å€æ°å å
éšå€æ°ãåé€
\w ãã¡ã€ã« ã¯ãšãªãŒãããã¡ã®å
容ããã¡ã€ã«ã«æžãåºã
\x [on|off] æ¡åŒµåºåã®ãã°ã«(çŸåš: %s)
\z [ãã¿ãŒã³] \dp ãšåã
psql [ãªãã·ã§ã³]... [ããŒã¿ããŒã¹å [ãŠãŒã¶å]]
ãŠãŒã¶åïŒ"%s" ããŒãïŒ"%s" ãã¹ãïŒ"%s" %d åã®æ¥ç¶ %d åã®æ¥ç¶ %s %s (%s, ãµãŒã %s)
%s: %s
%s: ãã£ã¬ã¯ããªããïŒãã£ã¬ã¯ããªãžã®ã³ããŒã¯ã§ããŸããã
%s: å€æ° "%s" ãåé€ã§ããŸããã§ãã
%s: ãã°ãã¡ã€ã« "%s" ãéããŸãã: %s
%s: 衚瀺çšãã©ã¡ãŒã¿ "%s" ãã»ããã§ããŸããã§ãã
%s: å€æ° "%s" ãã»ããã§ããŸããã§ãã
%s: ãã©ã³ã¶ã¯ã·ã§ã³ãäžæããŸãã
%s: æ£ãããšã³ã³ãŒãã£ã³ã°åã§ãªããããŸãã¯å€æçšããã·ãŒãžã£ãèŠã€ãããŸããã
%s: ããŒã¿ããŒã¹ã«æ¥ç¶ãããŠããŸãã
%s: pg_strdup: null ãã€ã³ã¿ãè€è£œã§ããŸããïŒå
éšãšã©ãŒïŒã
%s: ãã©ã³ã¶ã¯ã·ã§ã³ã®ç¶æ
ãäžæã§ãã
%s: èŠåïŒäœåãªã³ãã³ãã©ã€ã³ãªãã·ã§ã³ "%s" ã¯ç¡èŠãããŸã
(%lu è¡) (%lu è¡) (è¡ããããŸãã)
***(ã·ã³ã°ã«ã¹ãããã¢ãŒã: ã¯ãšãªãŒãæ€æ»ããŠãã ãã)****************************************
%s
***([Enter] ãæŒããŠé²ãããx [Enter] ã§ãã£ã³ã»ã«)*******
*******************
********* ã¯ãšãªãŒ **********
%s
*****************************
, ã¯ã©ã¹ã¿åæžã¿ , ç¡å¹ , è¿°èª (%s) ããŒãã«ã¹ããŒã¹ "%s" ABORT [ WORK | TRANSACTION ] ALTER AGGREGATE éçŽé¢æ°å ( ããŒã¿å [ , ... ] ) RENAME TO æ°ããåå
ALTER AGGREGATE éçŽé¢æ°å ( ããŒã¿å [ , ... ] ) OWNER TO æ°ããææè
ALTER AGGREGATE éçŽé¢æ°å ( ããŒã¿å [ , ... ] ) SET SCHEMA æ°ããã¹ããŒã ALTER CONVERSION å€æã«ãŒã«å RENAME TO æ°ããåå
ALTER CONVERSION å€æã«ãŒã«å OWNER TO æ°ããææè
ALTER DATABASE ããŒã¿ããŒã¹å [ [ WITH ] ãªãã·ã§ã³ [ ... ] ]
ãªãã·ã§ã³ã¯ä»¥äžã®ãããã:
CONNECTION LIMIT æ倧æ¥ç¶æ°
ALTER DATABASE ããŒã¿ããŒã¹å RENAME TO æ°ããåå
ALTER DATABASE ããŒã¿ããŒã¹å OWNER TO æ°ããææè
ALTER DATABASE ããŒã¿ããŒã¹å SET TABLESPACE æ°ããããŒãã«ã¹ããŒã¹å
ALTER DATABASE ããŒã¿ããŒã¹å SET èšå®ãã©ã¡ãŒã¿ { TO | = } { å€ | DEFAULT }
ALTER DATABASE name SET èšå®ãã©ã¡ãŒã¿ FROM CURRENT
ALTER DATABASE ããŒã¿ããŒã¹å RESET èšå®ãã©ã¡ãŒã¿
ALTER DATABASE name RESET ALL ALTER DOMAIN ãã¡ã€ã³å
{ SET DEFAULT è©äŸ¡åŒ | DROP DEFAULT }
ALTER DOMAIN ãã¡ã€ã³å
{ SET | DROP } NOT NULL
ALTER DOMAIN ãã¡ã€ã³å
ADD ãã¡ã€ã³å¶çŽ
ALTER DOMAIN ãã¡ã€ã³å
DROP CONSTRAINT å¶çŽå [ RESTRICT | CASCADE ]
ALTER DOMAIN ãã¡ã€ã³å
OWNER TO æ°ããææè
ALTER DOMAIN ãã¡ã€ã³å
SET SCHEMA æ°ããã¹ããŒã ALTER FOREIGN DATA WRAPPER å€éšããŒã¿ã©ãããŒå
[ VALIDATOR æ€æ»é¢æ° | NO VALIDATOR ]
[ OPTIONS ( [ ADD | SET | DROP ] ãªãã·ã§ã³ ['å€'] [, ... ]) ]
ALTER FOREIGN DATA WRAPPER å€éšããŒã¿ã©ãããŒå OWNER TO æ°ããææè
ALTER FUNCTION é¢æ°å ( [ [ åŒæ°ã®ã¢ãŒã ] [ åŒæ°å ] åŒæ°ã®å [, ...] ] )
ã¢ã¯ã·ã§ã³ [, ... ] [ RESTRICT ]
ALTER FUNCTION é¢æ°å ( [ [ åŒæ°ã®ã¢ãŒã ] [ åŒæ°å ] åŒæ°ã®å [, ...] ] )
RENAME TO æ°ããåå
ALTER FUNCTION é¢æ°å ( [ [ åŒæ°ã®ã¢ãŒã ] [ åŒæ°å ] åŒæ°ã®å [, ...] ] )
OWNER TO æ°ããææè
ALTER FUNCTION é¢æ°å ( [ [ åŒæ°ã®ã¢ãŒã ] [ åŒæ°å ] åŒæ°ã®å [, ...] ] )
SET SCHEMA æ°ããã¹ããŒã
ããã§ãã¢ã¯ã·ã§ã³ã¯ä»¥äžã®ãããã:
CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
IMMUTABLE | STABLE | VOLATILE
[ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER
COST å®è¡ã³ã¹ã
ROWS çµæã®è¡æ°
SET èšå®ãã©ã¡ãŒã¿ { TO | = } { å€ | DEFAULT }
SET èšå®ãã©ã¡ãŒã¿ FROM CURRENT
RESET èšå®ãã©ã¡ãŒã¿
RESET ALL ALTER GROUP ã°ã«ãŒãå ADD USER ãŠãŒã¶å [, ... ]
ALTER GROUP ã°ã«ãŒãå DROP USER ãŠãŒã¶å [, ... ]
ALTER GROUP ã°ã«ãŒãå RENAME TO æ°ããåå ALTER INDEX ã€ã³ããã¯ã¹å RENAME TO æ°ããåå
ALTER INDEX ã€ã³ããã¯ã¹å SET TABLESPACE ããŒãã«ã¹ããŒã¹å
ALTER INDEX ã€ã³ããã¯ã¹å SET ( ã¹ãã¬ãŒãžãã©ã¡ãŒã¿ = å€ [, ... ] )
ALTER INDEX ã€ã³ããã¯ã¹å RESET ( ã¹ãã¬ãŒãžãã©ã¡ãŒã¿ [, ... ] ) ALTER OPERATOR CLASS æŒç®åã¯ã©ã¹å USING ã€ã³ããã¯ã¹ã¡ãœãã RENAME TO æ°ããåå
ALTER OPERATOR CLASS æŒç®åã¯ã©ã¹å USING ã€ã³ããã¯ã¹ã¡ãœãã OWNER TO æ°ããææè
ALTER OPERATOR FAMILY æŒç®åãã¡ããªå USING ã€ã³ããã¯ã¹çš®å¥ ADD
{ OPERATOR èšç»çªå· æŒç®åå ( ãªãã©ã³ãã®å, ãªãã©ã³ãã®å )
| FUNCTION ãµããŒãçªå· [ ( ãªãã©ã³ãã®å [ , ãªãã©ã³ãã®å ] ) ]
é¢æ°å ( åŒæ°ã®ã¿ã€ã [, ...] )
} [, ... ]
ALTER OPERATOR FAMILY æŒç®åãã¡ããªå USING ã€ã³ããã¯ã¹çš®å¥ DROP
{ OPERATOR èšç»çªå· ( ãªãã©ã³ãã®å [ , ãªãã©ã³ãã®å ] )
| FUNCTION ãµããŒãçªå· ( ãªãã©ã³ãã®å [ , ãªãã©ã³ãã®å ] )
} [, ... ]
ALTER OPERATOR FAMILY æŒç®åãã¡ããªå USING ã€ã³ããã¯ã¹çš®å¥
RENAME TO æ°ããåå
ALTER OPERATOR FAMILY æŒç®åãã¡ããªå USING ã€ã³ããã¯ã¹çš®å¥
OWNER TO æ°ããææè
ALTER OPERATOR æŒç®åå ( { 巊蟺ã®å | NONE } , { å³èŸºã®å | NONE } ) OWNER TO æ°ããææè
ALTER ROLE ããŒã«å [ [ WITH ] ãªãã·ã§ã³ [ ... ] ]
ãªãã·ã§ã³ã¯ä»¥äžã®ãããã:
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
| CREATEUSER | NOCREATEUSER
| INHERIT | NOINHERIT
| LOGIN | NOLOGIN
| CONNECTION LIMIT æ倧æ¥ç¶æ°
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'ãã¹ã¯ãŒã'
| VALID UNTIL 'ã¿ã€ã ã¹ã¿ã³ã'
ALTER ROLE ããŒã«å RENAME TO æ°ããåå
ALTER ROLE ããŒã«å SET èšå®ãã©ã¡ãŒã¿å { TO | = } { å€ | DEFAULT }
ALTER ROLE ããŒã«å SET èšå®ãã©ã¡ãŒã¿å FROM CURRENT
ALTER ROLE ããŒã«å RESET èšå®ãã©ã¡ãŒã¿å
ALTER ROLE ããŒã«å RESET ALL ALTER SCHEMA ã¹ããŒãå RENAME TO æ°ããåå
ALTER SCHEMA ã¹ããŒãå OWNER TO æ°ããææè
ALTER SEQUENCE ã·ãŒã±ã³ã¹å [ INCREMENT [ BY ] å¢å ]
[ MINVALUE æå°å€ | NO MINVALUE ] [ MAXVALUE æå€§å€ | NO MAXVALUE ]
[ START [ WITH ] éå§å€ ]
[ RESTART [ WITH ] åéå€ ]
[ CACHE ãã£ãã·ã¥ ] [ [ NO ] CYCLE ]
[ OWNED BY { ããŒãã«å.ã«ã©ã å | NONE } ]
ALTER SEQUENCE ã·ãŒã±ã³ã¹å OWNER TO æ°ããææè
ALTER SEQUENCE ã·ãŒã±ã³ã¹å RENAME TO æ°ããåå
ALTER SEQUENCE ã·ãŒã±ã³ã¹å SET SCHEMA æ°ããã¹ããŒãå ALTER SERVER å€éšãµãŒãå [ VERSION 'æ°ããããŒãžã§ã³çªå·' ]
[ OPTIONS ( [ ADD | SET | DROP ] ãªãã·ã§ã³ ['å€'] [, ... ] ) ]
ALTER SERVER å€éšãµãŒãå OWNER TO æ°ããææè
ALTER TABLE [ ONLY ] ããŒãã«å [ * ]
ã¢ã¯ã·ã§ã³ [, ... ]
ALTER TABLE [ ONLY ] ããŒãã«å [ * ]
RENAME [ COLUMN ] ã«ã©ã å TO æ°ããåå
ALTER TABLE ããŒãã«å
RENAME TO æ°ããåå
ALTER TABLE ããŒãã«å
SET SCHEMA æ°ããã¹ããŒã
ã¢ã¯ã·ã§ã³ã¯ä»¥äžã®ããããïŒ
ADD [ COLUMN ] ã«ã©ã å å [ ã«ã©ã å¶çŽ [ ... ] ]
DROP [ COLUMN ] ã«ã©ã å [ RESTRICT | CASCADE ]
ALTER [ COLUMN ] ã«ã©ã å TYPE å [ USING è©äŸ¡åŒ ]
ALTER [ COLUMN ] ã«ã©ã å SET DEFAULT è©äŸ¡åŒ
ALTER [ COLUMN ] ã«ã©ã å DROP DEFAULT
ALTER [ COLUMN ] ã«ã©ã å { SET | DROP } NOT NULL
ALTER [ COLUMN ] ã«ã©ã å SET STATISTICS æŽæ°å€
ALTER [ COLUMN ] ã«ã©ã å SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }
ADD ããŒãã«å¶çŽå
DROP CONSTRAINT ããŒãã«å¶çŽå [ RESTRICT | CASCADE ]
DISABLE TRIGGER [ ããªã¬å | ALL | USER ]
ENABLE TRIGGER [ ããªã¬å | ALL | USER ]
ENABLE REPLICA TRIGGER ããªã¬å
ENABLE ALWAYS TRIGGER ããªã¬å
DISABLE RULE æžãæãã«ãŒã«å
ENABLE RULE æžãæãã«ãŒã«å
ENABLE REPLICA RULE æžãæãã«ãŒã«å
ENABLE ALWAYS RULE æžãæãã«ãŒã«å
CLUSTER ON ã€ã³ããã¯ã¹å
SET WITHOUT CLUSTER
SET WITH OIDS
SET WITHOUT OIDS
SET ( æ ŒçŽãã©ã¡ãŒã¿ = å€ [, ... ] )
RESET ( æ ŒçŽãã©ã¡ãŒã¿ [, ... ] )
INHERIT 芪ããŒãã«å
NO INHERIT 芪ããŒãã«å
OWNER TO æ°ããææè
SET TABLESPACE æ°ããããŒãã«ã¹ããŒã¹å ALTER TABLESPACE ããŒãã«ã¹ããŒã¹å RENAME TO æ°ããåå
ALTER TABLESPACE ããŒãã«ã¹ããŒã¹å OWNER TO æ°ããææè
ALTER TEXT SEARCH CONFIGURATION èšå®å
ADD MAPPING FOR ããŒã¯ã³ã®å [, ... ] WITH èŸæžå [, ... ]
ALTER TEXT SEARCH CONFIGURATION name
ALTER MAPPING FOR ããŒã¯ã³ã®å [, ... ] WITH èŸæžå [, ... ]
ALTER TEXT SEARCH CONFIGURATION èšå®å
ALTER MAPPING REPLACE å€ãèŸæž WITH æ°ããèŸæž
ALTER TEXT SEARCH CONFIGURATION èšå®å
ALTER MAPPING FOR ããŒã¯ã³ã®å [, ... ] REPLACE å€ãèŸæž WITH æ°ããèŸæž
ALTER TEXT SEARCH CONFIGURATION èšå®å
DROP MAPPING [ IF EXISTS ] FOR ããŒã¯ã³ã®å [, ... ]
ALTER TEXT SEARCH CONFIGURATION èšå®å RENAME TO æ°ããåå
ALTER TEXT SEARCH CONFIGURATION èšå®å OWNER TO æ°ããææè
ALTER TEXT SEARCH DICTIONARY èŸæžå (
ãªãã·ã§ã³ [ = å€ ] [, ... ]
)
ALTER TEXT SEARCH DICTIONARY èŸæžå RENAME TO æ°ããåå
ALTER TEXT SEARCH DICTIONARY èŸæžå OWNER TO æ°ããææè
ALTER TEXT SEARCH PARSER ããŒãµå RENAME TO æ°ããåå ALTER TEXT SEARCH TEMPLATE ãã³ãã¬ãŒãå RENAME TO æ°ããåå ALTER TRIGGER ããªã¬å ON ããŒãã«å RENAME TO æ°ããåå ALTER TYPE åå RENAME TO æ°ããåå
ALTER TYPE åå OWNER TO æ°ããææè
ALTER TYPE åå SET SCHEMA æ°ããã¹ããŒã ALTER USER MAPPING FOR { ãŠãŒã¶å | USER | CURRENT_USER | PUBLIC }
SERVER ãµãŒãå
OPTIONS ( [ ADD | SET | DROP ] ãªãã·ã§ã³ ['å€'] [, ... ] ) ALTER USER ãŠãŒã¶å [ [ WITH ] ãªãã·ã§ã³ [ ... ] ]
ãªãã·ã§ã³ã¯ä»¥äžã®éã:
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
| CREATEUSER | NOCREATEUSER
| INHERIT | NOINHERIT
| LOGIN | NOLOGIN
| CONNECTION LIMIT æ倧æ¥ç¶æ°
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'ãã¹ã¯ãŒãæåå'
| VALID UNTIL 'ã¿ã€ãã¹ã¿ã³ã'
ALTER USER ãŠãŒã¶å RENAME TO æ°ããåå
ALTER USER ãŠãŒã¶å SET èšå®ãã©ã¡ãŒã¿å { TO | = } { å€ | DEFAULT }
ALTER USER ãŠãŒã¶å SET èšå®ãã©ã¡ãŒã¿å FROM CURRENT
ALTER USER ãŠãŒã¶å RESET èšå®ãã©ã¡ãŒã¿å
ALTER USER ãŠãŒã¶å RESET ALL ALTER VIEW ãã¥ãŒå ALTER [ COLUMN ] ã«ã©ã å SET DEFAULT è©äŸ¡åŒ
ALTER VIEW ãã¥ãŒå ALTER [ COLUMN ] ã«ã©ã å DROP DEFAULT
ALTER VIEW ãã¥ãŒå OWNER TO æ°ããææè
ALTER VIEW ãã¥ãŒå RENAME TO æ°ããåå
ALTER VIEW ãã¥ãŒå SET SCHEMA æ°ããã¹ããŒã ALTER [ PROCEDURAL ] LANGUAGE èšèªå RENAME TO æ°ããåå
ALTER [ PROCEDURAL ] LANGUAGE èšèªå OWNER TO æ°ããææè
ANALYZE [ VERBOSE ] [ ããŒãã«å [ (ã«ã©ã å [, ...] ) ] ] ã¢ã¯ã»ã¹æš© åŒæ°ã®ããŒã¿å PID %2$d ãæã€ãµãŒãããã»ã¹ããéåæéç¥ "%1$s" ãåä¿¡ããŸããã
å±æ§ å©çšå¯èœãªãã«ã:
BEGIN [ WORK | TRANSACTION ] [ ãã©ã³ã¶ã¯ã·ã§ã³ã¢ãŒã [, ...] ]
ãã©ã³ã¶ã¯ã·ã§ã³ã¢ãŒãã¯ä»¥äžã®ããããïŒ
ISOLATION LEVEL
{ SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
READ WRITE | READ ONLY å¢çç·ã®ã¹ã¿ã€ã«ã¯ %d ã§ãã
ãã§ãã¯ãã€ã³ã CLOSE { ã«ãŒãœã«å | ALL } CLUSTER [VERBOSE] ããŒãã«å [ USING ã€ã³ããã¯ã¹å ]
CLUSTER [VERBOSE] COMMENT ON
{
TABLE ãªããžã§ã¯ãå |
COLUMN ããŒãã«å.ã«ã©ã å |
AGGREGATE éçŽé¢æ°å (éçŽé¢æ°ã®å [, ...] ) |
CAST (ãã£ã¹ãåã®å AS ãã£ã¹ãåŸã®å) |
CONSTRAINT å¶çŽæ¡ä»¶å ON ããŒãã«å |
CONVERSION ãªããžã§ã¯ãå |
DATABASE ãªããžã§ã¯ãå |
DOMAIN ãªããžã§ã¯ãå |
FUNCTION é¢æ°å ( [ [ åŒæ°ã®ã¢ãŒã ] [ åŒæ°å ] åŒæ°ã®å [, ...] ] ) |
INDEX ãªããžã§ã¯ãå |
LARGE OBJECT ã©ãŒãžãªããžã§ã¯ãã®OID |
OPERATOR æŒç®åå (巊蟺ã®å, å³èŸºã®å) |
OPERATOR CLASS ãªããžã§ã¯ãå USING ã€ã³ããã¯ã¹ã¡ãœãã |
OPERATOR FAMILY ãªããžã§ã¯ãå USING ã€ã³ããã¯ã¹ã¡ãœãã |
[ PROCEDURAL ] LANGUAGE ãªããžã§ã¯ãå |
ROLE ãªããžã§ã¯ãå |
RULE ã«ãŒã«å ON ããŒãã«å |
SCHEMA ãªããžã§ã¯ãå |
SEQUENCE ãªããžã§ã¯ãå |
TABLESPACE ãªããžã§ã¯ãå |
TEXT SEARCH CONFIGURATION ãªããžã§ã¯ãå |
TEXT SEARCH DICTIONARY ãªããžã§ã¯ãå |
TEXT SEARCH PARSER ãªããžã§ã¯ãå |
TEXT SEARCH TEMPLATE ãªããžã§ã¯ãå |
TRIGGER ããªã¬å ON ããŒãã«å |
TYPE ãªããžã§ã¯ãå |
VIEW ãªããžã§ã¯ãå
} IS 'æåå' COMMIT PREPARED ãã©ã³ã¶ã¯ã·ã§ã³ID COMMIT [ WORK | TRANSACTION ] COPY ããŒã¿ã®è»¢éã«å€±æããŸããïŒ%s COPY ããŒãã«å [ ( ã«ã©ã å [, ...] ) ]
FROM { 'ãã¡ã€ã«å' | STDIN }
[ [ WITH ]
[ BINARY ]
[ OIDS ]
[ DELIMITER [ AS ] 'ãã£ãŒã«ãåºåãæå' ]
[ NULL [ AS ] 'nullãè¡šãæåå' ]
[ CSV [ HEADER ]
[ QUOTE [ AS ] 'åŒçšç¬ŠãšããŠäœ¿çšããæå' ]
[ ESCAPE [ AS ] 'ãšã¹ã±ãŒãæå' ]
[ FORCE NOT NULL ã«ã©ã å [, ...] ]
COPY { ããŒãã«å [ ( ã«ã©ã å [, ...] ) ] | ( ã¯ãšãªãŒæåå ) }
TO { 'ãã¡ã€ã«å' | STDOUT }
[ [ WITH ]
[ BINARY ]
[ OIDS ]
[ DELIMITER [ AS ] 'ãã£ãŒã«ãåºåãæå' ]
[ NULL [ AS ] 'nullãè¡šãæåå' ]
[ CSV [ HEADER ]
[ QUOTE [ AS ] 'åŒçšç¬ŠãšããŠäœ¿çšããæå' ]
[ ESCAPE [ AS ] 'ãšã¹ã±ãŒãæå' ]
[ FORCE QUOTE ã«ã©ã å [, ...] ] CREATE AGGREGATE éçŽé¢æ°å ( å
¥åããŒã¿å [ , ... ] ) (
SFUNC = ç¶æ
é·ç§»é¢æ°,
STYPE = ç¶æ
ããŒã¿å
[ , FINALFUNC = æçµç¶æ
é¢æ° ]
[ , INITCOND = åæç¶æ
]
[ , SORTOP = ãœãŒãæŒç®å ]
)
ãããã¯ãåŸæ¥ã®ææ³
CREATE AGGREGATE name (
BASETYPE = å
¥åããŒã¿å,
SFUNC = ç¶æ
é·ç§»é¢æ°,
STYPE = ç¶æ
ããŒã¿å
[ , FINALFUNC = æçµç¶æ
é¢æ° ]
[ , INITCOND = åæç¶æ
]
[ , SORTOP = ãœãŒãæŒç®å ]
) CREATE CAST (å
ã®å AS ãã£ã¹ãåŸã®å)
WITH FUNCTION é¢æ°å (åŒæ°ã®å)
[ AS ASSIGNMENT | AS IMPLICIT ]
CREATE CAST (å
ã®å AS ãã£ã¹ãåŸã®å)
WITHOUT FUNCTION
[ AS ASSIGNMENT | AS IMPLICIT ]
CREATE CAST (å
ã®å AS ãã£ã¹ãåŸã®å)
WITH INOUT
[ AS ASSIGNMENT | AS IMPLICIT ] CREATE CONSTRAINT TRIGGER ããªã¬å
AFTER ã€ãã³ã [ OR ... ]
ON ããŒãã«å
[ FROM 被åç
§ããŒãã«å ]
{ NOT DEFERRABLE | [ DEFERRABLE ] { INITIALLY IMMEDIATE | INITIALLY DEFERRED } }
FOR EACH ROW
EXECUTE PROCEDURE é¢æ°å ( åŒæ° ) CREATE DATABASE ããŒã¿ããŒã¹å
[ [ WITH ] [ OWNER [=] ããŒã¿ããŒã¹ã®ææè
]
[ TEMPLATE [=] ãã³ãã¬ãŒãå ]
[ ENCODING [=] ãšã³ã³ãŒãã£ã³ã° ]
[ LC_COLLATE [=] ç
§åé åº ]
[ LC_CTYPE [=] lc_ctype ]
[ TABLESPACE [=] ããŒãã«ã¹ããŒã¹å ] ]
[ CONNECTION LIMIT [=] æ倧æ¥ç¶æ° ] ] CREATE DOMAIN ãã¡ã€ã³å [AS] ããŒã¿å
[ DEFAULT è©äŸ¡åŒ ]
[ å¶çŽæ¡ä»¶ [ ... ] ]
å¶çŽæ¡ä»¶ã¯ä»¥äžã®éãïŒ
[ CONSTRAINT å¶çŽå ]
{ NOT NULL | NULL | CHECK (è©äŸ¡åŒ) } CREATE FOREIGN DATA WRAPPER å€éšããŒã¿ã©ãããŒå
[ VALIDATOR 劥åœæ§æ€æ»é¢æ° | NO VALIDATOR ]
[ OPTIONS ( ãªãã·ã§ã³ 'å€' [, ... ] ) ] CREATE GROUP ã°ã«ãŒãå [ [ WITH ] ãªãã·ã§ã³ [ ... ] ]
ãªãã·ã§ã³ã¯ä»¥äžã®éã:
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
| CREATEUSER | NOCREATEUSER
| INHERIT | NOINHERIT
| LOGIN | NOLOGIN
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'ãã¹ã¯ãŒãæåå'
| VALID UNTIL 'æå»è¡šçŸ'
| IN ROLE ããŒã«å [, ...]
| IN GROUP ããŒã«å [, ...]
| ROLE ããŒã«å [, ...]
| ADMIN ããŒã«å [, ...]
| USER ããŒã«å [, ...]
| SYSID uid CREATE OPERATOR CLASS ã¯ã©ã¹å [ DEFAULT ] FOR TYPE ããŒã¿å
USING ã€ã³ããã¯ã¹ã¡ãœãã [ FAMILY ãã¡ããªå ] AS
{ OPERATOR èšç»çªå· æŒç®åå [ ( æŒç®åã®å, æŒç®åã®å ) ]
| FUNCTION ãµããŒãçªå· [ ( æŒç®åã®å [ , æŒç®åã®å ] ) ]
é¢æ°å ( åŒæ°ã®å [, ...] )
| STORAGE èšæ¶åã®å
} [, ... ] CREATE OPERATOR FAMILY æŒç®åãã¡ããªå USING ã€ã³ããã¯ã¹ã¡ãœãã CREATE OPERATOR æŒç®åå (
PROCEDURE = é¢æ°å
[, LEFTARG = 巊蟺ã®å ] [, RIGHTARG = å³èŸºã®å ]
[, COMMUTATOR = 亀ææŒç®å ] [, NEGATOR = åŠå®æŒç®å ]
[, RESTRICT = éå®æç¶ã ] [, JOIN = çµåæç¶ã ]
[, HASHES ] [, MERGES ]
) CREATE ROLE ããŒã«å [ [ WITH ] ãªãã·ã§ã³ [ ... ] ]
ãªãã·ã§ã³ã¯ä»¥äžã®éã:
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
| CREATEUSER | NOCREATEUSER
| INHERIT | NOINHERIT
| LOGIN | NOLOGIN
| CONNECTION LIMIT æ倧æ¥ç¶æ°
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'ãã¹ã¯ãŒãæåå'
| VALID UNTIL 'æå»è¡šçŸ'
| IN ROLE ããŒã«å [, ...]
| IN GROUP ããŒã«å [, ...]
| ROLE ããŒã«å [, ...]
| ADMIN ããŒã«å [, ...]
| USER ããŒã«å [, ...]
| SYSID ãŠãŒã¶ID CREATE SCHEMA ã¹ããŒãå [ AUTHORIZATION ãŠãŒã¶å ] [ ã¹ããŒãèŠçŽ [ ... ] ]
CREATE SCHEMA AUTHORIZATION ãŠãŒã¶å [ ã¹ããŒãèŠçŽ [ ... ] ] CREATE SERVER å€éšãµãŒãå [ TYPE 'ã¿ã€ã' ] [ VERSION 'ããŒãžã§ã³çªå·' ]
FOREIGN DATA WRAPPER å€éšããŒã¿ã©ãããŒå
[ OPTIONS ( ãªãã·ã§ã³ 'å€' [, ... ] ) ] CREATE TABLESPACE ããŒãã«ã¹ããŒã¹å [ OWNER ãŠãŒã¶å ] LOCATION 'ãã£ã¬ã¯ããª' CREATE TEXT SEARCH CONFIGURATION èšå®å (
PARSER = ããŒãµå |
COPY = å
ã®èšå®å
) CREATE TEXT SEARCH DICTIONARY èŸæžå (
TEMPLATE = ãã³ãã¬ãŒãå
[, ãªãã·ã§ã³ = å€ [, ... ]]
) CREATE TEXT SEARCH PARSER ããŒãµå (
START = éå§é¢æ° ,
GETTOKEN = ããŒã¯ã³ååŸé¢æ° ,
END = çµäºæé¢æ° ,
LEXTYPES = LEXã¿ã€ãé¢æ°
[, HEADLINE = èŠåºãé¢æ° ]
) CREATE TEXT SEARCH TEMPLATE ãã³ãã¬ãŒãå (
[ INIT = åæåé¢æ° , ]
LEXIZE = LEXåŠçé¢æ°
) CREATE TRIGGER ããªã¬å { BEFORE | AFTER } { ã€ãã³ã [ OR ... ] }
ON ããŒãã«å [ FOR [ EACH ] { ROW | STATEMENT } ]
EXECUTE PROCEDURE é¢æ°å ( åŒæ° ) CREATE TYPE åå AS
( å±æ§å ããŒã¿å [, ... ] )
CREATE TYPE åå AS ENUM
( 'ã©ãã«' [, ... ] )
CREATE TYPE åå (
INPUT = å
¥åé¢æ°,
OUTPUT = åºåé¢æ°
[ , RECEIVE = åä¿¡é¢æ° ]
[ , SEND = éä¿¡é¢æ° ]
[ , TYPMOD_IN = å修食åã®å
¥åé¢æ° ]
[ , TYPMOD_OUT = å修食åã®åºåé¢æ° ]
[ , ANALYZE = åæé¢æ° ]
[ , INTERNALLENGTH = { å
éšããŒã¿é· | VARIABLE } ]
[ , PASSEDBYVALUE ]
[ , ALIGNMENT = ã¢ã©ã€ã³ã¡ã³ãäœçœ® ]
[ , STORAGE = èšæ¶å ]
[ , LIKE = likeã®å ]
[ , CATEGORY = åã®ã«ããŽãª ]
[ , PREFERRED = åªå
ããå ]
[ , DEFAULT = ããã©ã«ãå€ ]
[ , ELEMENT = èŠçŽ ]
[ , DELIMITER = åºåãæå ]
)
CREATE TYPE åå CREATE USER MAPPING FOR { ãŠãŒã¶å | USER | CURRENT_USER | PUBLIC }
SERVER å€éšãµãŒãå
[ OPTIONS ( ãªãã·ã§ã³ 'å€' [ , ... ] ) ] CREATE USER ãŠãŒã¶å [ [ WITH ] ãªãã·ã§ã³ [ ... ] ]
ãªãã·ã§ã³ã¯ä»¥äžã®çµã¿åããïŒ
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
| CREATEUSER | NOCREATEUSER
| INHERIT | NOINHERIT
| LOGIN | NOLOGIN
| CONNECTION LIMIT æ倧æ¥ç¶æ°
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'ãã¹ã¯ãŒãæåå'
| VALID UNTIL 'æå»è¡šçŸ'
| IN ROLE ããŒã«å [, ...]
| IN GROUP ããŒã«å [, ...]
| ROLE ããŒã«å [, ...]
| ADMIN ããŒã«å [, ...]
| USER ããŒã«å [, ...]
| SYSID ãŠãŒã¶ID CREATE [ DEFAULT ] CONVERSION å€æã«ãŒã«å
FOR å€æåã®ãšã³ã³ãŒãã£ã³ã° TO å€æåŸã®ãšã³ã³ãŒãã£ã³ã° FROM é¢æ°å CREATE [ OR REPLACE ] FUNCTION
é¢æ°å ( [ [ åŒæ°ã®ã¢ãŒã ] [ åŒæ°å ] åŒæ°ã®å
[ { DEFAULT | = } ããã©ã«ãå€ã®è©äŸ¡åŒ ] [, ...] ] )
[ RETURNS æ»ãå€ã®å
| RETURNS TABLE ( ã«ã©ã å ã«ã©ã ã®å [, ...] ) ]
{ LANGUAGE èšèªå
| WINDOW
| IMMUTABLE | STABLE | VOLATILE
| CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
| [EXTERNAL] SECURITY INVOKER | [EXTERNAL] SECURITY DEFINER
| COST å®è¡ã³ã¹ãå€
| ROWS çµæã®è¡æ°
| SET èšå®ãã©ã¡ãŒã¿ { TO å€ | = å€ | FROM CURRENT }
| AS 'å®çŸ©èšè¿°'
| AS 'ãªããžã§ã¯ããã¡ã€ã«å', 'ãªã³ã¯ã·ã³ãã«'
} ...
[ WITH ( å±æ§ [, ...] ) ] CREATE [ OR REPLACE ] RULE ã«ãŒã«å AS ON ã€ãã³ã
TO ããŒãã«å [ WHERE æ¡ä»¶ ]
DO [ ALSO | INSTEAD ] { NOTHING | ã³ãã³ã | ( ã³ãã³ã ; ã³ãã³ã ... ) } CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] VIEW ãã¥ãŒå [ ( ã«ã©ã å [, ...] ) ]
AS ã¯ãšãªãŒæåå CREATE [ PROCEDURAL ] LANGUAGE èšèªå
CREATE [ TRUSTED ] [ PROCEDURAL ] LANGUAGE èšèªå
HANDLER åŒã³åºããã³ãã© [ VALIDATOR ããªããŒã·ã§ã³é¢æ° ] CREATE [ TEMPORARY | TEMP ] SEQUENCE ã·ãŒã±ã³ã¹å [ INCREMENT [ BY ] å¢å ]
[ MINVALUE æå°å€ | NO MINVALUE ] [ MAXVALUE æå€§å€ | NO MAXVALUE ]
[ START [ WITH ] éå§çªå· ] [ CACHE ãã£ãã·ã¥æ° ] [ [ NO ] CYCLE ] [ OWNED BY { ããŒãã«å.ã«ã©ã å | NONE } ] CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] ã€ã³ããã¯ã¹å ON ããŒãã«å [ USING ã€ã³ããã¯ã¹ã¡ãœãã ]
( { ã«ã©ã å | ( è©äŸ¡åŒ ) } [ æŒç®åã¯ã©ã¹ ] [ ASC | DESC ]
[ NULLS { FIRST | LAST } ] [, ...] )
[ WITH ( æ ŒçŽãã©ã¡ãŒã¿ = å€ [, ... ] ) ]
[ TABLESPACE ããŒãã«ã¹ããŒã¹å ]
[ WHERE è¿°èª ] CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE ããŒãã«å
[ (ã«ã©ã å [, ...] ) ]
[ WITH ( æ ŒçŽåãã©ã¡ãŒã¿ [= å€] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]
[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]
[ TABLESPACE ããŒãã«ã¹ããŒã¹å ]
AS ã¯ãšãªãŒæåå
[ WITH [ NO ] DATA ] CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE ããŒãã«å (
[ ã«ã©ã å ããŒã¿å [ DEFAULT ããã©ã«ãè©äŸ¡åŒ ] [ ã«ã©ã å¶çŽ [ ... ] ]
| ããŒãã«å¶çŽ
| LIKE 芪ããŒãã« [ { INCLUDING | EXCLUDING } DEFAULTS | CONSTRAINTS | INDEXES } ] ... }
[, ... ]
] )
[ INHERITS ( 芪ããŒãã« [, ... ] ) ]
[ WITH ( ã¹ãã¬ãŒãžãã©ã¡ãŒã¿ [= å€] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]
[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]
[ TABLESPACE ããŒãã«ã¹ããŒã¹å ]
ã«ã©ã å¶çŽã¯ä»¥äžã®éãïŒ
[ CONSTRAINT å¶çŽå ]
{ NOT NULL |
NULL |
UNIQUE ã€ã³ããã¯ã¹ãã©ã¡ãŒã¿çŸ€ |
PRIMARY KEY ã€ã³ããã¯ã¹ãã©ã¡ãŒã¿çŸ€ |
CHECK ( è©äŸ¡åŒ ) |
REFERENCES 被åç
§ããŒãã« [ ( 被åç
§ã«ã©ã ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ]
[ ON DELETE ã¢ã¯ã·ã§ã³ ] [ ON UPDATE ã¢ã¯ã·ã§ã³ ] }
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
ããŒãã«å¶çŽã¯ä»¥äžã®éãïŒ
[ CONSTRAINT å¶çŽå ]
{ UNIQUE ( ã«ã©ã å [, ... ] ) ã€ã³ããã¯ã¹ãã©ã¡ãŒã¿çŸ€ |
PRIMARY KEY ( ã«ã©ã å [, ... ] ) ã€ã³ããã¯ã¹ãã©ã¡ãŒã¿çŸ€ |
CHECK ( è©äŸ¡åŒ ) |
FOREIGN KEY ( ã«ã©ã å [, ... ] ) REFERENCES 被åç
§ããŒãã« [ ( 被åç
§ã«ã©ã [, ... ] ) ]
[ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE ã¢ã¯ã·ã§ã³ ] [ ON UPDATE ã¢ã¯ã·ã§ã³ ] }
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
UNIQUE ããã³ PRIMARY KEY å¶çŽã®äžã®ã€ã³ããã¯ã¹ãã©ã¡ãŒã¿çŸ€:
[ WITH ( ã¹ãã¬ãŒãžãã©ã¡ãŒã¿ [= å€] [, ... ] ) ]
[ USING INDEX TABLESPACE ããŒãã«ã¹ããŒã¹å ] ããŒãã«ã®å
容ã«ã»ã«ãè¿œå ã§ããŸããã§ããïŒå
šã»ã«æ° %d ãå¶éãè¶ããŠããŸãã
ããŒãã«ã®å
容ã«èŠåºããè¿œå ã§ããŸããã§ããïŒã«ã©ã æ° %d ãå¶éãè¶ããŠããŸãã
ãã°ã€ã³ã§ããªã ãã§ã㯠CHECK å¶çŽ: ç
§åé åº ã«ã©ã ã¢ã¯ã»ã¹æš©éãå¥å¥ªãã ã³ãã³ã: %s
説æ: %s
æžåŒ:
%s
è€åå "%s.%s" æ¥ç¶
DBãäœæã§ãã ããŒã«ãäœæã§ãã Ctype(å€ææŒç®å) DEALLOCATE [ PREPARE ] { å®è¡ãã©ã³å | ALL } DECLARE ã«ãŒãœã«å [ BINARY ] [ INSENSITIVE ] [ [ NO ] SCROLL ]
CURSOR [ { WITH | WITHOUT } HOLD ] FOR ã¯ãšãªãŒæåå DELETE FROM [ ONLY ] ããŒãã«å [ [ AS ] å¥å ]
[ USING USING䞊㳠]
[ WHERE æ¡ä»¶ | WHERE CURRENT OF ã«ãŒãœã«å ]
[ RETURNING * | åºåè¡šçŸ [ AS åºåå ] [, ...] ] DISCARD { ALL | PLANS | TEMPORARY | TEMP } DROP AGGREGATE [ IF EXISTS ] éçŽé¢æ°å ( ããŒã¿å [ , ... ] ) [ CASCADE | RESTRICT ] DROP CAST [ IF EXISTS ] (ãã£ã¹ãåã®å AS ãã£ã¹ãåŸã®å) [ CASCADE | RESTRICT ] DROP CONVERSION [ IF EXISTS ] å€æã«ãŒã«å [ CASCADE | RESTRICT ] DROP DATABASE [ IF EXISTS ] ããŒã¿ããŒã¹å DROP DOMAIN [ IF EXISTS ] ãã¡ã€ã³å [, ...] [ CASCADE | RESTRICT ] DROP FOREIGN DATA WRAPPER [ IF EXISTS ] å€éšããŒã¿ã©ãããŒå
[ CASCADE | RESTRICT ] DROP FUNCTION [ IF EXISTS ] é¢æ°å ( [ [ åŒæ°ã®ã¢ãŒã ] [ åŒæ°ã®åå ] ããŒã¿å [, ...] ] )
[ CASCADE | RESTRICT ] DROP GROUP [ IF EXISTS ] ã°ã«ãŒãå [, ...] DROP INDEX [ IF EXISTS ] ã€ã³ããã¯ã¹å [, ...] [ CASCADE | RESTRICT ] DROP OPERATOR CLASS [ IF EXISTS ] æŒç®åã¯ã©ã¹å USING ã€ã³ããã¯ã¹ã¡ãœãã [ CASCADE | RESTRICT ] DROP OPERATOR FAMILY [ IF EXISTS ] æŒç®åã¯ã©ã¹å USING ã€ã³ããã¯ã¹ã¡ãœãã [ CASCADE | RESTRICT ] DROP OPERATOR [ IF EXISTS ] æŒç®åå ( { 巊蟺ã®å | NONE } , { å³èŸºã®å | NONE } ) [ CASCADE | RESTRICT ] DROP OWNED BY åå [, ...] [ CASCADE | RESTRICT ] DROP ROLE [ IF EXISTS ] ããŒã«å [, ...] DROP RULE [ IF EXISTS ] ã«ãŒã«å ON ãªã¬ãŒã·ã§ã³ [ CASCADE | RESTRICT ] DROP SCHEMA [ IF EXISTS ] ã¹ããŒãå [, ...] [ CASCADE | RESTRICT ] DROP SEQUENCE [ IF EXISTS ] ã·ãŒã±ã³ã¹å [, ...] [ CASCADE | RESTRICT ] DROP SERVER [ IF EXISTS ] ãµãŒãå [ CASCADE | RESTRICT ] DROP TABLE [ IF EXISTS ] ããŒãã«å [, ...] [ CASCADE | RESTRICT ] DROP TABLESPACE [ IF EXISTS ] ããŒãã«ã¹ããŒã¹å DROP TEXT SEARCH CONFIGURATION [ IF EXISTS ] èšå®å [ CASCADE | RESTRICT ] DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] èŸæžå [ CASCADE | RESTRICT ] DROP TEXT SEARCH PARSER [ IF EXISTS ] ããŒãµå [ CASCADE | RESTRICT ] DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] ãã³ãã¬ãŒãå [ CASCADE | RESTRICT ] DROP TRIGGER [ IF EXISTS ] ããªã¬å ON ããŒãã«å [ CASCADE | RESTRICT ] DROP TYPE [ IF EXISTS ] ããŒã¿åå [, ...] [ CASCADE | RESTRICT ] DROP USER MAPPING [ IF EXISTS ] FOR { ãŠãŒã¶å | USER | CURRENT_USER | PUBLIC } SERVER ãµãŒãå DROP USER [ IF EXISTS ] ãŠãŒã¶å [, ...] DROP VIEW [ IF EXISTS ] ãã¥ãŒå [, ...] [ CASCADE | RESTRICT ] DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] èšèªå [ CASCADE | RESTRICT ] ããã©ã«ãã®ããã¿ã¯ off ã§ãã ããã©ã«ãã®ããã¿ã¯ on ã§ãã ããã©ã«ãïŒ èª¬æ å®å
èŸæž "%s" ãšããååã®ãªã¬ãŒã·ã§ã³ãèŠã€ãããŸããã
OID %s ãæã€ãªã¬ãŒã·ã§ã³ãèŠã€ãããŸããã
ããã¹ãæ€çŽ¢çšèšå® "%s" ãèŠã€ãããŸããã
ããã¹ãæ€çŽ¢çšããŒãµ "%s" ãèŠã€ãããŸããã
ç¡å¹ã«ãããã«ãŒã«ïŒ ç¡å¹ã«ãããããªã¬ïŒ END [ WORK | TRANSACTION ] EXECUTE å®è¡ãã©ã³å [ ( ãã©ã¡ãŒã¿ [, ...] ) ] EXPLAIN [ ANALYZE ] [ VERBOSE ] ã¹ããŒãã¡ã³ã èŠçŽ ãšã³ã³ãŒãã£ã³ã° ããŒã¹çµäº ã³ããŒããããŒã¿ã«ç¶ããŠæ¹è¡ãå
¥åããŸãã
ããã¯ã¹ã©ãã·ã¥(\)ãšããªãªãã ãã®è¡ã§çµäºããŸãã ããäžåºŠå
¥åããŠãã ããïŒ æ°ãããã¹ã¯ãŒã: æ¡åŒµè¡šç€ºã¯ off ã§ãã
æ¡åŒµè¡šç€ºã¯ on ã§ãã
FETCH [ æ¹å { FROM | IN } ] ã«ãŒãœã«å
æ¹åã¯æå®ããªããããããã¯ä»¥äžã®ããããïŒ
NEXT
PRIOR
FIRST
LAST
ABSOLUTE è¡çªå·
RELATIVE è¡æ°
è¡æ°
ALL
FORWARD
FORWARD è¡æ°
FORWARD ALL
BACKWARD
BACKWARD è¡æ°
BACKWARD ALL 倱æã
ãã£ãŒã«ãåºåãæå㯠"%s" ã§ãã
å€éšããŒã¿ã©ãã㌠å€éšããŒå¶çŽ: æžåŒèšå®
é¢æ° GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }
[,...] | ALL [ PRIVILEGES ] }
ON [ TABLE ] ããŒãã«å [, ...]
TO { [ GROUP ] ããŒã«å | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { { SELECT | INSERT | UPDATE | REFERENCES } ( ã«ã©ã å [, ...] )
[,...] | ALL [ PRIVILEGES ] ( ã«ã©ã å [, ...] ) }
ON [ TABLE ] ããŒãã«å [, ...]
TO { [ GROUP ] ããŒã«å | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { { USAGE | SELECT | UPDATE }
[,...] | ALL [ PRIVILEGES ] }
ON SEQUENCE ã·ãŒã±ã³ã¹å [, ...]
TO { [ GROUP ] ããŒã«å | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { { CREATE | CONNECT | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }
ON DATABASE ããŒã¿ããŒã¹å [, ...]
TO { [ GROUP ] ããŒã«å | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { USAGE | ALL [ PRIVILEGES ] }
ON FOREIGN DATA WRAPPER å€éšã©ãããŒå [, ...]
TO { [ GROUP ] ããŒã«å | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { USAGE | ALL [ PRIVILEGES ] }
ON FOREIGN SERVER å€éšãµãŒãå [, ...]
TO { [ GROUP ] ããŒã«å | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { EXECUTE | ALL [ PRIVILEGES ] }
ON FUNCTION é¢æ°å ( [ [ åŒæ°ã®ã¢ãŒã ] [ åŒæ°ã®åå ] åŒæ°ã®ããŒã¿å [, ...] ] ) [, ...]
TO { [ GROUP ] ããŒã«å | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { USAGE | ALL [ PRIVILEGES ] }
ON LANGUAGE èšèªå [, ...]
TO { [ GROUP ] ããŒã«å | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }
ON SCHEMA ã¹ããŒãå [, ...]
TO { [ GROUP ] ããŒã«å | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { CREATE | ALL [ PRIVILEGES ] }
ON TABLESPACE ããŒãã«ã¹ããŒã¹å [, ...]
TO { [ GROUP ] ããŒã«å | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT ããŒã« [, ...] TO { ããŒã«å [, ...] [ WITH ADMIN OPTION ] äžè¬
äžè¬çãªãªãã·ã§ã³ïŒ
èŠåºãã®ååŸ æ¬¡ã®ããŒã¯ã³ãååŸ ããŒã¯ã³ã¿ã€ãã®ååŸ OID ãæ〠ID INSERT INTO ããŒãã«å [ ( ã«ã©ã å [, ...] ) ]
{ DEFAULT VALUES | VALUES ( { è©äŸ¡åŒ | DEFAULT } [, ...] ) [, ...] | ã¯ãšãªãŒæåå }
[ RETURNING * | åºåè©äŸ¡åŒ [ AS åºåå ] [, ...] ] æé»? ã€ã³ããã¯ã¹ "%s.%s" ã€ã³ããã¯ã¹: æ
å ±
ç¶æ¿ åæå åæåãªãã·ã§ã³: å
¥åºå
å
éšå äžæãããŸãã
\%sïŒäžæ£ãªã³ãã³ãã§ãã\? ã§ãã«ããåç
§ããŠãã ããã
LISTEN ã¡ãã»ãŒãžå LOAD 'ãã¡ã€ã«å' LOCK [ TABLE ] ããŒãã«å [, ...] [ IN ããã¯ã¢ãŒã MODE ] [ NOWAIT ]
ããã¯ã¢ãŒãã¯ä»¥äžã®ããããïŒ
ACCESS SHARE | ROW SHARE | ROW EXCLUSIVE | SHARE UPDATE EXCLUSIVE
| SHARE | SHARE ROW EXCLUSIVE | EXCLUSIVE | ACCESS EXCLUSIVE èšèª ã©ãŒãžãªããžã§ã¯ã
ã©ãŒãžãªããžã§ã¯ã 巊蟺ã®å Lex åŠç éçŽé¢æ°äžèŠ§ ãã£ã¹ãäžèŠ§ å€æã«ãŒã«äžèŠ§ ããŒã¿åäžèŠ§ ããŒã¿ããŒã¹äžèŠ§ ãã¡ã€ã³äžèŠ§ å€éšãµãŒãäžèŠ§ å€éšããŒã¿ã©ãããŒã®äžèŠ§ é¢æ°äžèŠ§ æŒç®åäžèŠ§ ãªã¬ãŒã·ã§ã³ã®äžèŠ§ ããŒã«äžèŠ§ ã¹ããŒãäžèŠ§ ããŒãã«ã¹ããŒã¹äžèŠ§ ããã¹ãæ€çŽ¢çšèšå®äžèŠ§ ããã¹ãæ€çŽ¢çšèŸæžã®äžèŠ§ ããã¹ãæ€çŽ¢çšããŒãµäžèŠ§ ããã¹ãæ€çŽ¢çšãã³ãã¬ãŒãäžèŠ§ ãŠãŒã¶ãããã³ã°ã®äžèŠ§ ãã±ãŒã«ã§èª¿æŽãããæ°å€åºå㯠off ã§ãã å Žæ MOVE [ æ¹å { FROM | IN } ] ã«ãŒãœã«å ã¡ã³ã㌠ã¡ãœãã ä¿®é£Ÿèª ä¿®é£Ÿèª NOTIFY ã¡ãã»ãŒãžå åå å€æŽãªã æ¥ç¶ãªã "%-.*s" ã«ã€ããŠã¯ãã«ãæ
å ±ããããŸããã
åŒæ°ãªã㧠\h ãšã¿ã€ããããšããã«ãã®äžèŠ§ã衚瀺ãããŸãã
ç¶æ¿ãªã ããããããªã¬ãŒã·ã§ã³ãèŠã€ãããŸãã
ãªã¬ãŒã·ã§ã³ããããŸããã
Null 衚瀺㯠"%s" ã§ãã
ãªããžã§ã¯ã ãªããžã§ã¯ãã®èª¬æ ãªãã¬ãŒãã£ã³ã°ã·ã¹ãã
ãªãã·ã§ã³ åºåãã©ãŒããã㯠"%s" ã§ãã
ææè
PREPARE TRANSACTION ãã©ã³ã¶ã¯ã·ã§ã³ID PREPARE å®è¡ãã©ã³å [ ( ããŒã¿å [, ...] ) ] AS ã¹ããŒãã¡ã³ã åžžã«ããŒãžã£ã䜿ãããŸãã åºåãé·ãå Žåã¯ããŒãžã£ã䜿ãããŸãã ãããŒãžã£ã䜿ãã㯠off ã§ãã ãã¹ã¯ãŒãã®æå·åã«å€±æããŸããã
ãŠãŒã¶ %s ã®ãã¹ã¯ãŒã: ãã¹ã¯ãŒã: ãã¹ã¯ãŒãããããããŸããã
以åã®æ¥ç¶ã¯ä¿æãããŠããŸãã
ã¯ãšãªãŒãããã¡
ã¯ãšãªãŒãããã¡ã¯ç©ºã§ãã ã¯ãšãªãŒãããã¡ããªã»ããïŒã¯ãªã¢ïŒãããŸããã REASSIGN OWNED BY å
ã®ããŒã«å [, ...] TO æ°ããããŒã«å REINDEX { INDEX | TABLE | DATABASE | SYSTEM } åå [ FORCE ] RELEASE [ SAVEPOINT ] ã»ãŒããã€ã³ãå RESET ãã©ã¡ãŒã¿å
RESET ALL REVOKE [ GRANT OPTION FOR ]
{ { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }
[,...] | ALL [ PRIVILEGES ] }
ON [ TABLE ] ããŒãã«å [, ...]
FROM { [ GROUP ] ããŒã«å | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ { SELECT | INSERT | UPDATE | REFERENCES } ( ã«ã©ã å [, ...] )
[,...] | ALL [ PRIVILEGES ] ( ã«ã©ã å [, ...] ) }
ON [ TABLE ] ããŒãã«å [, ...]
FROM { [ GROUP ] ããŒã«å | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ { USAGE | SELECT | UPDATE }
[,...] | ALL [ PRIVILEGES ] }
ON SEQUENCE ã·ãŒã±ã³ã¹å [, ...]
FROM { [ GROUP ] ããŒã«å | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ { CREATE | CONNECT | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }
ON DATABASE ããŒã¿ããŒã¹å [, ...]
FROM { [ GROUP ] ããŒã«å | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ USAGE | ALL [ PRIVILEGES ] }
ON FOREIGN DATA WRAPPER å€éšããŒã¿ã©ãããŒå [, ...]
FROM { [ GROUP ] ããŒã«å | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ USAGE | ALL [ PRIVILEGES ] }
ON FOREIGN SERVER å€éšãµãŒãå [, ...]
FROM { [ GROUP ] ããŒã«å | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ EXECUTE | ALL [ PRIVILEGES ] }
ON FUNCTION é¢æ°å ( [ [ åŒæ°ã®ã¢ãŒã ] [ åŒæ°ã®åå ] åŒæ°ã®å [, ...] ] ) [, ...]
FROM { [ GROUP ] ããŒã«å | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ USAGE | ALL [ PRIVILEGES ] }
ON LANGUAGE èšèªå [, ...]
FROM { [ GROUP ] ããŒã«å | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }
ON SCHEMA ã¹ããŒãå [, ...]
FROM { [ GROUP ] ããŒã«å | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ CREATE | ALL [ PRIVILEGES ] }
ON TABLESPACE ããŒãã«ã¹ããŒã¹å [, ...]
FROM { [ GROUP ] ããŒã«å | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ ADMIN OPTION FOR ]
ããŒã« [, ...] FROM ããŒã«å [, ...]
[ CASCADE | RESTRICT ] ROLLBACK PREPARED ãã©ã³ã¶ã¯ã·ã§ã³ID ROLLBACK [ WORK | TRANSACTION ] ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] ã»ãŒããã€ã³ãå ã¬ã³ãŒãåºåãæå㯠"%s" ã§ãã
ã¬ã³ãŒãåºåãæå㯠ã§ãã åç
§å
ïŒ äžå
·åã¯ãŸã§å ±åããŠãã ããã
çµæã®ããŒã¿å çµæã®å å³èŸºã®å ããŒã«å åžžã«ç¡èŠãããã«ãŒã« ã¬ããªã«ã§ã®ã¿ç¡èŠãããã«ãŒã« ã«ãŒã«: SAVEPOINT ã»ãŒããã€ã³ãå SET CONSTRAINTS { ALL | å¶çŽå [, ...] } { DEFERRED | IMMEDIATE } SET TRANSACTION ãã©ã³ã¶ã¯ã·ã§ã³ã¢ãŒã [, ...]
SET SESSION CHARACTERISTICS AS TRANSACTION ãã©ã³ã¶ã¯ã·ã§ã³ã¢ãŒã [, ...]
ãã©ã³ã¶ã¯ã·ã§ã³ã¢ãŒãã¯ä»¥äžã®ããããïŒ
ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
READ WRITE | READ ONLY SET [ SESSION | LOCAL ] ROLE ããŒã«å
SET [ SESSION | LOCAL ] ROLE NONE
RESET ROLE SET [ SESSION | LOCAL ] SESSION AUTHORIZATION ãŠãŒã¶å
SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT
RESET SESSION AUTHORIZATION SET [ SESSION | LOCAL ] èšå®ãã©ã¡ãŒã¿å { TO | = } { å€ | 'å€' | DEFAULT }
SET [ SESSION | LOCAL ] TIME ZONE { ã¿ã€ã ãŸãŒã³ | LOCAL | DEFAULT } SHOW ãã©ã¡ãŒã¿å
SHOW ALL SSL æ¥ç¶ (æå·åæ¹åŒ: %s, ãããé·: %i)
SSL æ¥ç¶ (æªå®çŸ©ã®æå·åæ¹åŒ)
START TRANSACTION [ ãã©ã³ã¶ã¯ã·ã§ã³ã¢ãŒã [, ...] ]
ãã©ã³ã¶ã¯ã·ã§ã³ã¢ãŒãã¯ä»¥äžã®ããããïŒ
ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
READ WRITE | READ ONLY ã¹ããŒã ã·ãŒã±ã³ã¹ "%s.%s" ãµãŒã ãã±ãŒã«ã§èª¿æŽãããæ°å€åºåã衚瀺ããŠããŸãã ã¿ãã«ã®ã¿ã衚瀺ããŠããŸãã ãµã€ãº ãœãŒã¹ ãœãŒã¹ã³ãŒã ãœãŒã¹ã®å ç¹æ®ãªãªã¬ãŒã·ã§ã³ "%s.%s" ããŒã¹èµ·å ã¹ãã¬ãŒãž æåã
ã¹ãŒããŒãŠãŒã¶ TOAST ããŒãã« "%s.%s" TRUNCATE [ TABLE ] [ ONLY ] ããŒãã«å [, ... ]
[ RESTART IDENTITY | CONTINUE IDENTITY ] [ CASCADE | RESTRICT ] ããŒãã« ããŒãã« "%s.%s" ããŒãã«å±æ§ã¯ "%s" ã§ãã
ããŒãã«å±æ§ã¯ã»ãããããŠããŸããã
ããŒãã«ã¹ããŒã¹ ããŒãã«ã¹ããŒã¹ "%s" ã¿ãŒã²ããã®å "wrapped" ãã©ãŒãããã®å¯Ÿè±¡å¹
㯠%d ã§ãã
ãã³ãã¬ãŒã ããã¹ãæ€çŽ¢çšèšå® "%s" ããã¹ãæ€çŽ¢çšèšå® "%s.%s" ããã¹ãæ€çŽ¢çšããŒãµ "%s" ããã¹ãæ€çŽ¢çšããŒãµ "%s.%s" ãµãŒããžã®æ¥ç¶ãåããŸããããªã»ããããŠããŸã: ãã®ãµãŒã(ããŒãžã§ã³%d.%d)ã¯å€éšãµãŒãããµããŒãããŠããŸããã
ãã®ãµãŒãã®ããŒãžã§ã³ (%d.%d) ã¯å€éšããŒã¿ã©ãããŒããµããŒãããŠããŸããã
ãã®ãµãŒãã®ããŒãžã§ã³ (%d.%d) ã¯ããŒãã«ã¹ããŒã¹ããµããŒãããŠããŸããã
ãã®ãµãŒã(ããŒãžã§ã³%d.%d)ã§ã¯ãON_ERROR_ROLLBACKçšã®ã»ãŒããã€ã³ãããµããŒãããŠããŸããã
ãã®ãµãŒãã®ããŒãžã§ã³ (%d.%d) ã¯ããŒãã«ã¹ããŒã¹ããµããŒãããŠããŸããã
ãã®ãµãŒã(ããŒãžã§ã³%d.%d)ã¯ãŠãŒã¶ãããããµããŒãããŠããŸããã
æé: %.3f ms
ã¿ã€ãã³ã°ã¯ off ã§ãã ã¿ã€ãã³ã°ã¯ on ã§ãã ã¿ã€ãã«ã¯ "%s" ã§ãã
ã¿ã€ãã«ã¯ã»ãããããŠããŸããã
ããŒã¯ã³ ããŒã¯ã³å ããŒãµ "%s" ã®ããŒã¯ã³ã¿ã€ã ããŒãµ "%s.%s" ã®ããŒã¯ã³ã¿ã€ã åžžã«ç¡èŠãããããªã¬ ã¬ããªã«ã§ã®ã¿ç¡èŠãããããªã¬ ããªã¬: 詳现㯠'%s --help' ãããããã ãã
ãã¿ãã«ã®ã¿è¡šç€ºã㯠off ã§ãã å "help" ã§ãã«ãã衚瀺ããŸã.
\copyright ãšã¿ã€ããããšãé
åžæ¡ä»¶ã衚瀺ããŸãã
\h ãšã¿ã€ããããšãSQL ã³ãã³ãã®ãã«ãã衚瀺ããŸãã
\? ãšã¿ã€ããããšãpsql ã³ãã³ãã®ãã«ãã衚瀺ããŸãã
\g ãšæã€ãã»ãã³ãã³ã§éãããšãã¯ãšãªãŒãå®è¡ããŸãã
\q ã§çµäºããŸãã
UNLISTEN { éç¥ã¡ãã»ãŒãžå | * } UPDATE [ ONLY ] ããŒãã«å [ [ AS ] å¥å ]
SET { ã«ã©ã å = { è©äŸ¡åŒ | DEFAULT } |
( ã«ã©ã å [, ...] ) = ( { è©äŸ¡åŒ | DEFAULT } [, ...] ) } [, ...]
[ FROM FROMé
ç®äžŠã³ ]
[ WHERE æ¡ä»¶ | WHERE CURRENT OF ã«ãŒãœã«å ]
[ RETURNING * | åºåè©äŸ¡åŒ [ AS åºåå ] [, ...] ] 䜿çšæ¹æ³:
"\q" 㧠%s ãæããŸãã
ãŠãŒã¶å VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ ããŒãã«å ]
VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ ããŒãã«å [ (ã«ã©ã å [, ...] ) ] ] VALUES ( è©äŸ¡åŒ [, ...] ) [, ...]
[ ORDER BY ãœãŒãè©äŸ¡åŒ [ ASC | DESC | USING æŒç®å ] [, ...] ]
[ LIMIT { è¡æ° | ALL } ]
[ OFFSET éå§è¡çªå· [ ROW | ROWS ] ]
[ FETCH { FIRST | NEXT } [ è¡æ° ] { ROW | ROWS } ONLY ] ããªããŒã¿ å€ å€æ°
ããŒãžã§ã³ ãã¥ãŒ "%s.%s" ãã¥ãŒå®çŸ©: æ®çºæ§ 泚æïŒ %s ããŒãžã§ã³ %d.%d, ãµãŒãããŒãžã§ã³ %d.%d.
psql ã®æ©èœã®äžã§ãåäœããªããã®ããããããããŸããã
èŠåïŒã³ã³ãœãŒã«ã®ã³ãŒãããŒãž (%u) ã Windows ã®ã³ãŒãããŒãž (%u) ãš
ç°ãªãããã8 ãããæååãæ£ããåäœããªãå¯èœæ§ããããŸãã
詳现㯠psql ãªãã¡ã¬ã³ã¹ããã¥ã¢ã«ã® "Notes for Windows users"
ïŒãŠã£ã³ããŠãºãŠãŒã¶ã®ããã«ïŒãåç
§ããŠãã ããã
ãã¡ã€ã« "%s/%s" ã«ãã¹ããªãåºåããŸããã
çŸåšããŒã¿ããŒã¹ã«ã¯æ¥ç¶ããŠããŸããã
ããŒã¿ããŒã¹ "%s" ã«æ¥ç¶ããŸããã ãã㯠psql : PostgreSQL ãžã®ã³ãã³ãã©ã€ã³ã»ã€ã³ã¿ãŒãã§ãŒã¹ã§ãã [ WITH [ RECURSIVE ] WITHã¯ãšãªãŒ [, ...] ]
SELECT [ ALL | DISTINCT [ ON ( è©äŸ¡åŒ [, ...] ) ] ]
* | è©äŸ¡åŒ [ AS åºåé
ç®å ] [, ...]
INTO [ TEMPORARY | TEMP ] [ TABLE ] æ°ããããŒãã«å
[ FROM FROMé
ç® [, ...] ]
[ WHERE æ¡ä»¶ ]
[ GROUP BY è©äŸ¡åŒ [, ...] ]
[ HAVING æ¡ä»¶ [, ...] ]
[ WINDOW ãŠã£ã³ããŠå AS ( ãŠã£ã³ããŠå®çŸ© ) [, ...] ]
[ { UNION | INTERSECT | EXCEPT } [ ALL ] SELECTå¥ ]
[ ORDER BY è©äŸ¡åŒ [ ASC | DESC | USING æŒç®å ] [ NULLS { FIRST | LAST } ] [, ...] ]
[ LIMIT { è¡æ° | ALL } ]
[ OFFSET éå§è¡çªå· [ ROW | ROWS ] ]
[ FETCH { FIRST | NEXT } [ è¡æ° ] { ROW | ROWS } ONLY ]
[ FOR { UPDATE | SHARE } [ OF ããŒãã«å [, ...] ] [ NOWAIT ] [...] ] [ WITH [ RECURSIVE ] WITHã¯ãšãªãŒ [, ...] ]
SELECT [ ALL | DISTINCT [ ON ( è©äŸ¡åŒ [, ...] ) ] ]
* | è©äŸ¡åŒ [ [ AS ] åºåé
ç®å ] [, ...]
[ FROM FROMé
ç® [, ...] ]
[ WHERE æ¡ä»¶ ]
[ GROUP BY è©äŸ¡åŒ [, ...] ]
[ HAVING æ¡ä»¶ [, ...] ]
[ WINDOW ãŠã£ã³ããŠå AS ( ãŠã£ã³ããŠå®çŸ© ) [, ...] ]
[ { UNION | INTERSECT | EXCEPT } [ ALL ] SELECTå¥ ]
[ ORDER BY è©äŸ¡åŒ [ ASC | DESC | USING æŒç®å ] [ NULLS { FIRST | LAST } ] [, ...] ]
[ LIMIT { è¡æ° | ALL } ]
[ OFFSET éå§è¡çªå· [ ROW | ROWS ] ]
[ FETCH { FIRST | NEXT } [ è¡æ° ] { ROW | ROWS } ONLY ]
[ FOR { UPDATE | SHARE } [ OF ããŒãã«å [, ...] ] [ NOWAIT ] [...] ]
ããã§FROMé
ç®ã¯ä»¥äžã®ããããã§ãã
[ ONLY ] ããŒãã«å [ * ] [ [ AS ] å¥å [ ( åã®å¥å [, ...] ) ] ]
( select ) [ AS ] å¥å [ ( åã®å¥å [, ...] ) ]
WITHã¯ãšãªãŒå [ [ AS ] å¥å [ ( åã®å¥å [, ...] ) ] ]
é¢æ°å ( [ åŒæ° [, ...] ] ) [ AS ] alias [ ( åã®å¥å [, ...] | åã®å®çŸ© [, ...] ) ]
é¢æ°å ( [ åŒæ° [, ...] ] ) AS ( åã®å®çŸ© [, ...] )
FROMé
ç® [ NATURAL ] çµåçš®é¡ FROMé
ç® [ ON çµåæ¡ä»¶ | USING "( çµåå [, ...] ) ]
WITHã¯ãšãªãŒã¯ä»¥äžã®éãã§ãã
WITHã¯ãšãªãŒå [ ( åå [, ...] ) ] AS ( select )
TABLE { [ ONLY ] ããŒãã«å [ * ] | WITHã¯ãšãªãŒå } \!: 倱æ
\%s: ãã£ã¬ã¯ããªã "%s" ã«å€æŽã§ããŸããïŒ%s
\%s: ãšã©ãŒ
\%s: äœåãªåŒæ° "%s" ã¯ç¡èŠãããŸããã
\%s: åŒæ°ãäžè¶³ããŠããŸãã
\connect: %s \copy: %s \copy: åŒæ°ããããŸããã
\copy: "%s" ã§ããŒã¹ãšã©ãŒçºç
\copy: è¡æ«ã§ããŒã¹ãšã©ãŒçºç
\copy: äºæããªãå¿ç (%d)
ãµãŒãããŒãžã§ã³%d.%dã§ã¯\dfã¯"w"ãªãã·ã§ã³ãåãä»ããŸãã
\dfã¯ãªãã·ã§ã³ãšããŠ[antwS+]ã®ã¿ãåãããšãã§ããŸã
\pset: æå¹ãªãã©ãŒããã㯠unaligned, aligned, wrapped, html, latex, troff-ms ã§ãã
\pset: æªå®çŸ©ã®ãªãã·ã§ã³ïŒ%s
çŸåšã®ãã©ã³ã¶ã¯ã·ã§ã³ãäžæãã èªã¿èŸŒã¿ã«å€±æããããç°åžžçµäºããŸãã aggïŒéçŽïŒ éçŽé¢æ° ïŒãã§ãŒãºã³ãããçšã«äºåæºåããããã©ã³ã¶ã¯ã·ã§ã³ããã£ã³ã»ã«ãã ãŠãŒã¶ã«ãããã£ã³ã»ã«ãããŸãã äžæãã£ã¬ã¯ã㪠"%s" ãèŠã€ãããŸããã ããŒã¿ããŒã¹ãå€æŽãã ããŒã¿ããŒã¹ã®ããŒã«ãå€æŽãã å®è¡æãã©ã¡ãŒã¿ãå€æŽãã ããŒã«ã®ååãŸãã¯ã¡ã³ããŒã·ãããå€æŽãã ãšã³ã³ãŒãã£ã³ã°å€æã«ãŒã«ã®å®çŸ©ãå€æŽãã ãã¡ã€ã³ã®å®çŸ©ãå€æŽãã å€éšãµãŒãã®å®çŸ©ãå€æŽãã å€éšããŒã¿ã©ãããŒã®å®çŸ©ãå€æŽãã é¢æ°ã®å®çŸ©ãå€æŽãã æç¶ãèšèªã®å®çŸ©ãå€æŽãã ã¹ããŒãã®å®çŸ©ãå€æŽãã ã·ãŒã±ã³ã¹çæåšã®å®çŸ©ãå€æŽãã ããŒãã«ã®å®çŸ©ãå€æŽãã ããŒãã«ã¹ããŒã¹ã®å®çŸ©ãå€æŽãã ããã¹ãæ€çŽ¢èšå®ã®å®çŸ©ãå€æŽãã ããã¹ãæ€çŽ¢èŸæžã®å®çŸ©ãå€æŽãã ããã¹ãæ€çŽ¢ããŒãµã®å®çŸ©ãå€æŽãã ããã¹ãæ€çŽ¢ãã³ãã¬ãŒãã®å®çŸ©ãå€æŽãã ããªã¬ã®å®çŸ©ãå€æŽãã åã®å®çŸ©ãå€æŽãã ãŠãŒã¶ãããã³ã°ã®å®çŸ©ãå€æŽãã ãã¥ãŒã®å®çŸ©ãå€æŽãã éçŽé¢æ°ã®å®çŸ©ãå€æŽãã ã€ã³ããã¯ã¹ã®å®çŸ©ãå€æŽãã æŒç®åã®å®çŸ©ãå€æŽãã æŒç®åã¯ã©ã¹ã®å®çŸ©ãå€æŽãã æŒç®åãã¡ããªã®å®çŸ©ãå€æŽãã ããããŒã¿ããŒã¹ããŒã«ãææããããŒã¿ããŒã¹ãªããžã§ã¯ãã®ææè
ãå€æŽãã åããã»ã¹ãçµäºã³ãŒã %d ã§çµäºããŸããã åããã»ã¹ãèªèã§ããªãã¹ããŒã¿ã¹ %d ã«ããçµäºããŸããã åããã»ã¹ãäŸå€ 0x%X ã§çµäºãããããŸããã åããã»ã¹ãã·ã°ãã« %d ã§çµäºãããããŸããã åããã»ã¹ãã·ã°ãã« %s ã§çµäºãããããŸããã ã«ãŒãœã«ãéãã ã€ã³ããã¯ã¹ã«åŸã£ãŠããŒãã«ãã¯ã©ã¹ã¿åãã ããŒã¿ããŒã¹ã®çµ±èšæ
å ±ãåéãã ïŒãã§ãŒãºã³ãããã®ããã«äºåã«æºåããããã©ã³ã¶ã¯ã·ã§ã³ã
ã³ããããã çŸåšã®ãã©ã³ã¶ã¯ã·ã§ã³ãã³ãããïŒç¢ºå®ïŒãã ããŒã«ã®ã»ãããèšç®ããŸã ãµãŒããžã®æ¥ç¶ãåããŸããã
ã³ãã³ãã©ã€ã³ç·šéæ©èœã®ãµããŒããçµã¿èŸŒãŸããŠããŸãã ãã¡ã€ã«ãšããŒãã«éã§ããŒã¿ãã³ããŒãã ãã£ã¬ã¯ããªã "%s" ã«å€æŽã§ããŸããã§ããã å®è¡ã«å¿
èŠãª "%s" ãèŠã€ãããŸããã çŸåšã®ãŠãŒã¶åãååŸã§ããŸãã: %s
ããŒã ãã£ã¬ã¯ã㪠"%s" ã®äœçœ®ãç¹å®ã§ããŸããã
ã«ã¬ã³ããã£ã¬ã¯ã㪠%s ãååŸã§ããŸããã§ããã äžæãã¡ã€ã« "%s" ãéããŸãã: %s
ãã€ããªãã¡ã€ã« "%s" ãèªã¿èŸŒããŸããã§ããã å
¥åãã¡ã€ã«ããèªã¿èŸŒããŸããã§ãã: %s
ã·ã³ããªãã¯ãªã³ã¯ "%s" ãèªã¿èŸŒããŸããã§ããã ãã¡ã€ã« "%s" ã«ãã¹ããªãä¿åã§ããŸããã§ãã: %s
/bin/sh ãèµ·åã§ããŸããã§ããã
ãšãã£ã¿ "%s" ãèµ·åã§ããŸããã
ã³ããŒããŒã¿ãæžã蟌ããŸããïŒ%s
æ°ããããŒã¿ããŒã¹ãäœæãã ããŒãã«ã«æ°ããè¡ãäœæãã ããŒã¿å æºåæžã¿ã¹ããŒãã¡ã³ããéæŸãã ããã©ã«ã %s ã«ãŒãœã«ãå®çŸ©ãã æ°ããéçŽé¢æ°ãå®çŸ©ãã æ°ãããã£ã¹ããå®çŸ©ãã æ°ããå¶çŽããªã¬ãå®çŸ©ãã æ°ããããŒã¿åãå®çŸ©ãã ããŒã¿ããŒã¹ã®æ°ããããŒã«ãå®çŸ©ãã æ°ãããã¡ã€ã³ãå®çŸ©ãã æ°ãããšã³ã³ãŒãã£ã³ã°ã®å€æã«ãŒã«ãå®çŸ©ãã æ°ããå€éšãµãŒããå®çŸ©ãã æ°ããå€éšããŒã¿ã©ãããŒãå®çŸ©ãã æ°ããé¢æ°ãå®çŸ©ãã æ°ããã€ã³ããã¯ã¹ãå®çŸ©ãã å€éšãµãŒãã«å¯ŸããŠãŠãŒã¶ã®æ°ãããããã³ã°ãå®çŸ©ãã æ°ããæŒç®åãå®çŸ©ãã æ°ããæŒç®åã¯ã©ã¹ãå®çŸ©ãã æ°ããæŒç®åãã¡ããªãå®çŸ©ãã æ°ããæç¶ãèšèªãå®çŸ©ãã æ°ããæžãæãã«ãŒã«ãå®çŸ©ãã çŸåšã®ãã©ã³ã¶ã¯ã·ã§ã³ã«å¯ŸããŠæ°ããã»ãŒããã€ã³ããå®çŸ©ãã æ°ããã¹ããŒããå®çŸ©ãã æ°ããã·ãŒã±ã³ã¹çºçåšãå®çŸ©ãã æ°ããããŒãã«ãå®çŸ©ãã ã¯ãšãªãŒã®çµæããæ°ããããŒãã«ãçæãã æ°ããããŒãã«ã¹ããŒã¹ãå®çŸ©ãã æ°ããããã¹ãæ€çŽ¢èšå®ãå®çŸ©ãã æ°ããããã¹ãæ€çŽ¢çšèŸæžãå®çŸ©ãã æ°ããããã¹ãæ€çŽ¢çšããŒãµãå®çŸ©ãã æ°ããããã¹ãæ€çŽ¢ãã³ãã¬ãŒããå®çŸ©ãã æ°ããããªã¬ãå®çŸ©ãã æ°ãããã¥ãŒãå®çŸ©ãã ã¢ã¯ã»ã¹æš©éãå®çŸ©ãã ãªããžã§ã¯ãã®ã³ã¡ã³ããå®çŸ©ãŸãã¯å€æŽãã ããŒãã«ã®è¡ãåé€ãã ååå®çŸ©ããã»ãŒããã€ã³ããåé€ãã ã»ãã·ã§ã³ã®ç¶æ
ãç Žæ£ãã ããŒãã«ãããã¯ããŒãã«ã®ã»ããã 0 件ã«åãè©°ãã æºåæžã¿ã¹ããŒãã¡ã³ããå®è¡ãã ããŒãã« "%s.%s" çš ãã©ã³ã¶ã¯ã·ã§ã³ãã°ã®ãã§ãã¯ãã€ã³ãã匷å¶èšå®ãã é¢æ° ã¬ãŒããžã³ã¬ã¯ã·ã§ã³ãè¡ãããªãã·ã§ã³ã§ããŒã¿ããŒã¹ã®åæãããŸã éç¥ã¡ãã»ãŒãžãçæãã ãã®ç°å¢ã§ã¯ãã¹ããªæ©èœããµããŒãããŠããŸããã
äžå€ 代å
¥ ã€ã³ããã¯ã¹ "%s" ã¯æå¹ãªãã€ããªãã¡ã€ã«ã§ã¯ãããŸããã \%sïŒäžæ£ãªã³ãã³ãã§ãã
åºåãã©ãŒããããç¡å¹ïŒå
éšãšã©ãŒïŒïŒ%d éç¥ã¡ãã»ãŒãžãç£èŠãã å
±æã©ã€ãã©ãªãã¡ã€ã«ãïŒåïŒããŒããã ããŒã«ã«ãœã±ãã ããŒãã«ãããã¯ãã no ã¯ãšãªãŒãããã¡ããããŸããã
normalïŒéåžžïŒ not null ãªã ãªã³ æŒç®å ã¡ã¢ãªäžè¶³ã§ã ã¡ã¢ãªäžè¶³ã§ã
ã«ãŒãœã«ãäœçœ®ä»ãã å®è¡ã«å
ç«ã£ãŠã¹ããŒãã¡ã³ããæºåãã ïŒãã§ãŒãºã³ãããçšã«çŸåšã®ãã©ã³ã¶ã¯ã·ã§ã³ãæºåãã ãã©ã€ããªããŒ, psql 㯠PostgreSQL ã®äŒè©±åã¿ãŒããã«ã§ãã
ã€ã³ããã¯ã¹ãåæ§ç¯ãã ãã£ã¹ããåé€ãã ãšã³ã³ãŒãã£ã³ã°å€æã«ãŒã«ãåé€ãã ããŒã¿åãåé€ãã ããŒã¿ããŒã¹ãåé€ãã ããŒã¿ããŒã¹ã®ããŒã«ãåé€ãã ãã¡ã€ã³ãåé€ãã å€éšãµãŒãèå¥åãåé€ãã å€éšããŒã¿ã©ãããŒãåé€ãã é¢æ°ãåé€ãã æç¶ãèšèªãåé€ãã æžãæãã«ãŒã«ãåé€ãã ã¹ããŒããåé€ãã ã·ãŒã±ã³ã¹ãåé€ãã ããŒãã«ãåé€ãã ããŒãã«ã¹ããŒã¹ãåé€ãã ããã¹ãæ€çŽ¢èšå®ãåé€ãã ããã¹ãæ€çŽ¢çšèŸæžãåé€ãã ããã¹ãæ€çŽ¢çšããŒãµãåé€ãã ããã¹ãæ€çŽ¢çšãã³ãã¬ãŒããåé€ãã ããªã¬ãåé€ãã å€éšãµãŒããŒã®ãŠãŒã¶å®çŸ©ãããã³ã°ãåé€ ãã¥ãŒãåé€ãã ã¢ã¯ã»ã¹æš©éãå¥å¥ªãã éçŽé¢æ°ãåé€ãã ã€ã³ããã¯ã¹ãåé€ãã æŒç®åãåé€ãã æŒç®åã¯ã©ã¹ãåé€ãã æŒç®åãã¡ããªãåé€ãã ç¹å®ã®ããŒã¿ããŒã¹ããŒã«ãææããããŒã¿ããŒã¹ãªããžã§ã¯ããåé€ãã å®è¡æãã©ã¡ãŒã¿ã®å€ãããã©ã«ãå€ã«æ»ã ã«ãŒãœã«ã䜿ã£ãŠã¯ãšãªãŒããè¡ãåãåºã ããŒãã«ãããã¯ãã¥ãŒããè¡ãåãåºã ã»ãŒããã€ã³ããŸã§ããŒã«ããã¯ãã ã«ãŒã« ã·ãŒã±ã³ã¹ çŸåšã®ãã©ã³ã¶ã¯ã·ã§ã³ã«å¯ŸããŠå¶çŽã¢ãŒããèšå®ãã çŸåšã®ãã©ã³ã¶ã¯ã·ã§ã³ã®ç¹æ§ãèšå®ããŸã çŸåšã®ã»ãã·ã§ã³ã«ãããçŸåšã®ãŠãŒã¶èå¥ãèšå®ãã ã»ãã·ã§ã³ã®ãŠãŒã¶èå¥ãããã³çŸåšã®ã»ãã·ã§ã³ã«ãããçŸåšã®ãŠãŒã¶èå¥ãèšå®ãã ã¹ããŒãã¡ã³ãã®å®è¡ãã©ã³ã衚瀺ãã å®è¡æãã©ã¡ãŒã¿ã®å€ã衚瀺ãã ç¹æ® å®å® ãã©ã³ã¶ã¯ã·ã§ã³ãããã¯ãéå§ãã éç¥ã¡ãã»ãŒãžã®ç£èŠãäžæ¢ãã ããŒãã« triggerïŒããªã¬ïŒ ãŠããŒã¯, ããŒãã«ã®è¡ãæŽæ°ãã ãã¥ãŒ æ®çºæ§ windowïŒãŠã£ã³ããŠïŒ yes