canceled by user \. \. trying to exit copy mode Time: %.3f ms Time: %.3f ms (%02d:%06.3f) '' Column not null generated always as identity extended external t.tgisinternal , true false AS tgisinternal FULL NOTHING Maximum Minimum Start Cache Cycles? Increment .%s; Owned by: %s Sequence "%s.%s" SELECT a.attname , NULL AS attcollation , a.attidentity , a.attgenerated , a.attstorage ORDER BY a.attnum; Unlogged table "%s.%s" Table "%s.%s" View "%s.%s" Materialized view "%s.%s" Unlogged index "%s.%s" Index "%s.%s" Partitioned index "%s.%s" Special relation "%s.%s" TOAST table "%s.%s" Composite type "%s.%s" Foreign table "%s.%s" Partitioned table "%s.%s" ?%c? "%s.%s" Key? Definition Storage Stats target Partition of: %s %s No partition constraint Partition constraint: %s Partition key: %s Owning table: "%s.%s" i.indisvalid, true AS indisvalid, i.indisreplident, false AS indisreplident, primary key, unique, %s, for table "%s.%s" , predicate (%s) , clustered , invalid , deferrable , initially deferred , replica identity i.indisvalid, true as indisvalid, , i.indisreplident , false AS indisreplident , c2.reltablespace Indexes: "%s" PRIMARY KEY, UNIQUE CONSTRAINT, UNIQUE, USING INITIALLY DEFERRED INVALID REPLICA IDENTITY Check constraints: "%s" %s AND conparentid = 0 ORDER BY conname sametable condef ontable Foreign-key constraints: Referenced by: SELECT pol.polname, pol.polpermissive, 't' as polpermissive, Policies: POLICY "%s" AS RESTRICTIVE FOR %s TO %s USING (%s) WITH CHECK (%s) stxstattarget -1 AS stxstattarget Statistics objects: "%s"."%s" ( ndistinct %sdependencies %smcv ) ON %s FROM %s ; STATISTICS %s Rules: Disabled rules: Rules firing always: Rules firing on replica only: %s Publications: View definition: NULL AS parent ORDER BY 1; Triggers: Disabled user triggers: Disabled triggers: Disabled internal triggers: Triggers firing always: TRIGGER , ON TABLE %s Server: %s FDW options: (%s) Inherits %s: %s %*s %s Number of partitions: %d Partitions Child tables , PARTITIONED Typed table of type: %s pg_catalog Replica Identity Has OIDs: yes Access method: %s Options BEGIN create unique concurrently alter ) s(name, tp, tpm) could not write COPY data: %m COPY data transfer failed: %s no rows returned for \gset %ld STATEMENT: %s RELEASE CLOSE _psql_cursor (null) INSERT unrecognized signal \copy: arguments required .,() binary from program pstdin pstdout \copy: parse error at "%s" could not stat file "%s": %m COPY FROM STDIN TO STDOUT command not executable command not found Index FROM pg_catalog.pg_am List of access methods Location spcacl , spcoptions AS "%s" Size spcname List of tablespaces anptwS+ window Volatility volatile stable immutable Parallel unsafe restricted Security invoker definer , p.proacl Source code Language p.prokind <> 'a' NOT p.proisagg AND p.prokind <> 'p' p.prokind <> 'w' NOT p.proiswindow WHERE ( p.prokind = 'a' OR p.prokind = 'p' p.prokind = 'w' ) List of functions Internal name ORDER BY e.oid Elements WHERE (t.typrelid = 0 AND t.typname !~ '^_' List of data types Right arg type Left arg type Result type o.oprcode AS "%s", o.oprname ORDER BY 1, 2, 3, 4; List of operators Encoding d.datacl Tablespace , t.spcname as "%s" List of databases partitioned table c.relacl Column privileges Policies d.defaclacl ORDER BY 1, 2, 3; Default access privileges Object table constraint pgc.conname domain constraint opf.opfname r.rulename t.tgname Object descriptions o.opcname ORDER BY 2, 3; Did not find any relations. , r.rolreplication , r.rolbypassrls FROM pg_catalog.pg_roles r WHERE r.rolname !~ '^pg_' u.usename List of roles Role name Attributes Member of Superuser No inheritance Create role Create DB Cannot login Replication Bypass RLS No connections %d connections %d connection Password valid until partitioned index special , c2.relname as "%s" Persistence unlogged temporary permanent WHERE c.relkind IN ( 'r','p', 'v', 'm', 'i','I', 'S', 's', 'f', ORDER BY 1,2; List of relations "Parent name" NULLS FIRST, "Type" DESC, List of partitioned indexes List of partitioned tables List of partitioned relations Parent name Leaf partition size , s.dps as "%s" Total size , s.tps as "%s" AND NOT c.relispartition Method Start parse Get token types Get headline End parse Get next token Text search parser "%s.%s" Text search parser "%s" Token name Token types for parser "%s" ORDER BY 3, 2; Dictionaries Token Parser: "%s.%s" Parser: "%s" more than one row returned for \gset attempt to \gset into specially treated variable "%s" ignored Enter data to be copied followed by a newline. End with a backslash and a period on a line by itself, or an EOF signal. aborted because of read failure \crosstabview: column number %d is out of range 1..%d \crosstabview: ambiguous column name: "%s" \crosstabview: column name not found: "%s" Time: %.3f ms (%02d:%02d:%06.3f) Time: %.3f ms (%.0f d %02d:%02d:%06.3f) pg_catalog.array_to_string(c.reloptions || array(select 'toast.' || x from pg_catalog.unnest(tc.reloptions) x), ', ') pg_catalog.array_to_string(reloptions, E', ') generated by default as identity t.tgconstraint <> 0 AS tgisinternal SELECT c.relchecks, c.relkind, c.relhasindex, c.relhasrules, c.relhastriggers, c.relrowsecurity, c.relforcerowsecurity, false AS relhasoids, c.relispartition, %s, c.reltablespace, CASE WHEN c.reloftype = 0 THEN '' ELSE c.reloftype::pg_catalog.regtype::pg_catalog.text END, c.relpersistence, c.relreplident, am.amname FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_class tc ON (c.reltoastrelid = tc.oid) LEFT JOIN pg_catalog.pg_am am ON (c.relam = am.oid) WHERE c.oid = '%s'; SELECT c.relchecks, c.relkind, c.relhasindex, c.relhasrules, c.relhastriggers, c.relrowsecurity, c.relforcerowsecurity, c.relhasoids, c.relispartition, %s, c.reltablespace, CASE WHEN c.reloftype = 0 THEN '' ELSE c.reloftype::pg_catalog.regtype::pg_catalog.text END, c.relpersistence, c.relreplident FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_class tc ON (c.reltoastrelid = tc.oid) WHERE c.oid = '%s'; SELECT c.relchecks, c.relkind, c.relhasindex, c.relhasrules, c.relhastriggers, c.relrowsecurity, c.relforcerowsecurity, c.relhasoids, false as relispartition, %s, c.reltablespace, CASE WHEN c.reloftype = 0 THEN '' ELSE c.reloftype::pg_catalog.regtype::pg_catalog.text END, c.relpersistence, c.relreplident FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_class tc ON (c.reltoastrelid = tc.oid) WHERE c.oid = '%s'; SELECT c.relchecks, c.relkind, c.relhasindex, c.relhasrules, c.relhastriggers, false, false, c.relhasoids, false as relispartition, %s, c.reltablespace, CASE WHEN c.reloftype = 0 THEN '' ELSE c.reloftype::pg_catalog.regtype::pg_catalog.text END, c.relpersistence, c.relreplident FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_class tc ON (c.reltoastrelid = tc.oid) WHERE c.oid = '%s'; SELECT c.relchecks, c.relkind, c.relhasindex, c.relhasrules, c.relhastriggers, false, false, c.relhasoids, false as relispartition, %s, c.reltablespace, CASE WHEN c.reloftype = 0 THEN '' ELSE c.reloftype::pg_catalog.regtype::pg_catalog.text END, c.relpersistence FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_class tc ON (c.reltoastrelid = tc.oid) WHERE c.oid = '%s'; SELECT c.relchecks, c.relkind, c.relhasindex, c.relhasrules, c.relhastriggers, false, false, c.relhasoids, false as relispartition, %s, c.reltablespace, CASE WHEN c.reloftype = 0 THEN '' ELSE c.reloftype::pg_catalog.regtype::pg_catalog.text END FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_class tc ON (c.reltoastrelid = tc.oid) WHERE c.oid = '%s'; SELECT c.relchecks, c.relkind, c.relhasindex, c.relhasrules, c.relhastriggers, false, false, c.relhasoids, false as relispartition, %s, c.reltablespace FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_class tc ON (c.reltoastrelid = tc.oid) WHERE c.oid = '%s'; SELECT relchecks, relkind, relhasindex, relhasrules, reltriggers <> 0, false, false, relhasoids, false as relispartition, %s, reltablespace FROM pg_catalog.pg_class WHERE oid = '%s'; SELECT relchecks, relkind, relhasindex, relhasrules, reltriggers <> 0, false, false, relhasoids, false as relispartition, '', reltablespace FROM pg_catalog.pg_class WHERE oid = '%s'; SELECT relchecks, relkind, relhasindex, relhasrules, reltriggers <> 0, false, false, relhasoids, false as relispartition, '', '' FROM pg_catalog.pg_class WHERE oid = '%s'; Did not find any relation with OID %s. SELECT pg_catalog.format_type(seqtypid, NULL) AS "%s", seqstart AS "%s", seqmin AS "%s", seqmax AS "%s", seqincrement AS "%s", CASE WHEN seqcycle THEN '%s' ELSE '%s' END AS "%s", seqcache AS "%s" FROM pg_catalog.pg_sequence WHERE seqrelid = '%s'; SELECT 'bigint' AS "%s", start_value AS "%s", min_value AS "%s", max_value AS "%s", increment_by AS "%s", CASE WHEN is_cycled THEN '%s' ELSE '%s' END AS "%s", cache_value AS "%s" SELECT pg_catalog.quote_ident(nspname) || '.' || pg_catalog.quote_ident(relname) || '.' || pg_catalog.quote_ident(attname), d.deptype FROM pg_catalog.pg_class c INNER JOIN pg_catalog.pg_depend d ON c.oid=d.refobjid INNER JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace INNER JOIN pg_catalog.pg_attribute a ON ( a.attrelid=c.oid AND a.attnum=d.refobjsubid) WHERE d.classid='pg_catalog.pg_class'::pg_catalog.regclass AND d.refclassid='pg_catalog.pg_class'::pg_catalog.regclass AND d.objid='%s' AND d.deptype IN ('a', 'i') Sequence for identity column: %s , pg_catalog.format_type(a.atttypid, a.atttypmod) , (SELECT pg_catalog.pg_get_expr(d.adbin, d.adrelid, true) FROM pg_catalog.pg_attrdef d WHERE d.adrelid = a.attrelid AND d.adnum = a.attnum AND a.atthasdef), a.attnotnull , (SELECT c.collname FROM pg_catalog.pg_collation c, pg_catalog.pg_type t WHERE c.oid = a.attcollation AND t.oid = a.atttypid AND a.attcollation <> t.typcollation) AS attcollation , ''::pg_catalog.char AS attidentity , ''::pg_catalog.char AS attgenerated , CASE WHEN a.attnum <= (SELECT i.indnkeyatts FROM pg_catalog.pg_index i WHERE i.indexrelid = '%s') THEN '%s' ELSE '%s' END AS is_key , pg_catalog.pg_get_indexdef(a.attrelid, a.attnum, TRUE) AS indexdef , CASE WHEN attfdwoptions IS NULL THEN '' ELSE '(' || pg_catalog.array_to_string(ARRAY(SELECT pg_catalog.quote_ident(option_name) || ' ' || pg_catalog.quote_literal(option_value) FROM pg_catalog.pg_options_to_table(attfdwoptions)), ', ') || ')' END AS attfdwoptions , CASE WHEN a.attstattarget=-1 THEN NULL ELSE a.attstattarget END AS attstattarget , pg_catalog.col_description(a.attrelid, a.attnum) FROM pg_catalog.pg_attribute a WHERE a.attrelid = '%s' AND a.attnum > 0 AND NOT a.attisdropped Unlogged materialized view "%s.%s" Unlogged partitioned index "%s.%s" Unlogged partitioned table "%s.%s" generated always as (%s) stored SELECT inhparent::pg_catalog.regclass, pg_catalog.pg_get_expr(c.relpartbound, c.oid) , pg_catalog.pg_get_partition_constraintdef(c.oid) FROM pg_catalog.pg_class c JOIN pg_catalog.pg_inherits i ON c.oid = inhrelid WHERE c.oid = '%s'; SELECT pg_catalog.pg_get_partkeydef('%s'::pg_catalog.oid); SELECT n.nspname, c.relname FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE reltoastrelid = '%s'; SELECT i.indisunique, i.indisprimary, i.indisclustered, (NOT i.indimmediate) AND EXISTS (SELECT 1 FROM pg_catalog.pg_constraint WHERE conrelid = i.indrelid AND conindid = i.indexrelid AND contype IN ('p','u','x') AND condeferrable) AS condeferrable, (NOT i.indimmediate) AND EXISTS (SELECT 1 FROM pg_catalog.pg_constraint WHERE conrelid = i.indrelid AND conindid = i.indexrelid AND contype IN ('p','u','x') AND condeferred) AS condeferred, false AS condeferrable, false AS condeferred, a.amname, c2.relname, pg_catalog.pg_get_expr(i.indpred, i.indrelid, true) FROM pg_catalog.pg_index i, pg_catalog.pg_class c, pg_catalog.pg_class c2, pg_catalog.pg_am a WHERE i.indexrelid = c.oid AND c.oid = '%s' AND c.relam = a.oid AND i.indrelid = c2.oid; SELECT c2.relname, i.indisprimary, i.indisunique, i.indisclustered, pg_catalog.pg_get_indexdef(i.indexrelid, 0, true), pg_catalog.pg_get_constraintdef(con.oid, true), contype, condeferrable, condeferred null AS constraintdef, null AS contype, false AS condeferrable, false AS condeferred FROM pg_catalog.pg_class c, pg_catalog.pg_class c2, pg_catalog.pg_index i LEFT JOIN pg_catalog.pg_constraint con ON (conrelid = i.indrelid AND conindid = i.indexrelid AND contype IN ('p','u','x')) WHERE c.oid = '%s' AND c.oid = i.indrelid AND i.indexrelid = c2.oid ORDER BY i.indisprimary DESC, c2.relname; SELECT r.conname, pg_catalog.pg_get_constraintdef(r.oid, true) FROM pg_catalog.pg_constraint r WHERE r.conrelid = '%s' AND r.contype = 'c' ORDER BY 1; SELECT conrelid = '%s'::pg_catalog.regclass AS sametable, conname, pg_catalog.pg_get_constraintdef(oid, true) AS condef, conrelid::pg_catalog.regclass AS ontable FROM pg_catalog.pg_constraint, pg_catalog.pg_partition_ancestors('%s') WHERE conrelid = relid AND contype = 'f' AND conparentid = 0 ORDER BY sametable DESC, conname; SELECT true as sametable, conname, pg_catalog.pg_get_constraintdef(r.oid, true) as condef, conrelid::pg_catalog.regclass AS ontable FROM pg_catalog.pg_constraint r WHERE r.conrelid = '%s' AND r.contype = 'f' TABLE "%s" CONSTRAINT "%s" %s SELECT conname, conrelid::pg_catalog.regclass AS ontable, pg_catalog.pg_get_constraintdef(oid, true) AS condef FROM pg_catalog.pg_constraint c WHERE confrelid IN (SELECT pg_catalog.pg_partition_ancestors('%s') UNION ALL VALUES ('%s'::pg_catalog.regclass)) AND contype = 'f' AND conparentid = 0 ORDER BY conname; SELECT conname, conrelid::pg_catalog.regclass AS ontable, pg_catalog.pg_get_constraintdef(oid, true) AS condef FROM pg_catalog.pg_constraint WHERE confrelid = %s AND contype = 'f' ORDER BY conname; CASE WHEN pol.polroles = '{0}' THEN NULL ELSE pg_catalog.array_to_string(array(select rolname from pg_catalog.pg_roles where oid = any (pol.polroles) order by 1),',') END, pg_catalog.pg_get_expr(pol.polqual, pol.polrelid), pg_catalog.pg_get_expr(pol.polwithcheck, pol.polrelid), CASE pol.polcmd WHEN 'r' THEN 'SELECT' WHEN 'a' THEN 'INSERT' WHEN 'w' THEN 'UPDATE' WHEN 'd' THEN 'DELETE' END AS cmd FROM pg_catalog.pg_policy pol WHERE pol.polrelid = '%s' ORDER BY 1; Policies (forced row security enabled): Policies (row security enabled): (none) Policies (forced row security enabled): (none) Policies (row security disabled): SELECT oid, stxrelid::pg_catalog.regclass, stxnamespace::pg_catalog.regnamespace AS nsp, stxname, (SELECT pg_catalog.string_agg(pg_catalog.quote_ident(attname),', ') FROM pg_catalog.unnest(stxkeys) s(attnum) JOIN pg_catalog.pg_attribute a ON (stxrelid = a.attrelid AND a.attnum = s.attnum AND NOT attisdropped)) AS columns, 'd' = any(stxkind) AS ndist_enabled, 'f' = any(stxkind) AS deps_enabled, 'm' = any(stxkind) AS mcv_enabled, FROM pg_catalog.pg_statistic_ext stat WHERE stxrelid = '%s' ORDER BY 1; SELECT r.rulename, trim(trailing ';' from pg_catalog.pg_get_ruledef(r.oid, true)), ev_enabled FROM pg_catalog.pg_rewrite r WHERE r.ev_class = '%s' ORDER BY 1; SELECT r.rulename, trim(trailing ';' from pg_catalog.pg_get_ruledef(r.oid, true)), 'O' AS ev_enabled FROM pg_catalog.pg_rewrite r WHERE r.ev_class = '%s' ORDER BY 1; SELECT pubname FROM pg_catalog.pg_publication p JOIN pg_catalog.pg_publication_rel pr ON p.oid = pr.prpubid WHERE pr.prrelid = '%s' UNION ALL SELECT pubname FROM pg_catalog.pg_publication p WHERE p.puballtables AND pg_catalog.pg_relation_is_publishable('%s') ORDER BY 1; SELECT pg_catalog.pg_get_viewdef('%s'::pg_catalog.oid, true); SELECT r.rulename, trim(trailing ';' from pg_catalog.pg_get_ruledef(r.oid, true)) FROM pg_catalog.pg_rewrite r WHERE r.ev_class = '%s' AND r.rulename != '_RETURN' ORDER BY 1; SELECT t.tgname, pg_catalog.pg_get_triggerdef(t.oid%s), t.tgenabled, %s, CASE WHEN t.tgparentid != 0 THEN (SELECT u.tgrelid::pg_catalog.regclass FROM pg_catalog.pg_trigger AS u, pg_catalog.pg_partition_ancestors(t.tgrelid) WITH ORDINALITY AS a(relid, depth) WHERE u.tgname = t.tgname AND u.tgrelid = a.relid AND u.tgparentid = 0 ORDER BY a.depth LIMIT 1) END AS parent FROM pg_catalog.pg_trigger t WHERE t.tgrelid = '%s' AND (NOT t.tgisinternal OR (t.tgisinternal AND t.tgenabled = 'D') OR EXISTS (SELECT 1 FROM pg_catalog.pg_depend WHERE objid = t.oid AND refclassid = 'pg_catalog.pg_trigger'::pg_catalog.regclass)) (NOT t.tgisinternal OR (t.tgisinternal AND t.tgenabled = 'D')) (t.tgconstraint = 0 OR (t.tgconstraint <> 0 AND t.tgenabled = 'D')) (NOT tgisconstraint OR NOT EXISTS (SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = t.tableoid AND d.objid = t.oid AND d.deptype = 'i' AND c.contype = 'f')) Triggers firing on replica only: SELECT s.srvname, pg_catalog.array_to_string(ARRAY( SELECT pg_catalog.quote_ident(option_name) || ' ' || pg_catalog.quote_literal(option_value) FROM pg_catalog.pg_options_to_table(ftoptions)), ', ') FROM pg_catalog.pg_foreign_table f, pg_catalog.pg_foreign_server s WHERE f.ftrelid = '%s' AND s.oid = f.ftserver; SELECT c.oid::pg_catalog.regclass FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i WHERE c.oid = i.inhparent AND i.inhrelid = '%s' AND c.relkind != 'p' AND c.relkind != 'I' ORDER BY inhseqno; SELECT c.oid::pg_catalog.regclass, c.relkind, pg_catalog.pg_get_expr(c.relpartbound, c.oid) FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i WHERE c.oid = i.inhrelid AND i.inhparent = '%s' ORDER BY pg_catalog.pg_get_expr(c.relpartbound, c.oid) = 'DEFAULT', c.oid::pg_catalog.regclass::pg_catalog.text; SELECT c.oid::pg_catalog.regclass, c.relkind, NULL FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i WHERE c.oid = i.inhrelid AND i.inhparent = '%s' ORDER BY c.oid::pg_catalog.regclass::pg_catalog.text; SELECT c.oid::pg_catalog.regclass, c.relkind, NULL FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i WHERE c.oid = i.inhrelid AND i.inhparent = '%s' ORDER BY c.relname; Number of partitions: %d (Use \d+ to list them.) Number of child tables: %d (Use \d+ to list them.) ROLLBACK TO pg_psql_temporary_savepoint RELEASE pg_psql_temporary_savepoint ***(Single step mode: verify command)******************************************* %s ***(press return to proceed or enter x and return to cancel)******************** The server (version %s) does not support savepoints for ON_ERROR_ROLLBACK. SAVEPOINT pg_psql_temporary_savepoint SELECT name AS "%s", pg_catalog.format_type(tp, tpm) AS "%s" FROM (VALUES (%s, '%u'::pg_catalog.oid, %d) The command has no result, or the result has no columns. unexpected COPY_IN result, aborting connection DECLARE _psql_cursor NO SCROLL CURSOR FOR %s FETCH FORWARD %d FROM _psql_cursor unexpected transaction status (%d) Asynchronous notification "%s" with payload "%s" received from server process with PID %d. Asynchronous notification "%s" received from server process with PID %d. \crosstabview: statement did not return a result set \crosstabview: query must return at least three columns \crosstabview: vertical and horizontal headers must be different columns \crosstabview: data column must be specified when query returns more than three columns \crosstabview: maximum number of columns (%d) exceeded \crosstabview: query result contains multiple data values for row "%s", column "%s" could not print result table: %m \copy: parse error at end of line could not execute command "%s": %m %s: cannot copy from/to a directory could not close pipe to external command: %m child process exited with exit code %d child process was terminated by signal %d: %s child process exited with unrecognized status %d The server (version %s) does not support access methods. SELECT amname AS "%s", CASE amtype WHEN 'i' THEN '%s' WHEN 't' THEN '%s' END AS "%s" , amhandler AS "%s", pg_catalog.obj_description(oid, 'pg_am') AS "%s" The server (version %s) does not support tablespaces. SELECT spcname AS "%s", pg_catalog.pg_get_userbyid(spcowner) AS "%s", pg_catalog.pg_tablespace_location(oid) AS "%s" SELECT spcname AS "%s", pg_catalog.pg_get_userbyid(spcowner) AS "%s", spclocation AS "%s" , pg_catalog.pg_size_pretty(pg_catalog.pg_tablespace_size(oid)) AS "%s" , pg_catalog.shobj_description(oid, 'pg_tablespace') AS "%s" FROM pg_catalog.pg_tablespace \df only takes [anptwS+] as options \df does not take a "%c" option with server version %s SELECT n.nspname as "%s", p.proname as "%s", pg_catalog.pg_get_function_result(p.oid) as "%s", pg_catalog.pg_get_function_arguments(p.oid) as "%s", CASE p.prokind WHEN 'a' THEN '%s' WHEN 'w' THEN '%s' WHEN 'p' THEN '%s' ELSE '%s' END as "%s" pg_catalog.pg_get_function_result(p.oid) as "%s", pg_catalog.pg_get_function_arguments(p.oid) as "%s", CASE WHEN p.proisagg THEN '%s' WHEN p.proiswindow THEN '%s' WHEN p.prorettype = 'pg_catalog.trigger'::pg_catalog.regtype THEN '%s' ELSE '%s' END as "%s" CASE WHEN p.proretset THEN 'SETOF ' ELSE '' END || pg_catalog.format_type(p.prorettype, NULL) as "%s", CASE WHEN proallargtypes IS NOT NULL THEN pg_catalog.array_to_string(ARRAY( SELECT CASE WHEN p.proargmodes[s.i] = 'i' THEN '' WHEN p.proargmodes[s.i] = 'o' THEN 'OUT ' WHEN p.proargmodes[s.i] = 'b' THEN 'INOUT ' WHEN p.proargmodes[s.i] = 'v' THEN 'VARIADIC ' END || CASE WHEN COALESCE(p.proargnames[s.i], '') = '' THEN '' ELSE p.proargnames[s.i] || ' ' END || pg_catalog.format_type(p.proallargtypes[s.i], NULL) FROM pg_catalog.generate_series(1, pg_catalog.array_upper(p.proallargtypes, 1)) AS s(i) ), ', ') ELSE pg_catalog.array_to_string(ARRAY( SELECT CASE WHEN COALESCE(p.proargnames[s.i+1], '') = '' THEN '' ELSE p.proargnames[s.i+1] || ' ' END || pg_catalog.format_type(p.proargtypes[s.i], NULL) FROM pg_catalog.generate_series(0, pg_catalog.array_upper(p.proargtypes, 1)) AS s(i) ), ', ') END AS "%s", CASE WHEN p.proisagg THEN '%s' WHEN p.prorettype = 'pg_catalog.trigger'::pg_catalog.regtype THEN '%s' ELSE '%s' END AS "%s" CASE WHEN p.proretset THEN 'SETOF ' ELSE '' END || pg_catalog.format_type(p.prorettype, NULL) as "%s", pg_catalog.oidvectortypes(p.proargtypes) as "%s", CASE WHEN p.proisagg THEN '%s' WHEN p.prorettype = 'pg_catalog.trigger'::pg_catalog.regtype THEN '%s' ELSE '%s' END AS "%s" , CASE WHEN p.provolatile = 'i' THEN '%s' WHEN p.provolatile = 's' THEN '%s' WHEN p.provolatile = 'v' THEN '%s' END as "%s" , CASE WHEN p.proparallel = 'r' THEN '%s' WHEN p.proparallel = 's' THEN '%s' WHEN p.proparallel = 'u' THEN '%s' END as "%s" , pg_catalog.pg_get_userbyid(p.proowner) as "%s", CASE WHEN prosecdef THEN '%s' ELSE '%s' END AS "%s" , l.lanname as "%s", p.prosrc as "%s", pg_catalog.obj_description(p.oid, 'pg_proc') as "%s" FROM pg_catalog.pg_proc p LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace LEFT JOIN pg_catalog.pg_language l ON l.oid = p.prolang p.prorettype <> 'pg_catalog.trigger'::pg_catalog.regtype p.prorettype = 'pg_catalog.trigger'::pg_catalog.regtype SELECT n.nspname as "%s", pg_catalog.format_type(t.oid, NULL) AS "%s", t.typname AS "%s", CASE WHEN t.typrelid != 0 THEN CAST('tuple' AS pg_catalog.text) WHEN t.typlen < 0 THEN CAST('var' AS pg_catalog.text) ELSE CAST(t.typlen AS pg_catalog.text) END AS "%s", pg_catalog.array_to_string( ARRAY( SELECT e.enumlabel FROM pg_catalog.pg_enum e WHERE e.enumtypid = t.oid ORDER BY e.enumsortorder ), E'\n' ) AS "%s", pg_catalog.obj_description(t.oid, 'pg_type') as "%s" FROM pg_catalog.pg_type t LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace OR (SELECT c.relkind = 'c' FROM pg_catalog.pg_class c WHERE c.oid = t.typrelid)) AND NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type el WHERE el.oid = t.typelem AND el.typarray = t.oid) pg_catalog.pg_get_userbyid(t.typowner) AS "%s", SELECT n.nspname as "%s", o.oprname AS "%s", CASE WHEN o.oprkind='l' THEN NULL ELSE pg_catalog.format_type(o.oprleft, NULL) END AS "%s", CASE WHEN o.oprkind='r' THEN NULL ELSE pg_catalog.format_type(o.oprright, NULL) END AS "%s", pg_catalog.format_type(o.oprresult, NULL) AS "%s", coalesce(pg_catalog.obj_description(o.oid, 'pg_operator'), pg_catalog.obj_description(o.oprcode, 'pg_proc')) AS "%s" FROM pg_catalog.pg_operator o LEFT JOIN pg_catalog.pg_namespace n ON n.oid = o.oprnamespace WHERE n.nspname <> 'pg_catalog' AND n.nspname <> 'information_schema' pg_catalog.pg_operator_is_visible(o.oid) SELECT d.datname as "%s", pg_catalog.pg_get_userbyid(d.datdba) as "%s", pg_catalog.pg_encoding_to_char(d.encoding) as "%s", d.datcollate as "%s", d.datctype as "%s", , CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT') THEN pg_catalog.pg_size_pretty(pg_catalog.pg_database_size(d.datname)) ELSE 'No Access' END as "%s" , pg_catalog.shobj_description(d.oid, 'pg_database') as "%s" JOIN pg_catalog.pg_tablespace t on d.dattablespace = t.oid FROM pg_catalog.pg_database d SELECT n.nspname as "%s", c.relname as "%s", CASE c.relkind WHEN 'r' THEN '%s' WHEN 'v' THEN '%s' WHEN 'm' THEN '%s' WHEN 'S' THEN '%s' WHEN 'f' THEN '%s' WHEN 'p' THEN '%s' END as "%s", , pg_catalog.array_to_string(ARRAY( SELECT attname || E':\n ' || pg_catalog.array_to_string(attacl, E'\n ') FROM pg_catalog.pg_attribute a WHERE attrelid = c.oid AND NOT attisdropped AND attacl IS NOT NULL ), E'\n') AS "%s" , pg_catalog.array_to_string(ARRAY( SELECT polname || CASE WHEN polcmd != '*' THEN E' (' || polcmd || E'):' ELSE E':' END || CASE WHEN polqual IS NOT NULL THEN E'\n (u): ' || pg_catalog.pg_get_expr(polqual, polrelid) ELSE E'' END || CASE WHEN polwithcheck IS NOT NULL THEN E'\n (c): ' || pg_catalog.pg_get_expr(polwithcheck, polrelid) ELSE E'' END || CASE WHEN polroles <> '{0}' THEN E'\n to: ' || pg_catalog.array_to_string( ARRAY( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = ANY (polroles) ORDER BY 1 ), E', ') ELSE E'' END FROM pg_catalog.pg_policy pol WHERE polrelid = c.oid), E'\n') AS "%s" , pg_catalog.array_to_string(ARRAY( SELECT polname || CASE WHEN NOT polpermissive THEN E' (RESTRICTIVE)' ELSE '' END || CASE WHEN polcmd != '*' THEN E' (' || polcmd || E'):' ELSE E':' END || CASE WHEN polqual IS NOT NULL THEN E'\n (u): ' || pg_catalog.pg_get_expr(polqual, polrelid) ELSE E'' END || CASE WHEN polwithcheck IS NOT NULL THEN E'\n (c): ' || pg_catalog.pg_get_expr(polwithcheck, polrelid) ELSE E'' END || CASE WHEN polroles <> '{0}' THEN E'\n to: ' || pg_catalog.array_to_string( ARRAY( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = ANY (polroles) ORDER BY 1 ), E', ') ELSE E'' END FROM pg_catalog.pg_policy pol WHERE polrelid = c.oid), E'\n') AS "%s" FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('r','v','m','S','f','p') n.nspname !~ '^pg_' AND pg_catalog.pg_table_is_visible(c.oid) The server (version %s) does not support altering default privileges. SELECT pg_catalog.pg_get_userbyid(d.defaclrole) AS "%s", n.nspname AS "%s", CASE d.defaclobjtype WHEN '%c' THEN '%s' WHEN '%c' THEN '%s' WHEN '%c' THEN '%s' WHEN '%c' THEN '%s' WHEN '%c' THEN '%s' END AS "%s", FROM pg_catalog.pg_default_acl d LEFT JOIN pg_catalog.pg_namespace n ON n.oid = d.defaclnamespace pg_catalog.pg_get_userbyid(d.defaclrole) SELECT DISTINCT tt.nspname AS "%s", tt.name AS "%s", tt.object AS "%s", d.description AS "%s" FROM ( SELECT pgc.oid as oid, pgc.tableoid AS tableoid, n.nspname as nspname, CAST(pgc.conname AS pg_catalog.text) as name, CAST('%s' AS pg_catalog.text) as object FROM pg_catalog.pg_constraint pgc JOIN pg_catalog.pg_class c ON c.oid = pgc.conrelid LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace UNION ALL SELECT pgc.oid as oid, pgc.tableoid AS tableoid, n.nspname as nspname, CAST(pgc.conname AS pg_catalog.text) as name, CAST('%s' AS pg_catalog.text) as object FROM pg_catalog.pg_constraint pgc JOIN pg_catalog.pg_type t ON t.oid = pgc.contypid LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace UNION ALL SELECT opf.oid as oid, opf.tableoid as tableoid, n.nspname as nspname, CAST(opf.opfname AS pg_catalog.text) AS name, CAST('%s' AS pg_catalog.text) as object FROM pg_catalog.pg_opfamily opf JOIN pg_catalog.pg_am am ON opf.opfmethod = am.oid JOIN pg_catalog.pg_namespace n ON opf.opfnamespace = n.oid pg_catalog.pg_opfamily_is_visible(opf.oid) UNION ALL SELECT r.oid as oid, r.tableoid as tableoid, n.nspname as nspname, CAST(r.rulename AS pg_catalog.text) as name, CAST('%s' AS pg_catalog.text) as object FROM pg_catalog.pg_rewrite r JOIN pg_catalog.pg_class c ON c.oid = r.ev_class LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE r.rulename != '_RETURN' UNION ALL SELECT t.oid as oid, t.tableoid as tableoid, n.nspname as nspname, CAST(t.tgname AS pg_catalog.text) as name, CAST('%s' AS pg_catalog.text) as object FROM pg_catalog.pg_trigger t JOIN pg_catalog.pg_class c ON c.oid = t.tgrelid LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace ) AS tt JOIN pg_catalog.pg_description d ON (tt.oid = d.objoid AND tt.tableoid = d.classoid AND d.objsubid = 0) UNION ALL SELECT o.oid as oid, o.tableoid as tableoid, n.nspname as nspname, CAST(o.opcname AS pg_catalog.text) as name, CAST('%s' AS pg_catalog.text) as object FROM pg_catalog.pg_opclass o JOIN pg_catalog.pg_am am ON o.opcmethod = am.oid JOIN pg_catalog.pg_namespace n ON n.oid = o.opcnamespace pg_catalog.pg_opclass_is_visible(o.oid) SELECT c.oid, n.nspname, c.relname FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace Did not find any relation named "%s". SELECT r.rolname, r.rolsuper, r.rolinherit, r.rolcreaterole, r.rolcreatedb, r.rolcanlogin, r.rolconnlimit, r.rolvaliduntil, ARRAY(SELECT b.rolname FROM pg_catalog.pg_auth_members m JOIN pg_catalog.pg_roles b ON (m.roleid = b.oid) WHERE m.member = r.oid) as memberof , pg_catalog.shobj_description(r.oid, 'pg_authid') AS description SELECT u.usename AS rolname, u.usesuper AS rolsuper, true AS rolinherit, false AS rolcreaterole, u.usecreatedb AS rolcreatedb, true AS rolcanlogin, -1 AS rolconnlimit, u.valuntil as rolvaliduntil, ARRAY(SELECT g.groname FROM pg_catalog.pg_group g WHERE u.usesysid = ANY(g.grolist)) as memberof FROM pg_catalog.pg_user u SELECT n.nspname as "%s", c.relname as "%s", CASE c.relkind WHEN 'r' THEN '%s' WHEN 'v' THEN '%s' WHEN 'm' THEN '%s' WHEN 'i' THEN '%s' WHEN 'S' THEN '%s' WHEN 's' THEN '%s' WHEN 'f' THEN '%s' WHEN 'p' THEN '%s' WHEN 'I' THEN '%s' END as "%s", pg_catalog.pg_get_userbyid(c.relowner) as "%s" , CASE c.relpersistence WHEN 'p' THEN '%s' WHEN 't' THEN '%s' WHEN 'u' THEN '%s' END as "%s" , pg_catalog.pg_size_pretty(pg_catalog.pg_table_size(c.oid)) as "%s" , pg_catalog.pg_size_pretty(pg_catalog.pg_relation_size(c.oid)) as "%s" , pg_catalog.obj_description(c.oid, 'pg_class') as "%s" FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_catalog.pg_index i ON i.indexrelid = c.oid LEFT JOIN pg_catalog.pg_class c2 ON i.indrelid = c2.oid AND n.nspname !~ '^pg_toast' The server (version %s) does not support declarative table partitioning. SELECT n.nspname as "%s", c.relname as "%s", pg_catalog.pg_get_userbyid(c.relowner) as "%s" , CASE c.relkind WHEN 'p' THEN '%s' WHEN 'I' THEN '%s' END as "%s" , inh.inhparent::pg_catalog.regclass as "%s" , c2.oid::pg_catalog.regclass as "%s" LEFT JOIN pg_catalog.pg_inherits inh ON c.oid = inh.inhrelid , LATERAL (WITH RECURSIVE d AS (SELECT inhrelid AS oid, 1 AS level FROM pg_catalog.pg_inherits WHERE inhparent = c.oid UNION ALL SELECT inhrelid, level + 1 FROM pg_catalog.pg_inherits i JOIN d ON i.inhparent = d.oid) SELECT pg_catalog.pg_size_pretty(sum(pg_catalog.pg_table_size(d.oid))) AS tps, pg_catalog.pg_size_pretty(sum( CASE WHEN d.level = 1 THEN pg_catalog.pg_table_size(d.oid) ELSE 0 END)) AS dps FROM d) s , LATERAL (SELECT pg_catalog.pg_size_pretty(sum( CASE WHEN ppt.isleaf AND ppt.level = 1 THEN pg_catalog.pg_table_size(ppt.relid) ELSE 0 END)) AS dps, pg_catalog.pg_size_pretty(sum(pg_catalog.pg_table_size(ppt.relid))) AS tps FROM pg_catalog.pg_partition_tree(c.oid) ppt) s ORDER BY "Schema", %s%s"Name"; SELECT p.oid, n.nspname, p.prsname FROM pg_catalog.pg_ts_parser p LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.prsnamespace Did not find any text search parser named "%s". Did not find any text search parsers. SELECT '%s' AS "%s", p.prsstart::pg_catalog.regproc AS "%s", pg_catalog.obj_description(p.prsstart, 'pg_proc') as "%s" FROM pg_catalog.pg_ts_parser p WHERE p.oid = '%s' UNION ALL SELECT '%s', p.prstoken::pg_catalog.regproc, pg_catalog.obj_description(p.prstoken, 'pg_proc') FROM pg_catalog.pg_ts_parser p WHERE p.oid = '%s' UNION ALL SELECT '%s', p.prsend::pg_catalog.regproc, pg_catalog.obj_description(p.prsend, 'pg_proc') FROM pg_catalog.pg_ts_parser p WHERE p.oid = '%s' UNION ALL SELECT '%s', p.prsheadline::pg_catalog.regproc, pg_catalog.obj_description(p.prsheadline, 'pg_proc') FROM pg_catalog.pg_ts_parser p WHERE p.oid = '%s' UNION ALL SELECT '%s', p.prslextype::pg_catalog.regproc, pg_catalog.obj_description(p.prslextype, 'pg_proc') FROM pg_catalog.pg_ts_parser p WHERE p.oid = '%s'; SELECT t.alias as "%s", t.description as "%s" FROM pg_catalog.ts_token_type( '%s'::pg_catalog.oid ) as t ORDER BY 1; Token types for parser "%s.%s" SELECT c.oid, c.cfgname, n.nspname, p.prsname, np.nspname as pnspname FROM pg_catalog.pg_ts_config c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.cfgnamespace, pg_catalog.pg_ts_parser p LEFT JOIN pg_catalog.pg_namespace np ON np.oid = p.prsnamespace WHERE p.oid = c.cfgparser Did not find any text search configuration named "%s". Did not find any text search configurations. SELECT ( SELECT t.alias FROM pg_catalog.ts_token_type(c.cfgparser) AS t WHERE t.tokid = m.maptokentype ) AS "%s", pg_catalog.btrim( ARRAY( SELECT mm.mapdict::pg_catalog.regdictionary FROM pg_catalog.pg_ts_config_map AS mm WHERE mm.mapcfg = m.mapcfg AND mm.maptokentype = m.maptokentype ORDER BY mapcfg, maptokentype, mapseqno ) :: pg_catalog.text, '{}') AS "%s" FROM pg_catalog.pg_ts_config AS c, pg_catalog.pg_ts_config_map AS m WHERE c.oid = '%s' AND m.mapcfg = c.oid GROUP BY m.mapcfg, m.maptokentype, c.cfgparser ORDER BY 1; Text search configuration "%s.%s" Text search configuration "%s" *888888888888888888888888888p888888888Q$$$$$h$h$h$ postgres:// postgresql:// N@ 8@ABORT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] ALTER AGGREGATE %s ( %s ) RENAME TO %s ALTER AGGREGATE %s ( %s ) OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER AGGREGATE %s ( %s ) SET SCHEMA %s %s * | [ %s ] [ %s ] %s [ , ... ] | [ [ %s ] [ %s ] %s [ , ... ] ] ORDER BY [ %s ] [ %s ] %s [ , ... ] ALTER COLLATION %s REFRESH VERSION ALTER COLLATION %s RENAME TO %s ALTER COLLATION %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER COLLATION %s SET SCHEMA %s ALTER CONVERSION %s RENAME TO %s ALTER CONVERSION %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER CONVERSION %s SET SCHEMA %s ALTER DATABASE %s [ [ WITH ] %s [ ... ] ] %s ALLOW_CONNECTIONS %s CONNECTION LIMIT %s IS_TEMPLATE %s ALTER DATABASE %s RENAME TO %s ALTER DATABASE %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER DATABASE %s SET TABLESPACE %s ALTER DATABASE %s SET %s { TO | = } { %s | DEFAULT } ALTER DATABASE %s SET %s FROM CURRENT ALTER DATABASE %s RESET %s ALTER DATABASE %s RESET ALL where abbreviated_grant_or_revoke is one of: ALTER DEFAULT PRIVILEGES [ FOR { ROLE | USER } %s [, ...] ] [ IN SCHEMA %s [, ...] ] %s %s GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER } [, ...] | ALL [ PRIVILEGES ] } ON TABLES TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ] GRANT { { USAGE | SELECT | UPDATE } [, ...] | ALL [ PRIVILEGES ] } ON SEQUENCES TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ] GRANT { EXECUTE | ALL [ PRIVILEGES ] } ON { FUNCTIONS | ROUTINES } TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ] GRANT { USAGE | ALL [ PRIVILEGES ] } ON TYPES TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ] GRANT { { USAGE | CREATE } [, ...] | ALL [ PRIVILEGES ] } ON SCHEMAS TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ] REVOKE [ GRANT OPTION FOR ] { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER } [, ...] | ALL [ PRIVILEGES ] } ON TABLES FROM { [ GROUP ] %s | PUBLIC } [, ...] [ CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FOR ] { { USAGE | SELECT | UPDATE } [, ...] | ALL [ PRIVILEGES ] } ON SEQUENCES FROM { [ GROUP ] %s | PUBLIC } [, ...] [ CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FOR ] { EXECUTE | ALL [ PRIVILEGES ] } ON { FUNCTIONS | ROUTINES } FROM { [ GROUP ] %s | PUBLIC } [, ...] [ CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FOR ] { USAGE | ALL [ PRIVILEGES ] } ON TYPES FROM { [ GROUP ] %s | PUBLIC } [, ...] [ CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FOR ] { { USAGE | CREATE } [, ...] | ALL [ PRIVILEGES ] } ON SCHEMAS FROM { [ GROUP ] %s | PUBLIC } [, ...] [ CASCADE | RESTRICT ] ALTER DOMAIN %s { SET DEFAULT %s | DROP DEFAULT } ALTER DOMAIN %s { SET | DROP } NOT NULL ALTER DOMAIN %s ADD %s [ NOT VALID ] ALTER DOMAIN %s DROP CONSTRAINT [ IF EXISTS ] %s [ RESTRICT | CASCADE ] ALTER DOMAIN %s RENAME CONSTRAINT %s TO %s ALTER DOMAIN %s VALIDATE CONSTRAINT %s ALTER DOMAIN %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER DOMAIN %s RENAME TO %s ALTER DOMAIN %s SET SCHEMA %s %s [ CONSTRAINT %s ] { NOT NULL | CHECK (%s) } ALTER EVENT TRIGGER %s DISABLE ALTER EVENT TRIGGER %s ENABLE [ REPLICA | ALWAYS ] ALTER EVENT TRIGGER %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER EVENT TRIGGER %s RENAME TO %s ALTER EXTENSION %s UPDATE [ TO %s ] ALTER EXTENSION %s SET SCHEMA %s ALTER EXTENSION %s ADD %s ALTER EXTENSION %s DROP %s %s ACCESS METHOD %s | AGGREGATE %s ( %s ) | CAST (%s AS %s) | COLLATION %s | CONVERSION %s | DOMAIN %s | EVENT TRIGGER %s | FOREIGN DATA WRAPPER %s | FOREIGN TABLE %s | FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] | MATERIALIZED VIEW %s | OPERATOR %s (%s, %s) | OPERATOR CLASS %s USING %s | OPERATOR FAMILY %s USING %s | [ PROCEDURAL ] LANGUAGE %s | PROCEDURE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] | ROUTINE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] | SCHEMA %s | SEQUENCE %s | SERVER %s | TABLE %s | TEXT SEARCH CONFIGURATION %s | TEXT SEARCH DICTIONARY %s | TEXT SEARCH PARSER %s | TEXT SEARCH TEMPLATE %s | TRANSFORM FOR %s LANGUAGE %s | TYPE %s | VIEW %s %s * | [ %s ] [ %s ] %s [ , ... ] | [ [ %s ] [ %s ] %s [ , ... ] ] ORDER BY [ %s ] [ %s ] %s [ , ... ] ALTER FOREIGN DATA WRAPPER %s [ HANDLER %s | NO HANDLER ] [ VALIDATOR %s | NO VALIDATOR ] [ OPTIONS ( [ ADD | SET | DROP ] %s ['%s'] [, ... ]) ] ALTER FOREIGN DATA WRAPPER %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER FOREIGN DATA WRAPPER %s RENAME TO %s ALTER FOREIGN TABLE [ IF EXISTS ] [ ONLY ] %s [ * ] %s [, ... ] ALTER FOREIGN TABLE [ IF EXISTS ] [ ONLY ] %s [ * ] RENAME [ COLUMN ] %s TO %s ALTER FOREIGN TABLE [ IF EXISTS ] %s RENAME TO %s ALTER FOREIGN TABLE [ IF EXISTS ] %s SET SCHEMA %s %s ADD [ COLUMN ] %s %s [ COLLATE %s ] [ %s [ ... ] ] DROP [ COLUMN ] [ IF EXISTS ] %s [ RESTRICT | CASCADE ] ALTER [ COLUMN ] %s [ SET DATA ] TYPE %s [ COLLATE %s ] ALTER [ COLUMN ] %s SET DEFAULT %s ALTER [ COLUMN ] %s DROP DEFAULT ALTER [ COLUMN ] %s { SET | DROP } NOT NULL ALTER [ COLUMN ] %s SET STATISTICS %s ALTER [ COLUMN ] %s SET ( %s = %s [, ... ] ) ALTER [ COLUMN ] %s RESET ( %s [, ... ] ) ALTER [ COLUMN ] %s SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN } ALTER [ COLUMN ] %s OPTIONS ( [ ADD | SET | DROP ] %s ['%s'] [, ... ]) ADD %s [ NOT VALID ] VALIDATE CONSTRAINT %s DROP CONSTRAINT [ IF EXISTS ] %s [ RESTRICT | CASCADE ] DISABLE TRIGGER [ %s | ALL | USER ] ENABLE TRIGGER [ %s | ALL | USER ] ENABLE REPLICA TRIGGER %s ENABLE ALWAYS TRIGGER %s SET WITHOUT OIDS INHERIT %s NO INHERIT %s OWNER TO { %s | CURRENT_USER | SESSION_USER } OPTIONS ( [ ADD | SET | DROP ] %s ['%s'] [, ... ]) ALTER FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] %s [ ... ] [ RESTRICT ] ALTER FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] RENAME TO %s ALTER FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] SET SCHEMA %s ALTER FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] [ NO ] DEPENDS ON EXTENSION %s %s CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT IMMUTABLE | STABLE | VOLATILE [ NOT ] LEAKPROOF [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER PARALLEL { UNSAFE | RESTRICTED | SAFE } COST %s ROWS %s SUPPORT %s SET %s { TO | = } { %s | DEFAULT } SET %s FROM CURRENT RESET %s RESET ALL where role_specification can be: ALTER GROUP %s ADD USER %s [, ... ] ALTER GROUP %s DROP USER %s [, ... ] %s %s | CURRENT_USER | SESSION_USER ALTER GROUP %s RENAME TO %s ALTER INDEX [ IF EXISTS ] %s RENAME TO %s ALTER INDEX [ IF EXISTS ] %s SET TABLESPACE %s ALTER INDEX %s ATTACH PARTITION %s ALTER INDEX %s [ NO ] DEPENDS ON EXTENSION %s ALTER INDEX [ IF EXISTS ] %s SET ( %s [= %s] [, ... ] ) ALTER INDEX [ IF EXISTS ] %s RESET ( %s [, ... ] ) ALTER INDEX [ IF EXISTS ] %s ALTER [ COLUMN ] %s SET STATISTICS %s ALTER INDEX ALL IN TABLESPACE %s [ OWNED BY %s [, ... ] ] SET TABLESPACE %s [ NOWAIT ] ALTER [ PROCEDURAL ] LANGUAGE %s RENAME TO %s ALTER [ PROCEDURAL ] LANGUAGE %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER LARGE OBJECT %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER MATERIALIZED VIEW [ IF EXISTS ] %s %s [, ... ] ALTER MATERIALIZED VIEW %s [ NO ] DEPENDS ON EXTENSION %s ALTER MATERIALIZED VIEW [ IF EXISTS ] %s RENAME [ COLUMN ] %s TO %s ALTER MATERIALIZED VIEW [ IF EXISTS ] %s RENAME TO %s ALTER MATERIALIZED VIEW [ IF EXISTS ] %s SET SCHEMA %s ALTER MATERIALIZED VIEW ALL IN TABLESPACE %s [ OWNED BY %s [, ... ] ] SET TABLESPACE %s [ NOWAIT ] %s ALTER [ COLUMN ] %s SET STATISTICS %s ALTER [ COLUMN ] %s SET ( %s = %s [, ... ] ) ALTER [ COLUMN ] %s RESET ( %s [, ... ] ) ALTER [ COLUMN ] %s SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN } CLUSTER ON %s SET WITHOUT CLUSTER SET TABLESPACE %s SET ( %s [= %s] [, ... ] ) RESET ( %s [, ... ] ) OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER OPERATOR %s ( { %s | NONE } , { %s | NONE } ) OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER OPERATOR %s ( { %s | NONE } , { %s | NONE } ) SET SCHEMA %s ALTER OPERATOR %s ( { %s | NONE } , { %s | NONE } ) SET ( { RESTRICT = { %s | NONE } | JOIN = { %s | NONE } } [, ... ] ) ALTER OPERATOR CLASS %s USING %s RENAME TO %s ALTER OPERATOR CLASS %s USING %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER OPERATOR CLASS %s USING %s SET SCHEMA %s ALTER OPERATOR FAMILY %s USING %s ADD { OPERATOR %s %s ( %s, %s ) [ FOR SEARCH | FOR ORDER BY %s ] | FUNCTION %s [ ( %s [ , %s ] ) ] %s [ ( %s [, ...] ) ] } [, ... ] ALTER OPERATOR FAMILY %s USING %s DROP { OPERATOR %s ( %s [ , %s ] ) | FUNCTION %s ( %s [ , %s ] ) } [, ... ] ALTER OPERATOR FAMILY %s USING %s RENAME TO %s ALTER OPERATOR FAMILY %s USING %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER OPERATOR FAMILY %s USING %s SET SCHEMA %s ALTER POLICY %s ON %s RENAME TO %s ALTER POLICY %s ON %s [ TO { %s | PUBLIC | CURRENT_USER | SESSION_USER } [, ...] ] [ USING ( %s ) ] [ WITH CHECK ( %s ) ] ALTER PROCEDURE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] %s [ ... ] [ RESTRICT ] ALTER PROCEDURE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] RENAME TO %s ALTER PROCEDURE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER PROCEDURE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] SET SCHEMA %s ALTER PROCEDURE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] [ NO ] DEPENDS ON EXTENSION %s %s [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER SET %s { TO | = } { %s | DEFAULT } SET %s FROM CURRENT RESET %s RESET ALL ALTER PUBLICATION %s ADD TABLE [ ONLY ] %s [ * ] [, ...] ALTER PUBLICATION %s SET TABLE [ ONLY ] %s [ * ] [, ...] ALTER PUBLICATION %s DROP TABLE [ ONLY ] %s [ * ] [, ...] ALTER PUBLICATION %s SET ( %s [= %s] [, ... ] ) ALTER PUBLICATION %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER PUBLICATION %s RENAME TO %s ALTER ROLE %s [ WITH ] %s [ ... ] %s SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHERIT | NOINHERIT | LOGIN | NOLOGIN | REPLICATION | NOREPLICATION | BYPASSRLS | NOBYPASSRLS | CONNECTION LIMIT %s | [ ENCRYPTED ] PASSWORD '%s' | PASSWORD NULL | VALID UNTIL '%s' ALTER ROLE %s RENAME TO %s ALTER ROLE { %s | ALL } [ IN DATABASE %s ] SET %s { TO | = } { %s | DEFAULT } ALTER ROLE { %s | ALL } [ IN DATABASE %s ] SET %s FROM CURRENT ALTER ROLE { %s | ALL } [ IN DATABASE %s ] RESET %s ALTER ROLE { %s | ALL } [ IN DATABASE %s ] RESET ALL %s %s | CURRENT_USER | SESSION_USER ALTER ROUTINE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] %s [ ... ] [ RESTRICT ] ALTER ROUTINE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] RENAME TO %s ALTER ROUTINE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER ROUTINE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] SET SCHEMA %s ALTER ROUTINE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] [ NO ] DEPENDS ON EXTENSION %s %s IMMUTABLE | STABLE | VOLATILE [ NOT ] LEAKPROOF [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER PARALLEL { UNSAFE | RESTRICTED | SAFE } COST %s ROWS %s SET %s { TO | = } { %s | DEFAULT } SET %s FROM CURRENT RESET %s RESET ALL ALTER RULE %s ON %s RENAME TO %s ALTER SCHEMA %s RENAME TO %s ALTER SCHEMA %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER SEQUENCE [ IF EXISTS ] %s [ AS %s ] [ INCREMENT [ BY ] %s ] [ MINVALUE %s | NO MINVALUE ] [ MAXVALUE %s | NO MAXVALUE ] [ START [ WITH ] %s ] [ RESTART [ [ WITH ] %s ] ] [ CACHE %s ] [ [ NO ] CYCLE ] [ OWNED BY { %s.%s | NONE } ] ALTER SEQUENCE [ IF EXISTS ] %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER SEQUENCE [ IF EXISTS ] %s RENAME TO %s ALTER SEQUENCE [ IF EXISTS ] %s SET SCHEMA %s ALTER SERVER %s [ VERSION '%s' ] [ OPTIONS ( [ ADD | SET | DROP ] %s ['%s'] [, ... ] ) ] ALTER SERVER %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER SERVER %s RENAME TO %s ALTER STATISTICS %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER STATISTICS %s RENAME TO %s ALTER STATISTICS %s SET SCHEMA %s ALTER STATISTICS %s SET STATISTICS %s ALTER SUBSCRIPTION %s CONNECTION '%s' ALTER SUBSCRIPTION %s SET PUBLICATION %s [, ...] [ WITH ( %s [= %s] [, ... ] ) ] ALTER SUBSCRIPTION %s REFRESH PUBLICATION [ WITH ( %s [= %s] [, ... ] ) ] ALTER SUBSCRIPTION %s ENABLE ALTER SUBSCRIPTION %s DISABLE ALTER SUBSCRIPTION %s SET ( %s [= %s] [, ... ] ) ALTER SUBSCRIPTION %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER SUBSCRIPTION %s RENAME TO %s ALTER SYSTEM SET %s { TO | = } { %s [, ...] | DEFAULT } ALTER SYSTEM RESET %s ALTER SYSTEM RESET ALL exclude_element in an EXCLUDE constraint is: index_parameters in UNIQUE, PRIMARY KEY, and EXCLUDE constraints are: and table_constraint_using_index is: ALTER TABLE [ IF EXISTS ] [ ONLY ] %s [ * ] %s [, ... ] ALTER TABLE [ IF EXISTS ] [ ONLY ] %s [ * ] RENAME [ COLUMN ] %s TO %s ALTER TABLE [ IF EXISTS ] [ ONLY ] %s [ * ] RENAME CONSTRAINT %s TO %s ALTER TABLE [ IF EXISTS ] %s RENAME TO %s ALTER TABLE [ IF EXISTS ] %s SET SCHEMA %s ALTER TABLE ALL IN TABLESPACE %s [ OWNED BY %s [, ... ] ] SET TABLESPACE %s [ NOWAIT ] ALTER TABLE [ IF EXISTS ] %s ATTACH PARTITION %s { FOR VALUES %s | DEFAULT } ALTER TABLE [ IF EXISTS ] %s DETACH PARTITION %s %s ADD [ COLUMN ] [ IF NOT EXISTS ] %s %s [ COLLATE %s ] [ %s [ ... ] ] DROP [ COLUMN ] [ IF EXISTS ] %s [ RESTRICT | CASCADE ] ALTER [ COLUMN ] %s [ SET DATA ] TYPE %s [ COLLATE %s ] [ USING %s ] ALTER [ COLUMN ] %s SET DEFAULT %s ALTER [ COLUMN ] %s DROP DEFAULT ALTER [ COLUMN ] %s { SET | DROP } NOT NULL ALTER [ COLUMN ] %s DROP EXPRESSION [ IF EXISTS ] ALTER [ COLUMN ] %s ADD GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY [ ( %s ) ] ALTER [ COLUMN ] %s { SET GENERATED { ALWAYS | BY DEFAULT } | SET %s | RESTART [ [ WITH ] %s ] } [...] ALTER [ COLUMN ] %s DROP IDENTITY [ IF EXISTS ] ALTER [ COLUMN ] %s SET STATISTICS %s ALTER [ COLUMN ] %s SET ( %s = %s [, ... ] ) ALTER [ COLUMN ] %s RESET ( %s [, ... ] ) ALTER [ COLUMN ] %s SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN } ADD %s [ NOT VALID ] ADD %s ALTER CONSTRAINT %s [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] VALIDATE CONSTRAINT %s DROP CONSTRAINT [ IF EXISTS ] %s [ RESTRICT | CASCADE ] DISABLE TRIGGER [ %s | ALL | USER ] ENABLE TRIGGER [ %s | ALL | USER ] ENABLE REPLICA TRIGGER %s ENABLE ALWAYS TRIGGER %s DISABLE RULE %s ENABLE RULE %s ENABLE REPLICA RULE %s ENABLE ALWAYS RULE %s DISABLE ROW LEVEL SECURITY ENABLE ROW LEVEL SECURITY FORCE ROW LEVEL SECURITY NO FORCE ROW LEVEL SECURITY CLUSTER ON %s SET WITHOUT CLUSTER SET WITHOUT OIDS SET TABLESPACE %s SET { LOGGED | UNLOGGED } SET ( %s [= %s] [, ... ] ) RESET ( %s [, ... ] ) INHERIT %s NO INHERIT %s OF %s NOT OF OWNER TO { %s | CURRENT_USER | SESSION_USER } REPLICA IDENTITY { DEFAULT | USING INDEX %s | FULL | NOTHING } %s IN ( %s [, ...] ) | FROM ( { %s | MINVALUE | MAXVALUE } [, ...] ) TO ( { %s | MINVALUE | MAXVALUE } [, ...] ) | WITH ( MODULUS %s, REMAINDER %s ) %s [ CONSTRAINT %s ] { NOT NULL | NULL | CHECK ( %s ) [ NO INHERIT ] | DEFAULT %s | GENERATED ALWAYS AS ( %s ) STORED | GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY [ ( %s ) ] | UNIQUE %s | PRIMARY KEY %s | REFERENCES %s [ ( %s ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE %s ] [ ON UPDATE %s ] } [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] %s [ CONSTRAINT %s ] { CHECK ( %s ) [ NO INHERIT ] | UNIQUE ( %s [, ... ] ) %s | PRIMARY KEY ( %s [, ... ] ) %s | EXCLUDE [ USING %s ] ( %s WITH %s [, ... ] ) %s [ WHERE ( %s ) ] | FOREIGN KEY ( %s [, ... ] ) REFERENCES %s [ ( %s [, ... ] ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE %s ] [ ON UPDATE %s ] } [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] %s [ CONSTRAINT %s ] { UNIQUE | PRIMARY KEY } USING INDEX %s [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] %s [ INCLUDE ( %s [, ... ] ) ] [ WITH ( %s [= %s] [, ... ] ) ] [ USING INDEX TABLESPACE %s ] %s { %s | ( %s ) } [ COLLATE %s ] [ %s [ ( %s = %s [, ... ] ) ] ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ] ALTER TABLESPACE %s RENAME TO %s ALTER TABLESPACE %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER TABLESPACE %s SET ( %s = %s [, ... ] ) ALTER TABLESPACE %s RESET ( %s [, ... ] ) ALTER TEXT SEARCH CONFIGURATION %s ADD MAPPING FOR %s [, ... ] WITH %s [, ... ] ALTER TEXT SEARCH CONFIGURATION %s ALTER MAPPING FOR %s [, ... ] WITH %s [, ... ] ALTER TEXT SEARCH CONFIGURATION %s ALTER MAPPING REPLACE %s WITH %s ALTER TEXT SEARCH CONFIGURATION %s ALTER MAPPING FOR %s [, ... ] REPLACE %s WITH %s ALTER TEXT SEARCH CONFIGURATION %s DROP MAPPING [ IF EXISTS ] FOR %s [, ... ] ALTER TEXT SEARCH CONFIGURATION %s RENAME TO %s ALTER TEXT SEARCH CONFIGURATION %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER TEXT SEARCH CONFIGURATION %s SET SCHEMA %s ALTER TEXT SEARCH DICTIONARY %s ( %s [ = %s ] [, ... ] ) ALTER TEXT SEARCH DICTIONARY %s RENAME TO %s ALTER TEXT SEARCH DICTIONARY %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER TEXT SEARCH DICTIONARY %s SET SCHEMA %s ALTER TEXT SEARCH PARSER %s RENAME TO %s ALTER TEXT SEARCH PARSER %s SET SCHEMA %s ALTER TEXT SEARCH TEMPLATE %s RENAME TO %s ALTER TEXT SEARCH TEMPLATE %s SET SCHEMA %s ALTER TRIGGER %s ON %s RENAME TO %s ALTER TRIGGER %s ON %s [ NO ] DEPENDS ON EXTENSION %s ALTER TYPE %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER TYPE %s RENAME TO %s ALTER TYPE %s SET SCHEMA %s ALTER TYPE %s RENAME ATTRIBUTE %s TO %s [ CASCADE | RESTRICT ] ALTER TYPE %s %s [, ... ] ALTER TYPE %s ADD VALUE [ IF NOT EXISTS ] %s [ { BEFORE | AFTER } %s ] ALTER TYPE %s RENAME VALUE %s TO %s ALTER TYPE %s SET ( %s = %s [, ... ] ) %s ADD ATTRIBUTE %s %s [ COLLATE %s ] [ CASCADE | RESTRICT ] DROP ATTRIBUTE [ IF EXISTS ] %s [ CASCADE | RESTRICT ] ALTER ATTRIBUTE %s [ SET DATA ] TYPE %s [ COLLATE %s ] [ CASCADE | RESTRICT ] ALTER USER %s [ WITH ] %s [ ... ] %s SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHERIT | NOINHERIT | LOGIN | NOLOGIN | REPLICATION | NOREPLICATION | BYPASSRLS | NOBYPASSRLS | CONNECTION LIMIT %s | [ ENCRYPTED ] PASSWORD '%s' | PASSWORD NULL | VALID UNTIL '%s' ALTER USER %s RENAME TO %s ALTER USER { %s | ALL } [ IN DATABASE %s ] SET %s { TO | = } { %s | DEFAULT } ALTER USER { %s | ALL } [ IN DATABASE %s ] SET %s FROM CURRENT ALTER USER { %s | ALL } [ IN DATABASE %s ] RESET %s ALTER USER { %s | ALL } [ IN DATABASE %s ] RESET ALL %s %s | CURRENT_USER | SESSION_USER ALTER USER MAPPING FOR { %s | USER | CURRENT_USER | SESSION_USER | PUBLIC } SERVER %s OPTIONS ( [ ADD | SET | DROP ] %s ['%s'] [, ... ] ) ALTER VIEW [ IF EXISTS ] %s ALTER [ COLUMN ] %s SET DEFAULT %s ALTER VIEW [ IF EXISTS ] %s ALTER [ COLUMN ] %s DROP DEFAULT ALTER VIEW [ IF EXISTS ] %s OWNER TO { %s | CURRENT_USER | SESSION_USER } ALTER VIEW [ IF EXISTS ] %s RENAME [ COLUMN ] %s TO %s ALTER VIEW [ IF EXISTS ] %s RENAME TO %s ALTER VIEW [ IF EXISTS ] %s SET SCHEMA %s ALTER VIEW [ IF EXISTS ] %s SET ( %s [= %s] [, ... ] ) ALTER VIEW [ IF EXISTS ] %s RESET ( %s [, ... ] ) ANALYZE [ ( %s [, ...] ) ] [ %s [, ...] ] ANALYZE [ VERBOSE ] [ %s [, ...] ] %s VERBOSE [ %s ] SKIP_LOCKED [ %s ] %s %s [ ( %s [, ...] ) ] where transaction_mode is one of: BEGIN [ WORK | TRANSACTION ] [ %s [, ...] ] %s ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED } READ WRITE | READ ONLY [ NOT ] DEFERRABLE CLUSTER [VERBOSE] %s [ USING %s ] CLUSTER [VERBOSE] COMMENT ON { ACCESS METHOD %s | AGGREGATE %s ( %s ) | CAST (%s AS %s) | COLLATION %s | COLUMN %s.%s | CONSTRAINT %s ON %s | CONSTRAINT %s ON DOMAIN %s | CONVERSION %s | DATABASE %s | DOMAIN %s | EXTENSION %s | EVENT TRIGGER %s | FOREIGN DATA WRAPPER %s | FOREIGN TABLE %s | FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] | INDEX %s | LARGE OBJECT %s | MATERIALIZED VIEW %s | OPERATOR %s (%s, %s) | OPERATOR CLASS %s USING %s | OPERATOR FAMILY %s USING %s | POLICY %s ON %s | [ PROCEDURAL ] LANGUAGE %s | PROCEDURE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] | PUBLICATION %s | ROLE %s | ROUTINE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] | RULE %s ON %s | SCHEMA %s | SEQUENCE %s | SERVER %s | STATISTICS %s | SUBSCRIPTION %s | TABLE %s | TABLESPACE %s | TEXT SEARCH CONFIGURATION %s | TEXT SEARCH DICTIONARY %s | TEXT SEARCH PARSER %s | TEXT SEARCH TEMPLATE %s | TRANSFORM FOR %s LANGUAGE %s | TRIGGER %s ON %s | TYPE %s | VIEW %s } IS { %s | NULL } %s * | [ %s ] [ %s ] %s [ , ... ] | [ [ %s ] [ %s ] %s [ , ... ] ] ORDER BY [ %s ] [ %s ] %s [ , ... ] COMMIT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] COPY %s [ ( %s [, ...] ) ] FROM { '%s' | PROGRAM '%s' | STDIN } [ [ WITH ] ( %s [, ...] ) ] [ WHERE %s ] COPY { %s [ ( %s [, ...] ) ] | ( %s ) } TO { '%s' | PROGRAM '%s' | STDOUT } [ [ WITH ] ( %s [, ...] ) ] %s FORMAT %s FREEZE [ %s ] DELIMITER '%s' NULL '%s' HEADER [ %s ] QUOTE '%s' ESCAPE '%s' FORCE_QUOTE { ( %s [, ...] ) | * } FORCE_NOT_NULL ( %s [, ...] ) FORCE_NULL ( %s [, ...] ) ENCODING '%s' CREATE ACCESS METHOD %s TYPE %s HANDLER %s CREATE [ OR REPLACE ] AGGREGATE %s ( [ %s ] [ %s ] %s [ , ... ] ) ( SFUNC = %s, STYPE = %s [ , SSPACE = %s ] [ , FINALFUNC = %s ] [ , FINALFUNC_EXTRA ] [ , FINALFUNC_MODIFY = { READ_ONLY | SHAREABLE | READ_WRITE } ] [ , COMBINEFUNC = %s ] [ , SERIALFUNC = %s ] [ , DESERIALFUNC = %s ] [ , INITCOND = %s ] [ , MSFUNC = %s ] [ , MINVFUNC = %s ] [ , MSTYPE = %s ] [ , MSSPACE = %s ] [ , MFINALFUNC = %s ] [ , MFINALFUNC_EXTRA ] [ , MFINALFUNC_MODIFY = { READ_ONLY | SHAREABLE | READ_WRITE } ] [ , MINITCOND = %s ] [ , SORTOP = %s ] [ , PARALLEL = { SAFE | RESTRICTED | UNSAFE } ] ) CREATE [ OR REPLACE ] AGGREGATE %s ( [ [ %s ] [ %s ] %s [ , ... ] ] ORDER BY [ %s ] [ %s ] %s [ , ... ] ) ( SFUNC = %s, STYPE = %s [ , SSPACE = %s ] [ , FINALFUNC = %s ] [ , FINALFUNC_EXTRA ] [ , FINALFUNC_MODIFY = { READ_ONLY | SHAREABLE | READ_WRITE } ] [ , INITCOND = %s ] [ , PARALLEL = { SAFE | RESTRICTED | UNSAFE } ] [ , HYPOTHETICAL ] ) %s CREATE [ OR REPLACE ] AGGREGATE %s ( BASETYPE = %s, SFUNC = %s, STYPE = %s [ , SSPACE = %s ] [ , FINALFUNC = %s ] [ , FINALFUNC_EXTRA ] [ , FINALFUNC_MODIFY = { READ_ONLY | SHAREABLE | READ_WRITE } ] [ , COMBINEFUNC = %s ] [ , SERIALFUNC = %s ] [ , DESERIALFUNC = %s ] [ , INITCOND = %s ] [ , MSFUNC = %s ] [ , MINVFUNC = %s ] [ , MSTYPE = %s ] [ , MSSPACE = %s ] [ , MFINALFUNC = %s ] [ , MFINALFUNC_EXTRA ] [ , MFINALFUNC_MODIFY = { READ_ONLY | SHAREABLE | READ_WRITE } ] [ , MINITCOND = %s ] [ , SORTOP = %s ] ) SELECT oid, pubname, pg_catalog.pg_get_userbyid(pubowner) AS owner, puballtables, pubinsert, pubupdate, pubdelete Did not find any publication named "%s". Did not find any publications. SELECT n.nspname, c.relname FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n, pg_catalog.pg_publication_rel pr WHERE c.relnamespace = n.oid AND c.oid = pr.prrelid AND pr.prpubid = '%s' ORDER BY 1,2 SELECT spcname FROM pg_catalog.pg_tablespace WHERE oid = '%u'; SELECT e.extname, e.oid FROM pg_catalog.pg_extension e Did not find any extension named "%s". SELECT pg_catalog.pg_describe_object(classid, objid, 0) AS "%s" FROM pg_catalog.pg_depend WHERE refclassid = 'pg_catalog.pg_extension'::pg_catalog.regclass AND refobjid = '%s' AND deptype = 'e' ORDER BY 1; could not look up effective user ID %ld: %s psql is the PostgreSQL interactive terminal. psql [OPTION]... [DBNAME [USERNAME]] -c, --command=COMMAND run only single command (SQL or internal) and exit -d, --dbname=DBNAME database name to connect to (default: "%s") -f, --file=FILENAME execute commands from file, then exit -l, --list list available databases, then exit -v, --set=, --variable=NAME=VALUE set psql variable NAME to VALUE (e.g., -v ON_ERROR_STOP=1) -V, --version output version information, then exit -X, --no-psqlrc do not read startup file (~/.psqlrc) -1 ("one"), --single-transaction execute as a single transaction (if non-interactive) -?, --help[=options] show this help, then exit --help=commands list backslash commands, then exit --help=variables list special variables, then exit -a, --echo-all echo all input from script -b, --echo-errors echo failed commands -e, --echo-queries echo commands sent to server -E, --echo-hidden display queries that internal commands generate -L, --log-file=FILENAME send session log to file -n, --no-readline disable enhanced command line editing (readline) -o, --output=FILENAME send query results to file (or |pipe) -q, --quiet run quietly (no messages, only query output) -s, --single-step single-step mode (confirm each query) -S, --single-line single-line mode (end of line terminates SQL command) -A, --no-align unaligned table output mode --csv CSV (Comma-Separated Values) table output mode -F, --field-separator=STRING field separator for unaligned output (default: "%s") -H, --html HTML table output mode -P, --pset=VAR[=ARG] set printing option VAR to ARG (see \pset command) -R, --record-separator=STRING record separator for unaligned output (default: newline) -t, --tuples-only print rows only -T, --table-attr=TEXT set HTML table tag attributes (e.g., width, border) -x, --expanded turn on expanded table output -z, --field-separator-zero set field separator for unaligned output to zero byte -0, --record-separator-zero set record separator for unaligned output to zero byte -h, --host=HOSTNAME database server host or socket directory (default: "%s") -p, --port=PORT database server port (default: "%s") -U, --username=USERNAME database user name (default: "%s") -w, --no-password never prompt for password -W, --password force password prompt (should happen automatically) For more information, type "\?" (for internal commands) or "\help" (for SQL commands) from within psql, or consult the psql section in the PostgreSQL documentation. pgsql-bugs@lists.postgresql.org \copyright show PostgreSQL usage and distribution terms \crosstabview [COLUMNS] execute query and display results in crosstab \errverbose show most recent error message at maximum verbosity \g [(OPTIONS)] [FILE] execute query (and send results to file or |pipe); \g with no arguments is equivalent to a semicolon \gdesc describe result of query, without executing it \gexec execute query, then execute each value in its result \gset [PREFIX] execute query and store results in psql variables \gx [(OPTIONS)] [FILE] as \g, but forces expanded output mode \q quit psql \restrict RESTRICT_KEY enter restricted mode with provided key \unrestrict RESTRICT_KEY exit restricted mode if key matches \watch [SEC] execute query every SEC seconds \? [commands] show help on backslash commands \? options show help on psql command-line options \? variables show help on special variables \h [NAME] help on syntax of SQL commands, * for all commands \e [FILE] [LINE] edit the query buffer (or file) with external editor \ef [FUNCNAME [LINE]] edit function definition with external editor \ev [VIEWNAME [LINE]] edit view definition with external editor \p show the contents of the query buffer \r reset (clear) the query buffer \s [FILE] display history or save it to file \w FILE write query buffer to file \copy ... perform SQL COPY with data stream to the client host \echo [-n] [STRING] write string to standard output (-n for no newline) \i FILE execute commands from file \ir FILE as \i, but relative to location of current script \o [FILE] send all query results to file or |pipe \qecho [-n] [STRING] write string to \o output stream (-n for no newline) \warn [-n] [STRING] write string to standard error (-n for no newline) \if EXPR begin conditional block \elif EXPR alternative within current conditional block \else final alternative within current conditional block \endif end conditional block (options: S = show system objects, + = additional detail) \d[S+] list tables, views, and sequences \d[S+] NAME describe table, view, sequence, or index \da[S] [PATTERN] list aggregates \dA[+] [PATTERN] list access methods \dAc[+] [AMPTRN [TYPEPTRN]] list operator classes \dAf[+] [AMPTRN [TYPEPTRN]] list operator families \dAo[+] [AMPTRN [OPFPTRN]] list operators of operator families \dAp[+] [AMPTRN [OPFPTRN]] list support functions of operator families \db[+] [PATTERN] list tablespaces \dc[S+] [PATTERN] list conversions \dC[+] [PATTERN] list casts \dd[S] [PATTERN] show object descriptions not displayed elsewhere \dD[S+] [PATTERN] list domains \ddp [PATTERN] list default privileges \dE[S+] [PATTERN] list foreign tables \det[+] [PATTERN] list foreign tables \des[+] [PATTERN] list foreign servers \deu[+] [PATTERN] list user mappings \dew[+] [PATTERN] list foreign-data wrappers \df[anptw][S+] [PATRN] list [only agg/normal/procedures/trigger/window] functions \dF[+] [PATTERN] list text search configurations \dFd[+] [PATTERN] list text search dictionaries \dFp[+] [PATTERN] list text search parsers \dFt[+] [PATTERN] list text search templates \dg[S+] [PATTERN] list roles \di[S+] [PATTERN] list indexes \dl list large objects, same as \lo_list \dL[S+] [PATTERN] list procedural languages \dm[S+] [PATTERN] list materialized views \dn[S+] [PATTERN] list schemas \do[S+] [PATTERN] list operators \dO[S+] [PATTERN] list collations \dp [PATTERN] list table, view, and sequence access privileges \dP[itn+] [PATTERN] list [only index/table] partitioned relations [n=nested] \drds [PATRN1 [PATRN2]] list per-database role settings \dRp[+] [PATTERN] list replication publications \dRs[+] [PATTERN] list replication subscriptions \ds[S+] [PATTERN] list sequences \dt[S+] [PATTERN] list tables \dT[S+] [PATTERN] list data types \du[S+] [PATTERN] list roles \dv[S+] [PATTERN] list views \dx[+] [PATTERN] list extensions \dy[+] [PATTERN] list event triggers \l[+] [PATTERN] list databases \sf[+] FUNCNAME show a function's definition \sv[+] VIEWNAME show a view's definition \z [PATTERN] same as \dp \a toggle between unaligned and aligned output mode \C [STRING] set table title, or unset if none \f [STRING] show or set field separator for unaligned query output \H toggle HTML output mode (currently %s) \pset [NAME [VALUE]] set table output option (border|columns|csv_fieldsep|expanded|fieldsep| fieldsep_zero|footer|format|linestyle|null| numericlocale|pager|pager_min_lines|recordsep| recordsep_zero|tableattr|title|tuples_only| unicode_border_linestyle|unicode_column_linestyle| unicode_header_linestyle) \t [on|off] show only rows (currently %s) \T [STRING] set HTML