•ÞÆL_|%ø%ùÒ&&á&ü' '+')7'UC'A'ÑE(9(YD(“I(ØG)"O)j5)ºC)ð6*4,*kD*˜F*Ý.+$7+SK+‹5+×B, 7,P7,ˆ>,À7,ÿ2-71-j=-œE-Ú3. 8.TC.B.ÑY/6/nF/¥>/ì:0+0f0ƒ;0¢*0Þ"1 )1,:1V61‘1È 1ç.227w2TF2Ì13D3EH3ŠL3ÓD4 ,4e>4’N4Ñ95 75ZÅ5’6XP6t06Å46ö[7+/7‡:7·27ò,8%78R<8Š(8Ç 8ð8þ99 29$9E#9j 9Ž)9¯#9Ù<9ý :::[:n6:Ž<:Å ;; ; ;;+¥;? ;å;ò/<'‹>>%>Ê>>ð#?/¾?S¹@-CÌQCú3ELE€#E’E¶IEÊ FFF0FM Fb Fm8FxîF±H ¦H¾«JeÐK‹KâªLn¶MoMÐN@]OHŽP¦šQ5µQÐS†nTŽ‘UýDVÒVÔbW§†X fX‘k\øW]d]¼]Ï,]Ö^^ ^.£^O.^ó3_";_V+_’_¾0_Ñ>``A.`QB`€P`Ã1a/aF1av.a¨1a×-b b7-bF8bt b­b·bÎbä bí bù&c'c,cT*co)cšcÄecÍd3dMdfezeƒe e¶eÂneËi:iCuiT iÊ iÔiâiëiú j j&j jFjRÓjbk6 k? kMk[ kwk…k™k¬kÃkÕkåk÷l l+l+lW l` ljlvOl{lËlélþmmm0mF6mLmƒm™m¸ mÌm× mñmÿn3n4nhn}r‘r±rÌrë rüsssìs$‚u?x”äxÔˆy¹†zBzÉ'zÜb{{g{n{{”{™ {  {¬{¸ {Ñ{Ý{ñ| |||7 |P9|\7|–|Î|Ý |ì|ú} }&}%}L}`}eq}{}í}ô~ ~ ~~) ~©~¶$~Êþ~ïî/€ (€;5€d(€š €Ã,€Ï €ü!* J Wa|"˜ »;Ü‚‚3 ‚Q,‚[‚ˆ‚š‚¹‚Õ%‚é!ƒ#ƒ1.ƒU ƒ„"ƒ¥.ƒÈ*ƒ÷„"%„1#„W„{„š)„¹$„ã$…!…-'…O(…w… …¹…Ö.…솆+ †F†P†p†€† †²†Ò†ê"‡‡$‡8‡N‡a‡w ‡“‡´‡Î‡âˆˆˆ*ˆBˆT)ˆmˆ— ˆ®ˆ¼ˆÙ"ˆë‰1‰‰I ‰a‰o‰u‰Š$‰¤ ‰É ‰Ö‰ã‰æ‰÷‰û‰þŠŠŠ6!ŠH ŠjŠx ŠˆŠ–ŠªŠ½ŠÏŠîŠþ‹‹-‹C‹S‹e‹t‹… ‹™‹§‹À‹Ý‹íŒ>Œ)ŒX"Œ‚Œ¥Œª2Œ³2ŒæV&p&—¾Æ!à ŽŽ Ž'Ž-Ž5Ž>ŽUŽZKŽ^ªÜÁž½Ý æ2ò>‘%-‘dD‘’g‘×T’?M’”n’âG“Qn“™M”I”V?” 2”àC•L•W8•¤?•Ýf–5–„F–ºH—M—JN—˜=—ç6˜%:˜\K˜—q˜ãC™U?™™M™ÙFš'mšn3šÜJ›G›[=›£6›á"œ?œ;1œ{&œ­0œÔ;@A"‚$¥8Ê"žž&Mž´4ŸXŸ7jŸmŸûi i2 ÓJ¡W¡QF¡©=¡ð×¢. £A£';£iG£¥}£í6¤k]¤¢8¥7¥9:¥qK¥¬.¥ø¦'¦8¦@¦C2¦K1¦~+¦°*¦Ü9§'§AQ§i*§»§æ&§üB¨#?¨f ¨¦¨± ¨º¨Ç¨Ù¥¨î ©”©¡/©¾'©î‹ªª¢:«²‹«í%¬y>¬Ÿ#¬Þ¾­¹­Á-±{Q±©3²û ³/#³;³_I³| ³Æ³Ð³ã´ ´ ´&8´1î´j¶Y¦¶w«¸иʋ¹›ªº'¶ºÒo»‰»ù]½Ž¾_š¾îµ¿‰Á?nÂG‘öDÄHÒÄbÅ`†ÅÃfÆJkʱWËËuËŠ-Ë’ËÀË× Ëî£Ì.̳3Ìâ;Í+ÍRÍ~0Í‘>ÍÂÎ.ÎBÎ@P΃1ÎÔ/Ï1Ï6.Ïh1Ï—-ÏÉÏ÷-Ð8Ð4 Ðm.ÐzЩ ÐÉ ÐÖÐâ&Ðê$ÑÑ6*ÑQ)Ñ| Ѧbѳ+Ò(ÒBÒkÓ Ó‡Ó¨ÓÈÓÑnÓÙ×H×Qu×e ×Û×æ×õ×þØ ØØ$2Ø3 ØfØrÓØ‚ÙVÙ_ Ùo"Ù|'ÙŸÙÇÙß'ÙøÚ Ú9ÚMÚbÚxÚŽ+Ú¡ ÚÍ ÚÙ ÚçÚópÚú+ÛkÛ—Û¶ÛÔÛÛÛôÜ6ÜÜN(ÜmÜ– Ü°%ܽÜã Üö3Ý3ÝKÝÝ”á¨áÈ*áèââ* â9âFâMìâU…äB?çÈäèˆèí†évéý%êbê6ê™ê ê²êÈêÏ êÖ êäêð ë ëë*ëB ëH!ëV-ëx ë¦=ë³8ëñì*!ì=ì_ì~ì’ ì±.ì»$ìêííqí*íœí¬ íÈíÖíèíü î|îŠ'î¢8îÊ&ð'ð*+ðRBð~.ðÁ ðð.ðû ñ*#ñ6ñZ ñz ñ‡ñ‘&ñ¯3ñÖ!ò ?ò,òlò‹òª/òÀòð0ó $ó:ó_&ó{"ó¢#óÅ.óé!ô"ô:1ô]/ôô¿&ôÐ.ô÷"õ&&õI1õp(õ¢8õË,ö0ö10öb ö“'ö´öÜ:öù÷4÷H ÷g÷t÷”&÷«#÷Ò&÷ö+øøI"øgøŠø¢ø»øÒ$øë#ù%ù4ùZ$ùqù–ù­!ùÅùçùþ-úúIúdútú”2ú¥úØEúàû& û>ûLûSûj3û ûµûÂûÔû× ûñûýüü*ü üK$üaü†ü—ü«&üÊüñý ý$ýBýUýi ýˆý©ý»ýÛýíþþþ/!þLþnþ€þ”Cþ´/þø&ÿ(ÿO ÿU5ÿ_>ÿ•iÿÔ->1lž§!Ç é!ö&.KQR©\8¨s­š{ÚÒÞ„2,^Yį…c÷ƒ%ÆÁÑ®ð µÆ½Ö¬hùÌ­ ž]Ë<zúuZ€†X0d¡¾fÔUbª_!yš+/#… +߸7)àÕ¦†3:°z¶±Ð‘j ñ‡{ˆkhk¿4?áaI³™’r`S2Ê'oj;ØÁN:]Jl|¾O¹w¼¦D»üWnCM²`m>x¸ï«BA‚B Å·)Å»n4¹o Z([‹Û›åF "UÄ5t™\K(¥´“í¤crÓlÉ6°GQy9‚´_v"u¢ ³ë¢øêg Ü*‘L¡öºe^éA¬XH*MÝÍ;ÿIî–˜©ƒÇ1H¨¥ ŽC®‰ó6Ã~9µ‰õ£ôq ŸŒ.•PžPQ7—3ˆqO§sW/ìvL&·¤¿Gþ'E•èm5eŠp%’>±?â-pt}‡„œ}ò² ” VVSwæÏ1›¼Ÿ€K¯NÂRÙDä#b@8½ã—ix×~=T«Ff$@[ÃÀªºûŽ Y,–˜ŒÈ§T‹E“.!g”=$0Àd¶œç-&£|iJ<ýΊa 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. Report bugs to . Input and output options: Output format options: "%s" "%s" %s --help show this help, then exit --version output version information, then exit -A unaligned table output mode (-P format=unaligned) -E display queries that internal commands generate -F STRING set field separator (default: "%s") (-P fieldsep=) -H HTML table output mode (-P format=html) -P VAR[=ARG] set printing option VAR to ARG (see \pset command) -R STRING set record separator (default: newline) (-P recordsep=) -S single-line mode (end of line terminates SQL command) -T TEXT set HTML table tag attributes (width, border) (-P tableattr=) -U NAME database user name (default: "%s") -W prompt for password (should happen automatically) -X do not read startup file (~/.psqlrc) -a echo all input from script -c COMMAND run only single command (SQL or internal) and exit -d DBNAME specify database name to connect to (default: "%s") -e echo commands sent to server -f FILENAME execute commands from file, then exit -h HOSTNAME database server host or socket directory (default: "%s") -l list available databases, then exit -n disable enhanced command line editing (readline) -o FILENAME send query results to file (or |pipe) -p PORT database server port (default: "%s") -q run quietly (no messages, only query output) -s single-step mode (confirm each query) -t print rows only (-P tuples_only) -v NAME=VALUE set psql variable NAME to VALUE -x turn on expanded table output (-P expanded) \! [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]] 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 \d [NAME] describe table, index, sequence, or view \dC list casts \dD [PATTERN] list domains \dT [PATTERN] list data types (add "+" for more detail) \da [PATTERN] list aggregate functions \dc [PATTERN] list conversions \dd [PATTERN] show comment for object \df [PATTERN] list functions (add "+" for more detail) \dl list large objects, same as \lo_list \dn [PATTERN] list schemas \do [NAME] list operators \dp [PATTERN] list table access privileges \du [PATTERN] list users \d{t|i|s|v|S} [PATTERN] (add "+" for more detail) list tables/indexes/sequences/views/system tables \e [FILE] edit the query buffer (or file) with external editor \echo [STRING] write string to standard output \encoding [ENCODING] show or set client encoding \f [STRING] show or set field separator for unaligned query output \g [FILE] send query buffer to server (and 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 (add "+" for more detail) \lo_export \lo_import \lo_list \lo_unlink large object operations \o [FILE] send all query results to file or |pipe \p show the contents of the query buffer \pset NAME [VALUE] set table output option (NAME := {format|border|expanded|fieldsep|footer|null| 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 show only rows (currently %s) \timing toggle timing of commands (currently %s) \unset NAME unset (delete) internal variable \w [FILE] write query buffer to file \x toggle expanded output (currently %s) \z [PATTERN] list table access privileges (same as \dp) psql [OPTIONS]... [DBNAME [USERNAME]] primary key, unique,%s%s: %s %s: Warning: The -u option is deprecated. Use -U. %s: cannot copy from/to a directory %s: could not delete variable "%s" %s: could not set variable "%s" %s: couldn't set printing parameter "%s" %s: current transaction is aborted %s: invalid encoding name or conversion procedure not found %s: not connected to a database %s: out of memory %s: unknown transaction status %s: warning: extra command-line argument "%s" ignored %s: xstrdup: cannot duplicate null pointer (internal error) (%d rows)(1 row)(No rows) (all types)(binary compatible)***(Single step mode: verify command)******************************************* %s ***(press return to proceed or enter x and return to cancel)******************** ?%c? "%s.%s"ABORT [ WORK | TRANSACTION ]ALTER AGGREGATE name ( type ) RENAME TO newnameALTER CONVERSION name RENAME TO newnameALTER DATABASE name SET parameter { TO | = } { value | DEFAULT } ALTER DATABASE name RESET parameter ALTER DATABASE name RENAME TO newnameALTER 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_ownerALTER FUNCTION name ( [ type [, ...] ] ) RENAME TO newnameALTER GROUP groupname ADD USER username [, ... ] ALTER GROUP groupname DROP USER username [, ... ] ALTER GROUP groupname RENAME TO newnameALTER LANGUAGE name RENAME TO newnameALTER OPERATOR CLASS name USING index_method RENAME TO newnameALTER SCHEMA name RENAME TO newnameALTER SEQUENCE name [ INCREMENT [ BY ] increment ] [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ] [ RESTART [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]ALTER TABLE [ ONLY ] name [ * ] ADD [ COLUMN ] column type [ column_constraint [ ... ] ] ALTER TABLE [ ONLY ] name [ * ] DROP [ COLUMN ] column [ RESTRICT | CASCADE ] ALTER TABLE [ ONLY ] name [ * ] ALTER [ COLUMN ] column { SET DEFAULT expression | DROP DEFAULT } ALTER TABLE [ ONLY ] name [ * ] ALTER [ COLUMN ] column { SET | DROP } NOT NULL ALTER TABLE [ ONLY ] name [ * ] ALTER [ COLUMN ] column SET STATISTICS integer ALTER TABLE [ ONLY ] name [ * ] ALTER [ COLUMN ] column SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN } ALTER TABLE [ ONLY ] name [ * ] SET WITHOUT OIDS ALTER TABLE [ ONLY ] name [ * ] RENAME [ COLUMN ] column TO new_column ALTER TABLE name RENAME TO new_name ALTER TABLE [ ONLY ] name [ * ] ADD table_constraint ALTER TABLE [ ONLY ] name [ * ] DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ] ALTER TABLE name OWNER TO new_owner ALTER TABLE name CLUSTER ON index_nameALTER TRIGGER name ON table RENAME TO newnameALTER USER name [ [ WITH ] option [ ... ] ] where option can be: [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' | CREATEDB | NOCREATEDB | CREATEUSER | NOCREATEUSER | VALID UNTIL 'abstime' ALTER USER name RENAME TO newname ALTER USER name SET parameter { TO | = } { value | DEFAULT } ALTER USER name RESET parameterANALYZE [ VERBOSE ] [ table [ (column [, ...] ) ] ]Access privilegesAccess privileges for database "%s"Argument data typesAsynchronous notification "%s" received from server process with PID %d. AttributesAvailable help: BEGIN [ WORK | TRANSACTION ]Border style is %d. CHECKPOINTCLOSE nameCLUSTER indexname ON tablename CLUSTER tablename CLUSTERCOMMENT ON { TABLE object_name | COLUMN table_name.column_name | AGGREGATE agg_name (agg_type) | CONSTRAINT constraint_name ON table_name | DATABASE object_name | DOMAIN object_name | FUNCTION func_name (arg1_type, arg2_type, ...) | INDEX object_name | OPERATOR op (leftoperand_type, rightoperand_type) | RULE rule_name ON table_name | SCHEMA object_name | SEQUENCE object_name | TRIGGER trigger_name ON table_name | TYPE object_name | VIEW object_name } IS 'text'COMMIT [ WORK | TRANSACTION ]COPY tablename [ ( column [, ...] ) ] FROM { 'filename' | STDIN } [ [ WITH ] [ BINARY ] [ OIDS ] [ DELIMITER [ AS ] 'delimiter' ] [ NULL [ AS ] 'null string' ] ] COPY tablename [ ( column [, ...] ) ] TO { 'filename' | STDOUT } [ [ WITH ] [ BINARY ] [ OIDS ] [ DELIMITER [ AS ] 'delimiter' ] [ NULL [ AS ] 'null string' ] ]CREATE AGGREGATE name ( BASETYPE = input_data_type, SFUNC = sfunc, STYPE = state_data_type [ , FINALFUNC = ffunc ] [ , INITCOND = initial_condition ] )CREATE CAST (sourcetype AS targettype) WITH FUNCTION funcname (argtype) [ AS ASSIGNMENT | AS IMPLICIT ] CREATE CAST (sourcetype AS targettype) WITHOUT FUNCTION [ AS ASSIGNMENT | AS IMPLICIT ]CREATE CONSTRAINT TRIGGER name AFTER events ON tablename constraint attributes FOR EACH ROW EXECUTE PROCEDURE funcname ( args )CREATE DATABASE name [ [ WITH ] [ OWNER [=] dbowner ] [ LOCATION [=] 'dbpath' ] [ TEMPLATE [=] template ] [ ENCODING [=] encoding ] ]CREATE DOMAIN name [AS] data_type [ DEFAULT expression ] [ constraint [ ... ] ] where constraint is: [ CONSTRAINT constraint_name ] { NOT NULL | NULL | CHECK (expression) }CREATE GROUP name [ [ WITH ] option [ ... ] ] where option can be: SYSID gid | USER username [, ...]CREATE OPERATOR CLASS name [ DEFAULT ] FOR TYPE data_type USING index_method AS { OPERATOR strategy_number operator_name [ ( op_type, op_type ) ] [ RECHECK ] | FUNCTION support_number funcname ( argument_type [, ...] ) | STORAGE storage_type } [, ... ]CREATE OPERATOR name ( PROCEDURE = funcname [, LEFTARG = lefttype ] [, RIGHTARG = righttype ] [, COMMUTATOR = com_op ] [, NEGATOR = neg_op ] [, RESTRICT = res_proc ] [, JOIN = join_proc ] [, HASHES ] [, MERGES ] [, SORT1 = left_sort_op ] [, SORT2 = right_sort_op ] [, LTCMP = less_than_op ] [, GTCMP = greater_than_op ] )CREATE SCHEMA schemaname [ AUTHORIZATION username ] [ schema_element [ ... ] ] CREATE SCHEMA AUTHORIZATION username [ schema_element [ ... ] ]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 ( INPUT = input_function, OUTPUT = output_function [ , RECEIVE = receive_function ] [ , SEND = send_function ] [ , INTERNALLENGTH = { internallength | VARIABLE } ] [ , PASSEDBYVALUE ] [ , ALIGNMENT = alignment ] [ , STORAGE = storage ] [ , DEFAULT = default ] [ , ELEMENT = element ] [ , DELIMITER = delimiter ] )CREATE USER name [ [ WITH ] option [ ... ] ] where option can be: SYSID uid | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' | CREATEDB | NOCREATEDB | CREATEUSER | NOCREATEUSER | IN GROUP groupname [, ...] | VALID UNTIL 'abstime'CREATE [ OR REPLACE ] FUNCTION name ( [ argtype [, ...] ] ) RETURNS rettype { LANGUAGE langname | IMMUTABLE | STABLE | VOLATILE | CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT | [EXTERNAL] SECURITY INVOKER | [EXTERNAL] SECURITY DEFINER | AS 'definition' | AS 'obj_file', 'link_symbol' } ... [ WITH ( attribute [, ...] ) ]CREATE [ OR REPLACE ] RULE name AS ON event TO table [ WHERE condition ] DO [ INSTEAD ] { NOTHING | command | ( command ; command ... ) }CREATE [ OR REPLACE ] VIEW name [ ( column_name [, ...] ) ] AS queryCREATE [ TEMPORARY | TEMP ] SEQUENCE name [ INCREMENT [ BY ] increment ] [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ] [ START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]CREATE [ TRUSTED ] [ PROCEDURAL ] LANGUAGE name HANDLER call_handler [ VALIDATOR valfunction ]CREATE [ UNIQUE ] INDEX name ON table [ USING method ] ( { column | ( expression ) } [ opclass ] [, ...] ) [ WHERE predicate ]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 ] } [, ... ] ) [ INHERITS ( parent_table [, ... ] ) ] [ WITH OIDS | WITHOUT OIDS ] [ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ] where column_constraint is: [ CONSTRAINT constraint_name ] { NOT NULL | NULL | UNIQUE | PRIMARY KEY | 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 [, ... ] ) | PRIMARY KEY ( column_name [, ... ] ) | 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 ]CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name [ (column_name [, ...] ) ] AS queryCREATE [DEFAULT] CONVERSION name FOR source_encoding TO dest_encoding FROM funcnameCheck constraints:ColumnCommand: %s Description: %s Syntax: %s Composite type "%s.%s"Copy, Large Object DEALLOCATE [ PREPARE ] plan_nameDECLARE name [ BINARY ] [ INSENSITIVE ] [ [ NO ] SCROLL ] CURSOR [ { WITH | WITHOUT } HOLD ] FOR query [ FOR { READ ONLY | UPDATE [ OF column [, ...] ] } ]DELETE FROM [ ONLY ] table [ WHERE condition ]DROP AGGREGATE name ( type ) [ CASCADE | RESTRICT ]DROP CAST (sourcetype AS targettype) [ CASCADE | RESTRICT ]DROP CONVERSION name [ CASCADE | RESTRICT ]DROP DATABASE nameDROP DOMAIN name [, ...] [ CASCADE | RESTRICT ]DROP FUNCTION name ( [ type [, ...] ] ) [ CASCADE | RESTRICT ]DROP GROUP nameDROP INDEX name [, ...] [ CASCADE | RESTRICT ]DROP OPERATOR CLASS name USING index_method [ CASCADE | RESTRICT ]DROP OPERATOR name ( lefttype | NONE , righttype | NONE ) [ CASCADE | RESTRICT ]DROP RULE name ON relation [ CASCADE | RESTRICT ]DROP SCHEMA name [, ...] [ CASCADE | RESTRICT ]DROP SEQUENCE name [, ...] [ CASCADE | RESTRICT ]DROP TABLE name [, ...] [ CASCADE | RESTRICT ]DROP TRIGGER name ON table [ CASCADE | RESTRICT ]DROP TYPE name [, ...] [ CASCADE | RESTRICT ]DROP USER nameDROP VIEW name [, ...] [ CASCADE | RESTRICT ]DROP [ PROCEDURAL ] LANGUAGE name [ CASCADE | RESTRICT ]Data typeDefault footer is off.Default footer is on.Default?DescriptionDestinationDid not find any relation named "%s". Did not find any relation with OID %s. END [ WORK | TRANSACTION ]EXECUTE plan_name [ (parameter [, ...] ) ]EXPLAIN [ ANALYZE ] [ VERBOSE ] statementEncodingEnter data to be copied followed by a newline. End with a backslash and a period on a line by itself.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 ALLFailed. Field separator is "%s". Foreign-key constraints:Formatting FunctionGRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,...] | ALL [ PRIVILEGES ] } ON [ TABLE ] tablename [, ...] TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH GRANT OPTION ] GRANT { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] } ON DATABASE dbname [, ...] TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH GRANT OPTION ] GRANT { EXECUTE | ALL [ PRIVILEGES ] } ON FUNCTION funcname ([type, ...]) [, ...] TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH GRANT OPTION ] GRANT { USAGE | ALL [ PRIVILEGES ] } ON LANGUAGE langname [, ...] TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH GRANT OPTION ] GRANT { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] } ON SCHEMA schemaname [, ...] TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH GRANT OPTION ]General General options:INSERT INTO table [ ( column [, ...] ) ] { DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) | query }Implicit?Index "%s.%s"Indexes:Informational InheritsInput/Output Internal nameInvalid command \%s. Try \? for help. LISTEN nameLOAD 'filename'LOCK [ TABLE ] name [, ...] [ IN lockmode MODE ] where lockmode is one of: ACCESS SHARE | ROW SHARE | ROW EXCLUSIVE | SHARE UPDATE EXCLUSIVE | SHARE | SHARE ROW EXCLUSIVE | EXCLUSIVE | ACCESS EXCLUSIVELanguageLarge objectsLeft arg typeList of aggregate functionsList of castsList of conversionsList of data typesList of database usersList of databasesList of domainsList of functionsList of operatorsList of relationsList of schemasMOVE [ direction { FROM | IN } ] cursornameModifierModifiersNOTIFY nameNameNo help available for "%-.*s". Try \h with no arguments to see available help. No matching relations found. No relations found. Null display is "%s". ObjectObject descriptionsOutput format is %s. OwnerPREPARE plan_name [ (datatype [, ...] ) ] AS statementPager is always used.Pager is used for long output.Pager usage is off.Password: Previous connection kept Query Buffer Query buffer is empty.Query buffer reset (cleared).REINDEX { DATABASE | TABLE | INDEX } name [ FORCE ]RESET name RESET ALLREVOKE [ GRANT OPTION FOR ] { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,...] | ALL [ PRIVILEGES ] } ON [ TABLE ] tablename [, ...] FROM { username | GROUP groupname | PUBLIC } [, ...] [ CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FOR ] { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] } ON DATABASE dbname [, ...] FROM { username | GROUP groupname | PUBLIC } [, ...] [ CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FOR ] { EXECUTE | ALL [ PRIVILEGES ] } ON FUNCTION funcname ([type, ...]) [, ...] FROM { username | GROUP groupname | PUBLIC } [, ...] [ CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FOR ] { USAGE | ALL [ PRIVILEGES ] } ON LANGUAGE langname [, ...] FROM { username | GROUP groupname | PUBLIC } [, ...] [ CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FOR ] { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] } ON SCHEMA schemaname [, ...] FROM { username | GROUP groupname | PUBLIC } [, ...] [ CASCADE | RESTRICT ]ROLLBACK [ WORK | TRANSACTION ]Record separator is "%s". Record separator is .Result data typeResult typeRight arg typeRulesRules: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 [, ...] ] [ { UNION | INTERSECT | EXCEPT } [ ALL ] select ] [ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ] [ LIMIT { count | ALL } ] [ OFFSET start ] [ FOR UPDATE [ OF tablename [, ...] ] ]SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ] * | expression [ AS output_name ] [, ...] [ FROM from_item [, ...] ] [ WHERE condition ] [ GROUP BY expression [, ...] ] [ HAVING condition [, ...] ] [ { UNION | INTERSECT | EXCEPT } [ ALL ] select ] [ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ] [ LIMIT { count | ALL } ] [ OFFSET start ] [ FOR UPDATE [ OF table_name [, ...] ] ] where from_item can be one of: [ ONLY ] table_name [ * ] [ [ AS ] alias [ ( column_alias [, ...] ) ] ] ( select ) [ 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 [, ...] ) ]SET CONSTRAINTS { ALL | name [, ...] } { DEFERRED | IMMEDIATE }SET TRANSACTION [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ] [ READ WRITE | READ ONLY ] SET SESSION CHARACTERISTICS AS TRANSACTION [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ] [ READ WRITE | READ ONLY ]SET [ SESSION | LOCAL ] SESSION AUTHORIZATION username SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT RESET SESSION AUTHORIZATIONSET [ SESSION | LOCAL ] name { TO | = } { value | 'value' | DEFAULT } SET [ SESSION | LOCAL ] TIME ZONE { timezone | LOCAL | DEFAULT }SHOW name SHOW ALLSSL connection (cipher: %s, bits: %i) START TRANSACTION [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ] [ READ WRITE | READ ONLY ]SchemaSequence "%s.%s"Showing only tuples.SizeSourceSource codeSource typeSpecial relation "%s.%s"Succeeded. TOAST table "%s.%s"TRUNCATE [ TABLE ] nameTableTable "%s.%s"Table attribute is "%s". Table attributes unset. Target typeThe connection to the server was lost. Attempting reset: This is psql %s, the PostgreSQL interactive terminal. Time: %.3f ms Timing is off.Timing is on.Title is "%s". Title is unset. Triggers:Try "%s --help" for more information. Tuples only is off.TypeUNLISTEN { name | * }UPDATE [ ONLY ] table SET column = { expression | DEFAULT } [, ...] [ FROM fromlist ] [ WHERE condition ]Usage:Use "\q" to leave %s. User IDUser nameUser name: VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ table ] VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ table [ (column [, ...] ) ] ]View "%s.%s"View definition: %sWarning: This syntax is deprecated. Welcome to %s %s, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit Wrote history to file "%s". You are currently not connected to a database. You are now connected as new user "%s". You are now connected to database "%s" as user "%s". You are now connected to database "%s". \!: 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) \pset: allowed formats are unaligned, aligned, html, latex \pset: unknown option: %s abort the current transactionaggregatealter the definition of a sequence generatorchange a databasechange a database user accountchange a run-time parameterchange a user groupchange the definition of a conversionchange the definition of a domainchange the definition of a functionchange the definition of a procedural languagechange the definition of a tablechange the definition of a triggerchange the definition of an aggregate functionchange the definition of an operator classclose a cursorcluster a table according to an indexcollect statistics about a databasecommit the current transactionconnection to server was lost contains support for command-line editingcopy data between a file and a tablecould not get current user name: %s could not get home directory: %s could not open temporary file "%s": %s could not save history to file "%s": %s could not start /bin/sh could not start editor "%s" create a new databasecreate a new table from the results of a querycreate databasecreate new rows in a tabledata typedeallocate a prepared statementdefine a cursordefine a new aggregate functiondefine a new castdefine a new constraint triggerdefine a new conversiondefine a new data typedefine a new database user accountdefine a new domaindefine a new functiondefine a new indexdefine a new operatordefine a new operator classdefine a new procedural languagedefine a new rewrite ruledefine a new schemadefine a new sequence generatordefine a new tabledefine a new triggerdefine a new user groupdefine a new viewdefine access privilegesdefine or change the comment of an objectdelete rows of a tableempty a tableexecute a prepared statementfor table "%s.%s"force a transaction log checkpointfunctiongarbage-collect and optionally analyze a databasegenerate a notificationin assignmentindexinvalid command \%s listen for a notificationload or reload a shared library filelocal socketlock a tablenono query buffer offonoperatorout of memory parse error at the end of line position a cursorprepare a statement for executionprimary key, rebuild indexesremove a castremove a conversionremove a data typeremove a databaseremove a database user accountremove a domainremove a functionremove a procedural languageremove a rewrite ruleremove a schemaremove a sequenceremove a tableremove a triggerremove a user groupremove a viewremove access privilegesremove an aggregate functionremove an indexremove an operatorremove an operator classrestore the value of a run-time parameter to the default valueretrieve rows from a query using a cursorretrieve rows from a table or viewrulesequenceset the characteristics of the current transactionset the constraint mode of the current transactionset the session user identifier and the current user identifier of the current sessionshow the execution plan of a statementshow the value of a run-time parameterspecialstart a transaction blockstop listening for a notificationsuperusersuperuser, create databasetabletriggerunique, update rows of a tableviewyesProject-Id-Version: PostgreSQL 7.4 POT-Creation-Date: 2003-11-15 21:21+0100 PO-Revision-Date: 2003-11-15 21:32+0100 Last-Translator: Álvaro Herrera Language-Team: Castellano MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Opciones de conexión: Para obtener más ayuda, digite "\?" (para comandos internos) o "\help" (para comandos SQL) dentro de psql, o consulte la sección de psql en la documentación de PostgreSQL. Reporte errores a . Opciones de entrada y salida: Opciones de formato de salida: "%s" "%s" %s --help mostrar esta ayuda, luego salir --version mostrar información de versión, luego salir -A modo de salida desalineado -E mostrar consultas generadas por comandos internos -F CADENA definir separador de columnas (por omisión: "%s") (-P fieldsep=) -H modo de salida en tablas HTML (-P format=html) -P VAR[=ARG] definir opción de impresión VAR en ARG (ver comando \pset) -R CADENA definir separador de filas (por omisión: salto de línea) (-P recordsep=) -S modo de líneas (fin de línea termina el comando SQL) -T TEXTO definir atributos de marcas de tabla HTML (ancho, borde) (-P tableattr=) -U NOMBRE nombre de usuario de la base de datos (por omisión: "%s") -W preguntar contraseña (debería suceder automáticamente) -X no leer archivo de configuración (~/.psqlrc) -a mostrar los comandos del script -c COMANDO ejecutar sólo un comando (SQL o interno) y salir -d BASE-DE-DATOS nombre de base de datos a conectarse (por omisión: "%s") -e mostrar comandos enviados al servidor -f ARCHIVO ejecutar comandos desde archivo, luego salir -h ANFITRIÓN nombre del anfitrión o directorio de socket (por omisión: "%s") -l listar bases de datos, luego salir -n deshabilitar edición de línea de comando (readline) -o ARCHIVO enviar resultados de consultas a archivo (o |comando) -p PORT puerto del servidor de bases de datos (por omisión: "%s") -q modo silencioso (sin mensajes, sólo resultado de consultas) -s modo paso a paso (confirmar cada consulta) -t mostrar sólo filas (-P tuples_only) -v NOMBRE=VALOR definir variable NOMBRE de psql a VALOR -x activar modo expandido de salida de tablas (-P expanded) \! [COMANDO] ejecutar comando en intérprete de comandos, o iniciar intérprete interactivo \C [CADENA] definir título de tabla, o indefinir si es vacío \H cambiar modo de salida HTML (actualmente %s) \T [CADENA] definir atributos HTML de
, o indefinir si es vacío \a cambiar entre modo de salida alineado y sin alinear \c[onnect] [BASE-DE-DATOS|- [USUARIO]] conectar a una nueva base de datos (actual: "%s") \cd [DIR] cambiar el directorio de trabajo \copy ... ejecutar comando SQL COPY con flujo de datos al cliente \copyright mostrar términos de uso y distribución de PostgreSQL \d [NOMBRE] describir tabla, índice, secuencia o vista \dC listar conversiones de tipo (casts) \dD [PATRÓN] listar dominios \dT [PATRÓN] listar tipos de dato ("+" para más detalles) \da [PATRÓN] listar funciones de agregación \dc [PATRÓN] listar conversiones \dd [PATRÓN] listar comentarios de objetos \df [PATRÓN] listar funciones ("+" para más detalles) \dl listar objetos grandes, lo mismo que \lo_list \dn [PATRÓN] listar esquemas \do [NOMBRE] listar operadores \dp [PATRÓN] listar privilegios de acceso a tablas \du [PATRÓN] listar usuarios \d{t|i|s|v|S} [PATRÓN] (agregue "+" para obtener más detalles) listar tablas/índices/secuencias/vistas/tablas de sistema \e [ARCHIVO] editar el búfer de consulta (o archivo) con editor externo \echo [CADENA] escribir cadena a salida estándar \encoding [CODIFICACIÓN] mostrar o definir codificación del cliente \f [CADENA] mostrar o definir separador de campos para modo de salida sin alinear \g [ARCHIVO] enviar búfer de consulta al servidor (y resultados a archivo o |comando) \h [NOMBRE] mostrar ayuda de sintaxis de comandos SQL, * para todos los comandos \i ARCHIVO ejecutar comandos desde archivo \l listar todas las bases de datos ("+" para más detalles) \lo_export \lo_import \lo_list \lo_unlink operaciones con objetos grandes \o [ARCHIVO] envíar resultados de consultas a archivo o |comando \p mostrar el contenido del búfer de consulta \pset OPCIÓN [VALOR] definir opción de salida de tablas (OPCIÓN := {format|border|expanded|fieldsep|footer|null| recordsep|tuples_only|title|tableattr|pager}) \q salir de psql \qecho [CADENA] escribir cadena a salida de consultas (ver \o) \r reiniciar (limpiar) el búfer de consulta \s [ARCHIVO] mostrar historial de comandos o guardarlo en archivo \set [NOMBRE [VALOR]] definir variables internas, listar todas si no se dan parámetros \t mostrar sólo filas (actualmente %s) \timing mostrar tiempo de ejecución de comandos (actualmente %s) \unset NOMBRE indefinir (eliminar) variable interna \w [ARCHIVO] escribir búfer de consulta a archivo \x cambiar modo expandido (actualmente %s) \z [PATRÓN] listar privilegios de acceso a tablas (lo mismo que \dp) psql [OPCIONES]...[BASE-DE-DATOS [USUARIO]] llave primaria, único,%s%s: %s %s: Atención: La opción -u está obsoleta. Use -U. %s: no se puede copiar desde/hacia un directorio %s: no se ha podido eliminar variable "%s" %s: no se ha podido definir variable "%s" %s: no se ha podido definir parámetro de despliegue "%s" %s: transacción en curso está abortada %s: nombre de codificación no válido o procedimiento de conversión no encontrado %s: no está conectado a una base de datos %s: memoria agotada. %s: estado de transacción desconocido %s: atención: se ignoró argumento extra "%s" en línea de comandos %s: xstrdup: no se puede duplicar puntero nulo (error interno) (%d filas)(1 fila)(Sin filas) (todos los tipos)(binario-compatible)***(Modo paso a paso: verifique comando)**************************************** %s ***(presione enter para continuar, o x y enter para cancelar)******************* ?%c? "%s.%s"ABORT [ WORK | TRANSACTION ]ALTER AGGREGATE name ( type ) RENAME TO newnameALTER CONVERSION name RENAME TO newnameALTER DATABASE name SET parameter { TO | = } { value | DEFAULT } ALTER DATABASE name RESET parameter ALTER DATABASE name RENAME TO newnameALTER 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_ownerALTER FUNCTION name ( [ type [, ...] ] ) RENAME TO newnameALTER GROUP groupname ADD USER username [, ... ] ALTER GROUP groupname DROP USER username [, ... ] ALTER GROUP groupname RENAME TO newnameALTER LANGUAGE name RENAME TO newnameALTER OPERATOR CLASS name USING index_method RENAME TO newnameALTER SCHEMA name RENAME TO newnameALTER SEQUENCE name [ INCREMENT [ BY ] increment ] [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ] [ RESTART [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]ALTER TABLE [ ONLY ] name [ * ] ADD [ COLUMN ] column type [ column_constraint [ ... ] ] ALTER TABLE [ ONLY ] name [ * ] DROP [ COLUMN ] column [ RESTRICT | CASCADE ] ALTER TABLE [ ONLY ] name [ * ] ALTER [ COLUMN ] column { SET DEFAULT expression | DROP DEFAULT } ALTER TABLE [ ONLY ] name [ * ] ALTER [ COLUMN ] column { SET | DROP } NOT NULL ALTER TABLE [ ONLY ] name [ * ] ALTER [ COLUMN ] column SET STATISTICS integer ALTER TABLE [ ONLY ] name [ * ] ALTER [ COLUMN ] column SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN } ALTER TABLE [ ONLY ] name [ * ] SET WITHOUT OIDS ALTER TABLE [ ONLY ] name [ * ] RENAME [ COLUMN ] column TO new_column ALTER TABLE name RENAME TO new_name ALTER TABLE [ ONLY ] name [ * ] ADD table_constraint ALTER TABLE [ ONLY ] name [ * ] DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ] ALTER TABLE name OWNER TO new_owner ALTER TABLE name CLUSTER ON index_nameALTER TRIGGER name ON table RENAME TO newnameALTER USER name [ [ WITH ] option [ ... ] ] where option can be: [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' | CREATEDB | NOCREATEDB | CREATEUSER | NOCREATEUSER | VALID UNTIL 'abstime' ALTER USER name RENAME TO newname ALTER USER name SET parameter { TO | = } { value | DEFAULT } ALTER USER name RESET parameterANALYZE [ VERBOSE ] [ table [ (column [, ...] ) ] ]PrivilegiosPrivilegios para base de datos "%s"Tipos de datos de argumentosNotificación asíncrona "%s" recibida del proceso de servidor con PID %d. AtributosAyuda disponible: BEGIN [ WORK | TRANSACTION ]El estilo de borde es %d. CHECKPOINTCLOSE nameCLUSTER indexname ON tablename CLUSTER tablename CLUSTERCOMMENT ON { TABLE object_name | COLUMN table_name.column_name | AGGREGATE agg_name (agg_type) | CONSTRAINT constraint_name ON table_name | DATABASE object_name | DOMAIN object_name | FUNCTION func_name (arg1_type, arg2_type, ...) | INDEX object_name | OPERATOR op (leftoperand_type, rightoperand_type) | RULE rule_name ON table_name | SCHEMA object_name | SEQUENCE object_name | TRIGGER trigger_name ON table_name | TYPE object_name | VIEW object_name } IS 'text'COMMIT [ WORK | TRANSACTION ]COPY tablename [ ( column [, ...] ) ] FROM { 'filename' | STDIN } [ [ WITH ] [ BINARY ] [ OIDS ] [ DELIMITER [ AS ] 'delimiter' ] [ NULL [ AS ] 'null string' ] ] COPY tablename [ ( column [, ...] ) ] TO { 'filename' | STDOUT } [ [ WITH ] [ BINARY ] [ OIDS ] [ DELIMITER [ AS ] 'delimiter' ] [ NULL [ AS ] 'null string' ] ]CREATE AGGREGATE name ( BASETYPE = input_data_type, SFUNC = sfunc, STYPE = state_data_type [ , FINALFUNC = ffunc ] [ , INITCOND = initial_condition ] )CREATE CAST (sourcetype AS targettype) WITH FUNCTION funcname (argtype) [ AS ASSIGNMENT | AS IMPLICIT ] CREATE CAST (sourcetype AS targettype) WITHOUT FUNCTION [ AS ASSIGNMENT | AS IMPLICIT ]CREATE CONSTRAINT TRIGGER name AFTER events ON tablename constraint attributes FOR EACH ROW EXECUTE PROCEDURE funcname ( args )CREATE DATABASE name [ [ WITH ] [ OWNER [=] dbowner ] [ LOCATION [=] 'dbpath' ] [ TEMPLATE [=] template ] [ ENCODING [=] encoding ] ]CREATE DOMAIN name [AS] data_type [ DEFAULT expression ] [ constraint [ ... ] ] where constraint is: [ CONSTRAINT constraint_name ] { NOT NULL | NULL | CHECK (expression) }CREATE GROUP name [ [ WITH ] option [ ... ] ] where option can be: SYSID gid | USER username [, ...]CREATE OPERATOR CLASS name [ DEFAULT ] FOR TYPE data_type USING index_method AS { OPERATOR strategy_number operator_name [ ( op_type, op_type ) ] [ RECHECK ] | FUNCTION support_number funcname ( argument_type [, ...] ) | STORAGE storage_type } [, ... ]CREATE OPERATOR name ( PROCEDURE = funcname [, LEFTARG = lefttype ] [, RIGHTARG = righttype ] [, COMMUTATOR = com_op ] [, NEGATOR = neg_op ] [, RESTRICT = res_proc ] [, JOIN = join_proc ] [, HASHES ] [, MERGES ] [, SORT1 = left_sort_op ] [, SORT2 = right_sort_op ] [, LTCMP = less_than_op ] [, GTCMP = greater_than_op ] )CREATE SCHEMA schemaname [ AUTHORIZATION username ] [ schema_element [ ... ] ] CREATE SCHEMA AUTHORIZATION username [ schema_element [ ... ] ]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 ( INPUT = input_function, OUTPUT = output_function [ , RECEIVE = receive_function ] [ , SEND = send_function ] [ , INTERNALLENGTH = { internallength | VARIABLE } ] [ , PASSEDBYVALUE ] [ , ALIGNMENT = alignment ] [ , STORAGE = storage ] [ , DEFAULT = default ] [ , ELEMENT = element ] [ , DELIMITER = delimiter ] )CREATE USER name [ [ WITH ] option [ ... ] ] where option can be: SYSID uid | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' | CREATEDB | NOCREATEDB | CREATEUSER | NOCREATEUSER | IN GROUP groupname [, ...] | VALID UNTIL 'abstime'CREATE [ OR REPLACE ] FUNCTION name ( [ argtype [, ...] ] ) RETURNS rettype { LANGUAGE langname | IMMUTABLE | STABLE | VOLATILE | CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT | [EXTERNAL] SECURITY INVOKER | [EXTERNAL] SECURITY DEFINER | AS 'definition' | AS 'obj_file', 'link_symbol' } ... [ WITH ( attribute [, ...] ) ]CREATE [ OR REPLACE ] RULE name AS ON event TO table [ WHERE condition ] DO [ INSTEAD ] { NOTHING | command | ( command ; command ... ) }CREATE [ OR REPLACE ] VIEW name [ ( column_name [, ...] ) ] AS queryCREATE [ TEMPORARY | TEMP ] SEQUENCE name [ INCREMENT [ BY ] increment ] [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ] [ START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]CREATE [ TRUSTED ] [ PROCEDURAL ] LANGUAGE name HANDLER call_handler [ VALIDATOR valfunction ]CREATE [ UNIQUE ] INDEX name ON table [ USING method ] ( { column | ( expression ) } [ opclass ] [, ...] ) [ WHERE predicate ]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 ] } [, ... ] ) [ INHERITS ( parent_table [, ... ] ) ] [ WITH OIDS | WITHOUT OIDS ] [ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ] donde column_constraint es: [ CONSTRAINT constraint_name ] { NOT NULL | NULL | UNIQUE | PRIMARY KEY | CHECK (expression) | REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE action ] [ ON UPDATE action ] } [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] y table_constraint es: [ CONSTRAINT constraint_name ] { UNIQUE ( column_name [, ... ] ) | PRIMARY KEY ( column_name [, ... ] ) | 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 ]CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name [ (column_name [, ...] ) ] AS queryCREATE [DEFAULT] CONVERSION name FOR source_encoding TO dest_encoding FROM funcnameRestricciones CHECK:ColumnaComando: %s Descripción: %s Sintaxis: %s Tipo compuesto "%s.%s"Copy, Objetos Grandes DEALLOCATE [ PREPARE ] plan_nameDECLARE name [ BINARY ] [ INSENSITIVE ] [ [ NO ] SCROLL ] CURSOR [ { WITH | WITHOUT } HOLD ] FOR query [ FOR { READ ONLY | UPDATE [ OF column [, ...] ] } ]DELETE FROM [ ONLY ] table [ WHERE condition ]DROP AGGREGATE name ( type ) [ CASCADE | RESTRICT ]DROP CAST (sourcetype AS targettype) [ CASCADE | RESTRICT ]DROP CONVERSION name [ CASCADE | RESTRICT ]DROP DATABASE nameDROP DOMAIN name [, ...] [ CASCADE | RESTRICT ]DROP FUNCTION name ( [ type [, ...] ] ) [ CASCADE | RESTRICT ]DROP GROUP nameDROP INDEX name [, ...] [ CASCADE | RESTRICT ]DROP OPERATOR CLASS name USING index_method [ CASCADE | RESTRICT ]DROP OPERATOR name ( lefttype | NONE , righttype | NONE ) [ CASCADE | RESTRICT ]DROP RULE name ON relation [ CASCADE | RESTRICT ]DROP SCHEMA name [, ...] [ CASCADE | RESTRICT ]DROP SEQUENCE name [, ...] [ CASCADE | RESTRICT ]DROP TABLE name [, ...] [ CASCADE | RESTRICT ]DROP TRIGGER name ON table [ CASCADE | RESTRICT ]DROP TYPE name [, ...] [ CASCADE | RESTRICT ]DROP USER nameDROP VIEW name [, ...] [ CASCADE | RESTRICT ]DROP [ PROCEDURAL ] LANGUAGE name [ CASCADE | RESTRICT ]Tipo de datoEl pie de página por omisión está desactivado.El pie por omisión está activo.Por omisión?DescripciónDestinoNo se encontró relación llamada "%s". No se encontró relación con OID %s. END [ WORK | TRANSACTION ]EXECUTE plan_name [ (parameter [, ...] ) ]EXPLAIN [ ANALYZE ] [ VERBOSE ] statementCodificaciónIngrese los datos a ser copiados seguidos de un fin de línea. Termine con un backslash y un punto.Se ha desactivado el despliegue expandido. Se ha activado el despliegue expandido. 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 ALLfalló. El separador de campos es "%s". Restricciones de llave foránea:Formato FunciónGRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,...] | ALL [ PRIVILEGES ] } ON [ TABLE ] tablename [, ...] TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH GRANT OPTION ] GRANT { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] } ON DATABASE dbname [, ...] TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH GRANT OPTION ] GRANT { EXECUTE | ALL [ PRIVILEGES ] } ON FUNCTION funcname ([type, ...]) [, ...] TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH GRANT OPTION ] GRANT { USAGE | ALL [ PRIVILEGES ] } ON LANGUAGE langname [, ...] TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH GRANT OPTION ] GRANT { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] } ON SCHEMA schemaname [, ...] TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH GRANT OPTION ]General Opciones generales:INSERT INTO table [ ( column [, ...] ) ] { DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) | query }Implícito?Índice "%s.%s"Índices:Informacional HeredaEntrada/Salida Nombre internoComando \%s no válido. Use \? para obtener ayuda. LISTEN nameLOAD 'filename'LOCK [ TABLE ] name [, ...] [ IN lockmode MODE ] where lockmode is one of: ACCESS SHARE | ROW SHARE | ROW EXCLUSIVE | SHARE UPDATE EXCLUSIVE | SHARE | SHARE ROW EXCLUSIVE | EXCLUSIVE | ACCESS EXCLUSIVELenguajeObjetos grandesTipo arg izqListado de funciones de agregaciónListado de conversiones de tipo (casts)Listado de conversionesListado de tipos de datoListado de usuarios de la base de datosListado de base de datosListado de dominiosListado de funcionesListado de operadoresListado de relacionesListado de schemasMOVE [ direction { FROM | IN } ] cursornameModificadorModificadoresNOTIFY nameNombreNo hay ayuda disponible para "%-.*s". Pruebe \h sin argumentos para mostrar los elementos de ayuda disponibles. No se encontraron relaciones coincidentes. No se encontraron relaciones. Despliegue de nulos es "%s". ObjetoDescripciones de objetosEl formato de salida es %s. DueñoPREPARE plan_name [ (datatype [, ...] ) ] AS statementEl paginador se usará siempre.El paginador se usará para salida larga.El paginador no se usará.Contraseña: Se ha mantenido la conexión anterior Búfer de consulta El búfer de consulta está vacío.El búfer de consulta ha sido reiniciado (limpiado).REINDEX { DATABASE | TABLE | INDEX } name [ FORCE ]RESET name RESET ALLREVOKE [ GRANT OPTION FOR ] { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,...] | ALL [ PRIVILEGES ] } ON [ TABLE ] tablename [, ...] FROM { username | GROUP groupname | PUBLIC } [, ...] [ CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FOR ] { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] } ON DATABASE dbname [, ...] FROM { username | GROUP groupname | PUBLIC } [, ...] [ CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FOR ] { EXECUTE | ALL [ PRIVILEGES ] } ON FUNCTION funcname ([type, ...]) [, ...] FROM { username | GROUP groupname | PUBLIC } [, ...] [ CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FOR ] { USAGE | ALL [ PRIVILEGES ] } ON LANGUAGE langname [, ...] FROM { username | GROUP groupname | PUBLIC } [, ...] [ CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FOR ] { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] } ON SCHEMA schemaname [, ...] FROM { username | GROUP groupname | PUBLIC } [, ...] [ CASCADE | RESTRICT ]ROLLBACK [ WORK | TRANSACTION ]El separador de filas es "%s". El separador de filas es .Tipo de dato de salidaTipo resultadoTipo arg derReglasReglas: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 [, ...] ] [ { UNION | INTERSECT | EXCEPT } [ ALL ] select ] [ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ] [ LIMIT { count | ALL } ] [ OFFSET start ] [ FOR UPDATE [ OF tablename [, ...] ] ]SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ] * | expression [ AS output_name ] [, ...] [ FROM from_item [, ...] ] [ WHERE condition ] [ GROUP BY expression [, ...] ] [ HAVING condition [, ...] ] [ { UNION | INTERSECT | EXCEPT } [ ALL ] select ] [ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ] [ LIMIT { count | ALL } ] [ OFFSET start ] [ FOR UPDATE [ OF table_name [, ...] ] ] donde from_item puede ser uno de: [ ONLY ] table_name [ * ] [ [ AS ] alias [ ( column_alias [, ...] ) ] ] ( select ) [ 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 [, ...] ) ]SET CONSTRAINTS { ALL | name [, ...] } { DEFERRED | IMMEDIATE }SET TRANSACTION [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ] [ READ WRITE | READ ONLY ] SET SESSION CHARACTERISTICS AS TRANSACTION [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ] [ READ WRITE | READ ONLY ]SET [ SESSION | LOCAL ] SESSION AUTHORIZATION username SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT RESET SESSION AUTHORIZATIONSET [ SESSION | LOCAL ] name { TO | = } { value | 'value' | DEFAULT } SET [ SESSION | LOCAL ] TIME ZONE { timezone | LOCAL | DEFAULT }SHOW name SHOW ALLconexión SSL (cifrado: %s, bits: %i) START TRANSACTION [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ] [ READ WRITE | READ ONLY ]SchemaSecuencia "%s.%s"Mostrando sólo filas.TamañoFuenteCódigo fuenteTipo fuenteRelación especial "%s.%s"con éxito. Tabla TOAST "%s.%s"TRUNCATE [ TABLE ] nameTablaTabla "%s.%s"Los atributos de tabla son "%s". Los atributos de tabla han sido indefinidos. Tipo destinoLa conexión al servidor se ha perdido. Intentando reiniciar: Este es psql %s, el terminal interactivo de PostgreSQL. Duración: %.3f ms Mostrar tiempos está desactivado.Mostrar tiempos está activado.El título es "%s". El título ha sido indefinido. Triggers:Use "%s --help" para obtener más información. Mostrar sólo filas está desactivado.TipoUNLISTEN { name | * }UPDATE [ ONLY ] table SET column = { expression | DEFAULT } [, ...] [ FROM fromlist ] [ WHERE condition ]Modo de empleo:Use "\q" para salir de %s. ID de usuarioNombre de usuarioNombre de usuario: VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ table ] VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ table [ (column [, ...] ) ] ]Vista "%s.%s"Definición de vista: %sAtención: esta sintaxis está obsoleta. Bienvenido a %s %s, el terminal interactivo de PostgreSQL. Digite: \copyright para ver los términos de distribución \h para obtener ayuda sobre comandos SQL \? para obtener ayuda sobre comandos internos \g o termine con punto y coma (;) para ejecutar consulta \q para salir Se escribió historial a archivo "%s". No está conectado a una base de datos. Ahora está conectado como el usuario "%s". Ahora está conectado a la base de datos "%s" con el usuario "%s". Ahora está conectado a la base de datos "%s". \!: falló \%s: no se pudo cambiar directorio a "%s": %s \%s: error \%s: argumento extra "%s" ignorado \%s: falta argumento requerido \connect: %s\copy: %s\copy: argumentos requeridos \copy: error de procesamiento en "%s" \copy: error de procesamiento al final de la línea \copy: respuesta inesperada (%d) \pset: formatos permitidos son unaligned, aligned, html, latex \pset: opción desconocida: %s aborta la transacción en cursofunción de agregaciónaltera la definición de un generador secuencialcambia una base de datoscambia una cuenta de usuario de la base de datoscambia un parámetro de configuracióncambia un grupo de usuarioscambia la definición de una conversióncambia la definición de un dominiocambia la definición de una funcióncambia la definición de un lenguaje proceduralcambia la definición de una tablacambia la definición de un triggercambia la definición de una función de agregacióncambia la definición de una clase de operadorescierra un cursorreordena una tabla siguiendo un índicerecolecta estadísticas sobre una base de datoscompromete la transacción en cursose ha perdido la conexión al servidor incluye soporte para edición de línea de comandoscopia datos entre un archivo y una tablano se ha podido obtener el nombre de usuario actual: %s No se ha podido obtener directorio home: %s no se ha podido abrir archivo temporal "%s": %s no se pudo guardar historial a archivo "%s": %s no se ha podido iniciar /bin/sh no se ha podido iniciar el editor "%s" crea una nueva base de datoscrea una nueva tabla usando los resultados de una consultacrea bases de datoscrea nuevas filas en una tablatipo de datoelimina una sentencia preparadadefine un nuevo cursordefine una nueva función de agregacióndefine una nueva conversión de tipodefine un nuevo trigger de restriccióndefine una nueva conversión de codificacióndefine un nuevo tipo de datosdefine una nueva cuenta de usuariodefine un nuevo dominiodefine una nueva funcióndefine un nuevo índicedefine un nuevo operadordefine una nueva clase de operadoresdefine un nuevo lenguaje proceduraldefine una nueva regla de reescrituradefine un nuevo schemadefine un nuevo generador secuencialdefine una nueva tabladefine un nuevo triggerdefine un nuevo grupo de usuariosdefine una nueva vistadefine privilegios de accesodefine o cambia un comentario sobre un objetoelimina filas de una tablavacía una tablaejecuta una sentencia preparadade tabla "%s.%s"fuerza un checkpoint del registro de transaccionesfunciónrecolecta basura y opcionalmente estadísticas sobre una base de datosgenera una notificaciónen asignacióníndicecomando \%s no válido escucha notificacionescarga o recarga un archivo de biblioteca compartidasocket localbloquea una tablanono hay búfer de consulta desactivadoactivadooperadormemoria agotada error de procesamiento en el fin de línea reposiciona un cursorprepara una sentencia para ejecuciónllave primaria, reconstruye índiceselimina una conversión de tipoelimina una conversión de codificaciónelimina un tipo de datoselimina una base de datoselimina una cuenta de usuarioelimina un dominioelimina una funciónelimina un lenguaje proceduralelimina una regla de reescrituraelimina un schemaelimina un generador secuencialelimina una tablaelimina un triggerelimina un grupo de usuarioselimina una vistarevoca privilegios de accesoelimina una función de agregaciónelimina un índiceelimina un operadorelimina una clase de operadoresrestaura el valor de un parámetro de configuración al valor inicialrecupera filas de una consulta usando un cursorrecupera filas desde una tabla o vistareglasecuenciadefine las características de la transacción en cursodefine el modo de las restricciones de la transacción en cursodefine el identificador del usuario de sesión y el identificador del usuario actual de la sesión en cursomuestra el plan de ejecución de una sentenciamuestra el valor de un parámetro de configuraciónespecialinicia un bloque de transaccióndeja de escuchar una notificaciónsuperusuariosuperusuario, crea bases de datostablatriggerúnico, actualiza filas de una tablavistasí