D_l%%%&&' ' +'7'EC'}A'E(9(ID(I(G)O)Z5)C)6*$,*[D*F*.+7+CK+{5+B+7,@7,x>,7,2-'1-Z=-E-3.8.DC.}B.Y/6/^F/>/:00V0s;0*0"0)1:1F611 1.12'w2DF213D35H3zL3D4,4U>4N49575J56HP6d0646[7/7w:727,878B<8z(8 888829$95#9Z 9~)9#9<9 :*:K:^6:~<: :: ; ;;;/ ;;/;'.%>>>??-CQC3EEL#E^EIE EEEF F. F98FDF}HlHJ1JKL:LoMN ]OPrQQSRnTZUDV[VbWsWfX]k\W]0]],]]] ]^.^3^;_"+_^_0_>_` .`B`LP`1`/a1aB.at1a-ab-b8b@ bybbb b b&b'bc *c;)cfceccdd2eFeOei eeneiiui i iiii i i&i jjj.k k kk' kCkQkekxkkkkkk+kl# l, l6lBOlGllllllm6mmOmem mm mmm3nn4nIr]r}rr rrrrrt?x`xyzz'zbz{3{:{K{`{e {l {x{ {{{{ {{| |9|(7|b|| ||| |&|}},}1q}G}}} } }} ~u~$~~/(50(f , !  #-H"d ; ,'Tf%!#.! P"q.*%##Gf)$$!'(Cl. <Ll~"-C _ )9c z"1 -;AV$p ! 6D Tbv1@Q es>)$"Nqv22V&<&c!  !&F*q| :B?CFT4RTZEXH5EA7_N]4DByTMI_FIK:J8D AOOG;)WeId2l?P>0Ao K,8K+D<2$R8w$^\1XTFf>+AMm[F9^gA0>65A0JC{AF)Hr 51--0?^'K 3 M7n< 3 @;E&"UI3J>~?F= *!E< <-(F X EVt#šO4Ƅxkyȃoom  '"Dg/DH<ύ46OMН5дAZ,<ч4:44?i1ҩ4>+j"y!Ӝ Ӿ/*-,H&u Ԝqԩ  <+] ։"ֶ֓  ڏڙzڭ (4C L Z d p.| ۫۶ܴܺ%$C\o ݆ݓݢݵ (  g",ފ!޷%-;5q7ߎ% ))J7tM/83h wG8e%b+1C^g k x #?.5n *%Iosn*+4EX" .,,[0+>+$P9`-  )*C3n C"?)Gq$26)S}&% D Uv**&=8M35'*C+^!5"M-p!  7 T#u!#"7'W,5 C Ucj.!  (,An~/'5Liy (8Vr:,$9 A&K5r^*$2W_y   Q\8rz2,]Yb$ h \;ytZX/ceUb_ x*.# +7)29yi zjgk~4?`Ir`R1&oj;M:]Il{OvCWmCL_m=wB@A ( n3nY(ZE !T4s[K'cqk5GPx9^u"tf)Le^AWG*M:H1H B6}8q-OPQ63~pNV/uK&F'El5dp%>>-os||  UVSv0JNRD"a@7iw}=SFf#?[ X+TD.!g<$0d,%{hJ<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 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:36+0100 Last-Translator: Aleksander Kmetec Language-Team: Slovenian MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Povezavne možnosti: Za več informacij vtipkajte "\?" (za interne ukaze) ali "\help" (za SQL ukaze) v ukazni vrstici psql. V pomoč vam je na voljo tudi odsek o programu psql v PostgreSQL dokumentaciji. Hrošče sporočajte na naslov . Vhodne in izhodne možnosti: Oblikovne možnosti: "%s" "%s" %s --help izpiši to pomoč, nato končaj program --version izpiši podatke o verziji, nato končaj program -A neporavnan izpis tabel (-P format=unaligned) -E prikazuj poizvedbe, ki jih generirajo interni ukazi -F NIZ nastavi ločitveni niz med polji (privzeto: "%s") (-P fieldsep=) -H HTML izpis tabel (-P format=html) -P IME[=ARG] nastavi možnost izpisa IME na vrednost ARG (glejte \pset ukaz) -R NIZ nastavi ločitveni niz med zapisi (privzeto: ) (-P recordsep=) -S konec vrstice konča SQL ukaz (single-line način) -T BESEDILO nastavi atribute tabele v HTML izpisu (width, border) (-P tableattr=) -U IME uporabniško ime (privzeto: "%s") -W vprašaj za geslo (ponavadi se to zgodi samodejno) -X preskoči branje zagonske datoteke (~/.psqlrc) -a izpisuj vse vhodne ukaze iz datoteke -c UKAZ izvrši podani ukaz (SQL ali interni), nato končaj program -d IME_BAZE navedite ime baze podatkov, s katero se želite povezati (privzeto: "%s") -e izpisuj ukaze, poslane strežniku -f DATOTEKA izvrši ukaze iz datoteke, nato končaj program -h GOSTITELJ gostitelj strežnika ali direktorij z vtičnico (privzeto: "%s") -l naštej razpoložljive baze podatkov, nato končaj program -n onemogoči napredno urejanje ukazne vrstice (readline) -o DATOTEKA rezultate poizvedbe preusmeri v datoteko (ali |cev) -p VRATA vrata (port) podatkovnega strežnika (privzeto: "%s") -q tiho izvajanje (brez sporočil, samo rezultati poizvedb) -s zahtevaj potrditev vsake poizvedbe (single-step način) -t izpisuj samo vrstice (-P tuples_only) -v IME=VREDNOST nastavi psql spremenljivko IME na podano VREDNOST -x vključi razširjeni izpis tabel (-P expanded) \! [UKAZ] izvrši ukaz v lupini, ali zaženi interaktivno ukazno lupino \C [NIZ] nastavi naslov tabele, ali počisti, če niz ni podan \H preklopi HTML način izpisa (trenutno %s) \T [NIZ] nastavi atribute HTML značke
, ali počisti, če niz ni podan \a preklopi med neporavnanim in poravnanim načinom izpisa \c[onnect] [IME_BAZE|- [UPORABNIK]] poveži z novo bazo podatkov (trenutno "%s") \cd [DIR] spremeni trenutni delovni imenik \copy ... izvedi SQL COPY med odjemalcem in strežnikom \copyright prikaži pogoje za uporabo in razširjanje programa PostgreSQL \d [IME] opiši tabelo, indeks, zaporedje, ali pogled \dC naštej pretvorbe med podatkovnimi tipi (casts) \dD [VZOREC] naštej domene \dT [VZOREC] naštej podatkovne tipe (dodajte "+" za več podrobnosti) \da [VZOREC] naštej agregatne funkcije \dc [VZOREC] naštej pretvorbe med kodnimi tabelami \dd [VZOREC] prikaži komentar objekta \df [VZOREC] naštej funkcije (dodajte "+" za več podrobnosti) \dl naštej velike objekte, enako kot \lo_list \dn [VZOREC] naštej sheme \do [IME] naštej operatorje \dp [VZOREC] naštej privilegije za dostop do tabel \du [VZOREC] naštej uporabnike \d{t|i|s|v|S} [VZOREC] (dodajte "+" za več podrobnosti) naštej tabele/indekse/zaporedja/poglede/sistemske tabele \e [DATOTEKA] uredi vsebino medpomnilnika poizvedb (ali datoteko) z zunanjim urejevalnikom \echo [NIZ] izpiši niz na standardni izhod \encoding [KODNA_TABELA] prikaži ali nastavi kodno tabelo odjemalca \f [NIZ] prikaži ali nastavi ločitveni niz za neporavnan izpis rezultatov \g [DATOTEKA] pošlji vsebino medpomnilnika poizvedb strežniku (in rezultate v datoteko ali |cev) \h [IME] pomoč s sintakso SQL ukazov, * za vse ukaze \i DATOTEKA izvrši ukaze iz datoteke \l naštej vse baze podatkov (dodajte "+" za več podrobnosti) \lo_export \lo_import \lo_list \lo_unlink operacije za delo z velikimi objekti \o [DATOTEKA] vse rezultate poizvedb preusmeri v datoteko ali |cev \p prikaži vsebino medpomnilnika poizvedb \pset IME [VREDNOST] nastavi možnosti izpisa tabel (NAME := {format|border|expanded|fieldsep|footer|null| recordsep|tuples_only|title|tableattr|pager}) \q zapri psql \qecho [NIZ] zapiši niz v izhodni tok poizvedbe (glejte \o) \r izprazni medpomnilnik poizvedb \s [DATOTEKA] prikaži zgodovino, ali jo shrani v datoteko \set [IME [VREDNOST]] nastavi vrednost interne spremenljivke, ali izpiši vse obstoječe, če ni podan noben parameter \t prikaži samo vrstice (trenutno %s) \timing preklopi merjenja časa izvajanja (trenutno %s) \unset IME pobriši interno spremenljivko \w [DATOTEKA] zapiši vsebino medpomnilnika poizvedb v datoteko \x preklopi razširjen način izpisa (trenutno %s) \z [PATTERN] naštej privilegije za dostop do tabel (same as \dp) psql [MOŽNOSTI]... [BAZA [UPORABNIK]] primarni ključ, unikaten,%s%s: %s %s: Opozorilo: Opcija -u je zastarela. Uporabite -U. %s: kopiranje iz imenika ali v imenik ni mogoče %s: nisem mogel pobrisati spremenljivke "%s" %s: nisem mogel nastaviti spremenljivke "%s" %s: nastavljanje možnosti oblike izpisa "%s" ni bilo uspešno %s: trenutna transakcija je prekinjena %s: neveljavno ime kodne tabele, ali pa pretvorbeni postopek ni bil najden %s: ni povezave z bazo podatkov %s: zmanjkalo je spomina %s: stanje transakcije ni znano %s: opozorilo: odvečni argument "%s" je bil ignoriran %s: xstrdup: cannot duplicate null pointer (interna napaka) (%d vrstic)(1 vrstica)(0 vrstic) (vsi podatkovni tipi)(binarno združljiva)***(Single step način: potrdite ukaz)******************************************* %s ***(pritisnite enter za nadaljevanje, ali vtipkajte x in enter za preklic)****** ?%c? "%s.%s"ABORT [ WORK | TRANSACTION ]ALTER AGGREGATE ime_agregata ( tip ) RENAME TO novo_ime_agregataALTER CONVERSION ime_pretvorbe RENAME TO novo_ime_pretvorbeALTER DATABASE ime_baze SET parameter { TO | = } { vrednost | DEFAULT } ALTER DATABASE ime_baze RESET parameter ALTER DATABASE ime_baze RENAME TO novo_ime_bazeALTER DOMAIN ime_domene { SET DEFAULT izraz | DROP DEFAULT } ALTER DOMAIN ime_domene { SET | DROP } NOT NULL ALTER DOMAIN ime_domene ADD omejitev_domene ALTER DOMAIN ime_domene DROP CONSTRAINT ime_omejitve [ RESTRICT | CASCADE ] ALTER DOMAIN ime_domene OWNER TO novi_lastnikALTER FUNCTION ime_funkcije ( [ tip_parametra [, ...] ] ) RENAME TO novo_ime_funkcijeALTER GROUP ime_skupine ADD USER uporabniško_ime [, ... ] ALTER GROUP ime_skupine DROP USER uporabniško_ime [, ... ] ALTER GROUP ime_skupine RENAME TO novo_ime_skupineALTER LANGUAGE ime_jezika RENAME TO novo_ime_jezikaALTER OPERATOR CLASS ime USING index_method RENAME TO novo_imeALTER SEQUENCE ime_zaporedja [ INCREMENT [ BY ] inkrement ] [ MINVALUE min_vrednost | NO MINVALUE ] [ MAXVALUE max_vrednost | NO MAXVALUE ] [ RESTART [ WITH ] začetek ] [ CACHE cache ] [ [ NO ] CYCLE ]ALTER TABLE [ ONLY ] ime_tabele [ * ] ADD [ COLUMN ] ime_stolpca podatkovi_tip [ omejitve_stolpca [ ... ] ] ALTER TABLE [ ONLY ] ime_tabele [ * ] DROP [ COLUMN ] ime_stolpca [ RESTRICT | CASCADE ] ALTER TABLE [ ONLY ] ime_tabele [ * ] ALTER [ COLUMN ] ime_stolpca { SET DEFAULT izraz | DROP DEFAULT } ALTER TABLE [ ONLY ] ime_tabele [ * ] ALTER [ COLUMN ] ime_stolpca { SET | DROP } NOT NULL ALTER TABLE [ ONLY ] ime_tabele [ * ] ALTER [ COLUMN ] ime_stolpca SET STATISTICS integer ALTER TABLE [ ONLY ] ime_tabele [ * ] ALTER [ COLUMN ] ime_stolpca SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN } ALTER TABLE [ ONLY ] ime_tabele [ * ] SET WITHOUT OIDS ALTER TABLE [ ONLY ] ime_tabele [ * ] RENAME [ COLUMN ] ime_stolpca TO novo_ime_stolpca ALTER TABLE ime_tabele RENAME TO novo_ime_tabele ALTER TABLE [ ONLY ] ime_tabele [ * ] ADD table_constraint ALTER TABLE [ ONLY ] ime_tabele [ * ] DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ] ALTER TABLE ime_tabele OWNER TO novi_lastnik ALTER TABLE ime_tabele CLUSTER ON ime_indeksaALTER TRIGGER ime_prožilca ON ime_tabele RENAME TO novo_ime_prožilcaALTER USER uporabniško_ime [ [ WITH ] možnost [ ... ] ] kjer je možnost lahko: [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'geslo' | CREATEDB | NOCREATEDB | CREATEUSER | NOCREATEUSER | VALID UNTIL 'abstime' ALTER USER uporabniško_ime RENAME TO novo_uporabniško_ime ALTER USER uporabniško_ime SET parameter { TO | = } { vrednost | DEFAULT } ALTER USER uporabniško_ime RESET parameterANALYZE [ VERBOSE ] [ ime_tabele [ (ime_stolpca [, ...] ) ] ]PrivilegijiPrivilegiji za dostop v bazi podatkov "%s"Podatkovni tipi argumentovAsinhrono obvestilo "%s" prejeto od strežniškega procesa z PID %d. AtributiRazpoložljiva pomoč: BEGIN [ WORK | TRANSACTION ]Stil obrobe: %d. CHECKPOINTCLOSE ime_kurzorjaCLUSTER ime_indeksa ON ime_tabele CLUSTER ime_tabele CLUSTERCOMMENT ON { TABLE ime_objekta | COLUMN ime_tabele.ime_stolpca | AGGREGATE ime_agregata (tip_agregata) | CONSTRAINT ime_omejitve ON ime_tabele | DATABASE ime_objekta | DOMAIN ime_objekta | FUNCTION ime_funkcije (tip_argumenta, ...) | INDEX ime_objekta | OPERATOR ime_operatorja (levi_operand, desni_operand) | RULE ime_pravila ON ime_tabele | SCHEMA ime_objekta | SEQUENCE ime_objekta | TRIGGER ime_prožilca ON ime_tabele | TYPE ime_objekta | VIEW ime_objekta } IS 'besedilo'COMMIT [ WORK | TRANSACTION ]COPY ime_tabele [ ( ime_stolpca [, ...] ) ] FROM { 'datoteka' | STDIN } [ [ WITH ] [ BINARY ] [ OIDS ] [ DELIMITER [ AS ] 'razmejitveni_znak' ] [ NULL [ AS ] 'null string' ] ] COPY ime_tabele [ ( ime_stolpca [, ...] ) ] TO { 'datoteka' | STDOUT } [ [ WITH ] [ BINARY ] [ OIDS ] [ DELIMITER [ AS ] 'razmejitveni_znak' ] [ NULL [ AS ] 'null string' ] ]CREATE AGGREGATE ime_agregata ( BASETYPE = vhodni_podatkovni_tip, SFUNC = funkcija_stanja, STYPE = podatkovni_tip_stanja [ , FINALFUNC = zaključna_funkcija ] [ , INITCOND = začetno_stanje ] )CREATE CAST (izvorni_tip AS ciljni_tip) WITH FUNCTION ime_funkcije (tip_argumenta) [ AS ASSIGNMENT | AS IMPLICIT ] CREATE CAST (izvorni_tip AS ciljni_tip) WITHOUT FUNCTION [ AS ASSIGNMENT | AS IMPLICIT ]CREATE CONSTRAINT TRIGGER ime_prožilca AFTER dogodki ON ime_tabele omejitev atributi FOR EACH ROW EXECUTE PROCEDURE ime_funkcije ( argumenti )CREATE DATABASE ime_baze [ [ WITH ] [ OWNER [=] lastnik ] [ LOCATION [=] 'dbpath' ] [ TEMPLATE [=] predloga ] [ ENCODING [=] kodna_tabela ] ]CREATE DOMAIN ime_domene [AS] podatkovni_tip [ DEFAULT izraz ] [ omejitev [ ... ] ] kjer je omejitev lahko: [ CONSTRAINT ime_omejitve ] { NOT NULL | NULL | CHECK (izraz) }CREATE GROUP ime_skupine [ [ WITH ] možnost [ ... ] ] kjer je možnost lahko: SYSID gid | USER uporabniško_ime [, ...]CREATE OPERATOR CLASS ime [ DEFAULT ] FOR TYPE podatkovni_tip USING index_method AS { OPERATOR strategy_number ime_operatorja [ ( op_type, op_type ) ] [ RECHECK ] | FUNCTION support_number ime_funkcije ( tip_argumenta [, ...] ) | STORAGE storage_type } [, ... ]CREATE OPERATOR ime_operatorja ( PROCEDURE = ime_funkcije [, LEFTARG = levi_podatkovni_tip ] [, RIGHTARG = desni_podatkovni_tip ] [, 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 ime_sheme [ AUTHORIZATION uporabniško_ime ] [ element_sheme [ ... ] ] CREATE SCHEMA AUTHORIZATION uporabniško_ime [ element_sheme [ ... ] ]CREATE TRIGGER ime_prožilca { BEFORE | AFTER } { dogodek [ OR ... ] } ON ime_tabele [ FOR [ EACH ] { ROW | STATEMENT } ] EXECUTE PROCEDURE ime_funkcije ( argumenti )CREATE TYPE ime_podatkovnega_tipa AS ( ime_atributa podatkovni_tip [, ... ] ) CREATE TYPE ime_podatkovnega_tipa ( 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 uporabniško_ime [ [ WITH ] možnost [ ... ] ] kjer je možnost lahko: SYSID uid | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'geslo' | CREATEDB | NOCREATEDB | CREATEUSER | NOCREATEUSER | IN GROUP ime_skupine [, ...] | VALID UNTIL 'abstime'CREATE [ OR REPLACE ] FUNCTION ime_funkcije ( [ tip_argumenta [, ...] ] ) RETURNS tip_vrnjene_vrednosti { LANGUAGE ime_jezika | IMMUTABLE | STABLE | VOLATILE | CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT | [EXTERNAL] SECURITY INVOKER | [EXTERNAL] SECURITY DEFINER | AS 'definicija' | AS 'obj_file', 'link_symbol' } ... [ WITH ( atribut [, ...] ) ]CREATE [ OR REPLACE ] RULE ime_pravila AS ON dogodek TO ime_tabele [ WHERE pogoj ] DO [ INSTEAD ] { NOTHING | ukaz | ( ukaz ; ukaz ... ) }CREATE [ OR REPLACE ] VIEW ime_pogleda [ ( ime_stolpca [, ...] ) ] AS poizvedbaCREATE [ TEMPORARY | TEMP ] SEQUENCE ime_zaporedja [ INCREMENT [ BY ] inkrement ] [ MINVALUE min_vrednost | NO MINVALUE ] [ MAXVALUE max_vrednost | NO MAXVALUE ] [ START [ WITH ] začetek ] [ CACHE cache ] [ [ NO ] CYCLE ]CREATE [ TRUSTED ] [ PROCEDURAL ] LANGUAGE ime_jezika HANDLER upravljalec_klicov [ VALIDATOR validacijska_funkcija ]CREATE [ UNIQUE ] INDEX ime_indeksa ON ime_tabele [ USING način ] ( { ime_stolpca | ( izraz ) } [ opclass ] [, ...] ) [ WHERE pogoj_delnega_indeksa ]CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE ime_tabele ( { ime_stolpca podatkovni_tip [ DEFAULT privzeti_izraz ] [ omejitev_stolpca [ ... ] ] | omejitev_tabele | LIKE starševska_tabela [ { INCLUDING | EXCLUDING } DEFAULTS ] } [, ... ] ) [ INHERITS ( starševska_tabela [, ... ] ) ] [ WITH OIDS | WITHOUT OIDS ] [ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ] kjer je omejitev_stolpca lahko: [ CONSTRAINT ime_omejitve ] { NOT NULL | NULL | UNIQUE | PRIMARY KEY | CHECK (izraz) | REFERENCES ref_tabela [ ( ref_stolpec ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE akcija ] [ ON UPDATE akcija ] } [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] in omejitev_tabele je lahko: [ CONSTRAINT ime_omejitve ] { UNIQUE ( ime_stolpca [, ... ] ) | PRIMARY KEY ( ime_stolpca [, ... ] ) | CHECK ( izraz ) | FOREIGN KEY ( ime_stolpca [, ... ] ) REFERENCES ref_tabela [ ( ref_stolpec [, ... ] ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE akcija ] [ ON UPDATE akcija ] } [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE ime_tabele [ (ime_stolpca [, ...] ) ] AS poizvedbaCREATE [DEFAULT] CONVERSION ime_pretvorbe FOR izvorna_kodna_tabela TO ciljna_kodna_tabela FROM ime_funkcijeOmejitve:StolpecUkaz: %s Opis: %s Sintaksa: %s Sestavljen tip "%s.%s"Kopiranje in veliki objekti DEALLOCATE [ PREPARE ] ime_načrtaDECLARE ime_kurzorja [ BINARY ] [ INSENSITIVE ] [ [ NO ] SCROLL ] CURSOR [ { WITH | WITHOUT } HOLD ] FOR poizvedba [ FOR { READ ONLY | UPDATE [ OF stolpec [, ...] ] } ]DELETE FROM [ ONLY ] ime_tabele [ WHERE pogoj ]DROP AGGREGATE ime_agregata ( tip_argumenta ) [ CASCADE | RESTRICT ]DROP CAST (izvorni_tip AS ciljni_tip) [ CASCADE | RESTRICT ]DROP CONVERSION ime_pretvorbe [ CASCADE | RESTRICT ]DROP DATABASE ime_bazeDROP DOMAIN ime_domene [, ...] [ CASCADE | RESTRICT ]DROP FUNCTION ime_funkcije ( [ tip_argumenta [, ...] ] ) [ CASCADE | RESTRICT ]DROP GROUP ime_skupineDROP INDEX ime_indeksa [, ...] [ CASCADE | RESTRICT ]DROP OPERATOR CLASS ime USING index_method [ CASCADE | RESTRICT ]DROP OPERATOR ime_operatorja ( levi_tip | NONE , desni_tip | NONE ) [ CASCADE | RESTRICT ]DROP RULE ime_pravila ON ime_relacije [ CASCADE | RESTRICT ]DROP SCHEMA ime_sheme [, ...] [ CASCADE | RESTRICT ]DROP SEQUENCE ime_zaporedja [, ...] [ CASCADE | RESTRICT ]DROP TABLE ime_tabele [, ...] [ CASCADE | RESTRICT ]DROP TRIGGER ime_prožilca ON ime_tabele [ CASCADE | RESTRICT ]DROP TYPE ime_tipa [, ...] [ CASCADE | RESTRICT ]DROP USER uporabniško_imeDROP VIEW ime_pogleda [, ...] [ CASCADE | RESTRICT ]DROP [ PROCEDURAL ] LANGUAGE ime_jezika [ CASCADE | RESTRICT ]Podatkovni tipIzpis privzete noge je izključen.Izpis privzete noge je vključen.Privzeta?OpisCiljNajdena ni bila nobena relacija z imenom "%s". Najdena ni bila nobena relacija z OID %s. END [ WORK | TRANSACTION ]EXECUTE ime_načrta [ (parameter [, ...] ) ]EXPLAIN [ ANALYZE ] [ VERBOSE ] stavekKodna tabelaVnesite podatke za kopiranje, zaključene z . Končajte z backslashem in piko (\.) v samostojni vrstici.Razširjen prikaz je izkjučen. Razširjen prikaz je vključen. FETCH [ smer { FROM | IN } ] ime_kurzorja kjer je smer lahko prazna, ali ena izmed vrednosti: NEXT PRIOR FIRST LAST ABSOLUTE število RELATIVE število število ALL FORWARD FORWARD število FORWARD ALL BACKWARD BACKWARD število BACKWARD ALLNeuspeh. Ločitveni niz med polji je "%s". Omejitve po tujem ključu:Oblikovanje FunkcijaGRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,...] | ALL [ PRIVILEGES ] } ON [ TABLE ] ime_tabele [, ...] TO { uporabniško_ime | GROUP ime_skupine | PUBLIC } [, ...] [ WITH GRANT OPTION ] GRANT { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] } ON DATABASE ime_baze [, ...] TO { uporabniško_ime | GROUP ime_skupine | PUBLIC } [, ...] [ WITH GRANT OPTION ] GRANT { EXECUTE | ALL [ PRIVILEGES ] } ON FUNCTION ime_funkcije ([tip, ...]) [, ...] TO { uporabniško_ime | GROUP ime_skupine | PUBLIC } [, ...] [ WITH GRANT OPTION ] GRANT { USAGE | ALL [ PRIVILEGES ] } ON LANGUAGE ime_jezika [, ...] TO { uporabniško_ime | GROUP ime_skupine | PUBLIC } [, ...] [ WITH GRANT OPTION ] GRANT { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] } ON SCHEMA ime_sheme [, ...] TO { uporabniško_ime | GROUP ime_skupine | PUBLIC } [, ...] [ WITH GRANT OPTION ]Splošno Splošne možnosti:INSERT INTO ime_tabele [ ( stolpec [, ...] ) ] { DEFAULT VALUES | VALUES ( { izraz | DEFAULT } [, ...] ) | poizvedba }Implicitno?Indeks "%s.%s"Indeksi:Informativno Deduje odVhod/Izhod Interno imeUkaz \%s ni veljaven. Za pomoč vtipkajte \?. LISTEN imeLOAD 'ime_datoteke'LOCK [ TABLE ] ime_tabele [, ...] [ IN način_zaklepanja MODE ] kjer je način_zaklepanja lahko: ACCESS SHARE | ROW SHARE | ROW EXCLUSIVE | SHARE UPDATE EXCLUSIVE | SHARE | SHARE ROW EXCLUSIVE | EXCLUSIVE | ACCESS EXCLUSIVEJezikVeliki objektiTip levega argumentaSeznam agregatnih funkcijSeznam pretvorb med podatkovnimi tipiSeznam pretvorb med kodnimi tabelamiSeznam podatkovnih tipovSeznam uporabnikovSeznam podatkovnih bazSeznam domenSeznam funkcijSeznam operatorjevSeznam relacijSeznam shemMOVE [ smer { FROM | IN } ] ime_kurzorjaModifikatorModifikatorjiNOTIFY imeImePomoč za "%-.*s" ni na voljo. Za izpis razpoložljive pomoči vpišite "\h" brez dodatnih argumentov. Najdena ni bila nobena ujemajoča relacija. Najdena ni bila nobena relacija. Vrednost NULL bo prikazana kot "%s". ObjektOpisi objektovIzhodna oblika je: %s. LastnikPREPARE ime_načrta [ (podatkovni_tip [, ...] ) ] AS izjavaPostopni izpis je vključen.Postopni izpis se uporablja za prikaz dolgega besedila.Postopni izpis je izključen.Geslo: Predhodna povezava je bila ohranjena Medpomnilnik poizvedb Medpomnilnik poizvedb je prazen.Medpomnilnik poizvedb je bil počiščen.REINDEX { DATABASE | TABLE | INDEX } ime_baze [ FORCE ]RESET ime_parametra RESET ALLREVOKE [ GRANT OPTION FOR ] { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,...] | ALL [ PRIVILEGES ] } ON [ TABLE ] ime_tabele [, ...] FROM { uporabniško_ime | GROUP ime_skupine | PUBLIC } [, ...] [ CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FOR ] { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] } ON DATABASE ime_baze [, ...] FROM { uporabniško_ime | GROUP ime_skupine | PUBLIC } [, ...] [ CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FOR ] { EXECUTE | ALL [ PRIVILEGES ] } ON FUNCTION ime_funkcije ([type, ...]) [, ...] FROM { uporabniško_ime | GROUP ime_skupine | PUBLIC } [, ...] [ CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FOR ] { USAGE | ALL [ PRIVILEGES ] } ON LANGUAGE ime_jezika [, ...] FROM { uporabniško_ime | GROUP ime_skupine | PUBLIC } [, ...] [ CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FOR ] { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] } ON SCHEMA ime_sheme [, ...] FROM { uporabniško_ime | GROUP ime_skupine | PUBLIC } [, ...] [ CASCADE | RESTRICT ]ROLLBACK [ WORK | TRANSACTION ]Ločitveni niz med zapisi (vrsticami) je "%s". Ločitveni niz med zapisi (vrsticami) je .Tip rezultataTip rezultataTip desnega argumentaPravilaPravila:SELECT [ ALL | DISTINCT [ ON ( izraz [, ...] ) ] ] * | izraz [ AS izhodno_ime ] [, ...] INTO [ TEMPORARY | TEMP ] [ TABLE ] nova_tabela [ FROM from_item [, ...] ] [ WHERE pogoj ] [ GROUP BY izraz [, ...] ] [ HAVING pogoj [, ...] ] [ { UNION | INTERSECT | EXCEPT } [ ALL ] select_stavek ] [ ORDER BY izraz [ ASC | DESC | USING operator ] [, ...] ] [ LIMIT { število | ALL } ] [ OFFSET začetek ] [ FOR UPDATE [ OF ime_tabele [, ...] ] ]SELECT [ ALL | DISTINCT [ ON ( izraz [, ...] ) ] ] * | izraz [ AS izhodno_ime ] [, ...] [ FROM from_item [, ...] ] [ WHERE pogoj ] [ GROUP BY izraz [, ...] ] [ HAVING pogoj [, ...] ] [ { UNION | INTERSECT | EXCEPT } [ ALL ] select_stavek ] [ ORDER BY izraz [ ASC | DESC | USING operator ] [, ...] ] [ LIMIT { število | ALL } ] [ OFFSET začetek ] [ FOR UPDATE [ OF ime_tabele [, ...] ] ] kjer je from_item lahko eden izmed: [ ONLY ] ime_tabele [ * ] [ [ AS ] alias [ ( alias_stolpca [, ...] ) ] ] ( select ) [ AS ] alias [ ( column_alias [, ...] ) ] ime_funkcije ( [ argument [, ...] ] ) [ AS ] alias [ ( alias_stolpca [, ...] | definicija_stolpca [, ...] ) ] ime_funkcije ( [ argument [, ...] ] ) AS ( definicija_stolpca [, ...] ) from_item [ NATURAL ] tip_stika from_item [ ON pogoj_stika | USING ( join_column [, ...] ) ]SET CONSTRAINTS { ALL | ime_omejitve [, ...] } { 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 uporabniško_ime SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT RESET SESSION AUTHORIZATIONSET [ SESSION | LOCAL ] spremenljivka { TO | = } { vrednost | 'vrednost' | DEFAULT } SET [ SESSION | LOCAL ] TIME ZONE { časovni_pas | LOCAL | DEFAULT }SHOW ime SHOW ALLSSL povezava (cipher: %s, bits: %i) START TRANSACTION [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ] [ READ WRITE | READ ONLY ]ShemaZaporedje "%s.%s"Prikazujem samo vrednosti.VelikostVirIzvorna kodaIzvorni tipPosebna relacija "%s.%s"Uspelo. TOAST tabela "%s.%s"TRUNCATE [ TABLE ] ime_tabeleTabelaTabela "%s.%s"Atributi tabele: "%s". Atributi tabele pobrisani. Ciljni tipPovezava s strežnikom je bila izgubljena. Poskušam obnoviti: To je psql %s, PostgreSQL-ov interaktivni terminal. Čas: %.3f ms Merjenje časa je izključeno.Merjenje časa je vključeno.Naslov je "%s". Naslov pobrisan. Prožilci:Za več informacij poskusite "%s --help". Prikaz samih vrednosti je izključen.TipUNLISTEN { ime | * }UPDATE [ ONLY ] ime_tabele SET stolpec = { izraz | DEFAULT } [, ...] [ FROM fromlist ] [ WHERE pogoj ]Uporaba:Če želite zapustiti %s, uporabite "\q". upor. IDUporabniško imeUporabniško ime: VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ ime_tabele ] VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ ime_tabele [ (stolpec [, ...] ) ] ]Pogled "%s.%s"Definicija pogleda: %sOpozorilo: Sintaksa je zastarela. Dobrodošli v %s %s, PostgreSQL-ovem interaktivnem terminalu. Vtipkajte: \copyright za pogoje razširjanja \h za pomoč z SQL ukazi \? za pomoč z internimi "slash" ukazi \g ali zaključite s podpičjem za izvršitev poizvedbe \q za izhod iz programa Zgodovina je bila zapisana v datoteko "%s". Trenutno niste povezani z nobeno bazo podatkov. Sedaj ste povezani kot nov uporabnik "%s". Sedaj ste povezani s podatkovno bazo "%s" kot uporabnik "%s". Sedaj ste povezani s podatkovno bazo "%s". \!: spodletelo \%s: delovnega imenika nisem uspel spremeniti v "%s": %s \%s: prišlo je do napake \%s: odvečni argument "%s" je bil ignoriran \%s: manjka zahtevan argument \connect: %s\copy: %s\copy: podati morate zahtevane argumente \copy: napaka v razlaganju ukaza pri "%s" \copy: napaka v razlaganju ukaza pri koncu vrstice \copy: nepričakovan odziv (%d) \pset: dovoljene oblike izpisa so: unaligned, aligned, html, latex \pset: neznana izbira: %s prekini trenutno transakcijoagregatspremeni definicijo generatorja zaporedjaspremeni bazo podatkovspremeni uporabniški računspremeni vrednost run-time parametraspremeni uporabniško skupinospremeni definicijo pretvorbe med kodnimi tabelamispremeni definicijo domenespremeni definicijo funkcijespremeni definicijo proceduralnega jezikaspremeni definicijo tabelespremeni definicijo prožilcaspremeni definicijo agregatne funkcijespremeni definicijo za operator classzapri kurzorpreuredi vrstni red vrstic podane tabele v skladu s podanim indeksomzberi statistike o bazi podatkovpotrdi trenutno transakcijopovezava s strežnikom je bila izgubljena vsebuje podporo za urejanje ukazne vrsticekopiraj podatke med datoteko in tabelotrenutnega uporabniškega imena ni bilo mogoče izvedeti: %s lokacije domačega imenika ni bilo mogoče izvedeti: %s začasne datoteke "%s" ni bilo mogoče odpreti: %s shranjevanje zgodovine v datoteko "%s" ni uspelo: %s lupine /bin/sh ni bilo mogoče zagnati urejevalnika "%s" ni bilo mogoče zagnati ustvari novo bazo podatkovustvari novo tabelo iz rezultatov poizvedbecreate databaseustvari nove vrstice v tabelipodatkovni tippobriši pripravljeno izjavodefiniraj kurzordefiniraj novo agregatno funkcijodefiniraj novo pretvorbo med podatkovnimi tipi (cast)definiraj nov omejitveni prožilecdefiniraj novo pretvorbo med kodnimi tabelamidefiniraj nov podatkovni tipdefiniraj nov uporabniški račundefiniraj novo domenodefiniraj novo funkcijodefiniraj nov indeksdefiniraj nov operatordefiniraj nov operator classdefiniraj nov proceduralni jezikdefiniraj novo prepisovalno pravilodefiniraj novo shemodefiniraj nov generator zaporedjadefiniraj novo tabelodefiniraj nov prožilecdefiniraj novo uporabniško skupinodefiniraj nov pogleddefiniraj privilegije za dostopdefiniraj ali spremeni komentar objektaizbriši vrstice v tabeliizprazni tabeloizvrši pripravljeno izjavoza tabelo "%s.%s"vsili kontrolno točko v dnevniku transakcijfunkcijapoberi smeti in (ob zahtevi) analiziraj bazo podatkovustvari obvestiloob prireditviindeksneveljaven ukaz \%s čakaj na obvestilonaloži ali ponovno naloži deljeno knjižnicolokalna vtičnicazakleni tabelonemedpomnilnik poizvedb ne obstaja izključenovključenooperatorzmanjkalo je pomnilnika napaka v razlaganju ukaza pri koncu vrstice premakni kurzorpripravi izjavo na izvršitevprimarni ključ, ponovno ustvari indeksodstrani pretvorbo med podatkovnimi tipi (cast)odstrani pretvorbo med kodnimi tabelamiodstrani podatkovni tipodstrani bazo podatkovodstrani uporabniški računodstrani domenoodstrani funkcijoodstrani proceduralni jezikodstrani prepisovalno praviloodstrani shemoodstrani zaporedjeodstrani tabeloodstrani prožilecodstrani uporabniško skupinoodstrani pogledodvzami privilegije za dostopodstrani agregatno funkcijoodstrani indeksodstrani operatorodstrani operator classponastavi vrednost run-time parametra na privzeto vrednostdobi vrstice iz poizvedbe z uporabo kurzorjaizberi vrstice iz tabele ali pogledapravilozaporedjenastavi lastnosti trenutne transakcijenastavi vedenje omejitev znotraj trenutne transakcijenastavi uporabnikov identifikator za trenutno sejo (začasni prevzem vloge drugega uporabnika)prikaži načrt izvajanja za podano izjavoprikaži vrednost run-time parametraposebnozačni transakcijski blokprenehaj čakati na obvestilosuperusersuperuser, create databasetabelaprožilecunikaten, posodobi vrstice v tabelipogled*da