18#include "catalog/pg_am_d.h"
19#include "catalog/pg_amop_d.h"
20#include "catalog/pg_attribute_d.h"
21#include "catalog/pg_cast_d.h"
22#include "catalog/pg_class_d.h"
23#include "catalog/pg_collation_d.h"
24#include "catalog/pg_constraint_d.h"
25#include "catalog/pg_default_acl_d.h"
26#include "catalog/pg_proc_d.h"
27#include "catalog/pg_propgraph_element_d.h"
28#include "catalog/pg_publication_d.h"
29#include "catalog/pg_statistic_ext_d.h"
30#include "catalog/pg_subscription_d.h"
31#include "catalog/pg_type_d.h"
89 "SELECT n.nspname as \"%s\",\n"
90 " p.proname AS \"%s\",\n"
91 " pg_catalog.format_type(p.prorettype, NULL) AS \"%s\",\n"
92 " CASE WHEN p.pronargs = 0\n"
93 " THEN CAST('*' AS pg_catalog.text)\n"
94 " ELSE pg_catalog.pg_get_function_arguments(p.oid)\n"
103 " pg_catalog.obj_description(p.oid, 'pg_proc') as \"%s\"\n"
104 "FROM pg_catalog.pg_proc p\n"
105 " LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace\n"
110 " pg_catalog.obj_description(p.oid, 'pg_proc') as \"%s\"\n"
111 "FROM pg_catalog.pg_proc p\n"
112 " LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace\n"
113 "WHERE p.proisagg\n",
118 " AND n.nspname <> 'information_schema'\n");
121 "n.nspname",
"p.proname",
NULL,
122 "pg_catalog.pg_function_is_visible(p.oid)",
136 myopt.title =
_(
"List of aggregate functions");
137 myopt.translate_header =
true;
155 static const bool translate_columns[] = {
false,
true,
false,
false};
161 pg_log_error(
"The server (version %s) does not support access methods.",
171 "SELECT amname AS \"%s\",\n"
184 ",\n amhandler AS \"%s\",\n"
185 " pg_catalog.obj_description(oid, 'pg_am') AS \"%s\"",
191 "\nFROM pg_catalog.pg_am\n");
209 myopt.title =
_(
"List of access methods");
210 myopt.translate_header =
true;
211 myopt.translate_columns = translate_columns;
235 "SELECT spcname AS \"%s\",\n"
236 " pg_catalog.pg_get_userbyid(spcowner) AS \"%s\",\n"
237 " pg_catalog.pg_tablespace_location(oid) AS \"%s\"",
247 ",\n spcoptions AS \"%s\""
248 ",\n pg_catalog.pg_size_pretty(pg_catalog.pg_tablespace_size(oid)) AS \"%s\""
249 ",\n pg_catalog.shobj_description(oid, 'pg_tablespace') AS \"%s\"",
256 "\nFROM pg_catalog.pg_tablespace\n");
274 myopt.title =
_(
"List of tablespaces");
275 myopt.translate_header =
true;
313 static const bool translate_columns[] = {
false,
false,
false,
false,
true,
true,
true,
false,
true,
true,
false,
false,
false,
false};
316 static const bool translate_columns_pre_96[] = {
false,
false,
false,
false,
true,
true,
false,
true,
true,
false,
false,
false,
false};
328 pg_log_error(
"\\df does not take a \"%c\" option with server version %s",
346 "SELECT n.nspname as \"%s\",\n"
347 " p.proname as \"%s\",\n",
353 " pg_catalog.pg_get_function_result(p.oid) as \"%s\",\n"
354 " pg_catalog.pg_get_function_arguments(p.oid) as \"%s\",\n"
371 " pg_catalog.pg_get_function_result(p.oid) as \"%s\",\n"
372 " pg_catalog.pg_get_function_arguments(p.oid) as \"%s\",\n"
374 " WHEN p.proisagg THEN '%s'\n"
375 " WHEN p.proiswindow THEN '%s'\n"
376 " WHEN p.prorettype = 'pg_catalog.trigger'::pg_catalog.regtype THEN '%s'\n"
392 " WHEN p.provolatile = "
394 " WHEN p.provolatile = "
396 " WHEN p.provolatile = "
406 " WHEN p.proparallel = "
408 " WHEN p.proparallel = "
410 " WHEN p.proparallel = "
418 ",\n pg_catalog.pg_get_userbyid(p.proowner) as \"%s\""
419 ",\n CASE WHEN prosecdef THEN '%s' ELSE '%s' END AS \"%s\""
420 ",\n CASE WHEN p.proleakproof THEN '%s' ELSE '%s' END as \"%s\"",
431 ",\n l.lanname as \"%s\"",
434 ",\n CASE WHEN l.lanname IN ('internal', 'c') THEN p.prosrc END as \"%s\"",
437 ",\n pg_catalog.obj_description(p.oid, 'pg_proc') as \"%s\"",
442 "\nFROM pg_catalog.pg_proc p"
443 "\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace\n");
448 " LEFT JOIN pg_catalog.pg_type t%d ON t%d.oid = p.proargtypes[%d]\n"
449 " LEFT JOIN pg_catalog.pg_namespace nt%d ON nt%d.oid = t%d.typnamespace\n",
455 " LEFT JOIN pg_catalog.pg_language l ON l.oid = p.prolang\n");
539 "p.prorettype = 'pg_catalog.trigger'::pg_catalog.regtype\n");
564 "n.nspname",
"p.proname",
NULL,
565 "pg_catalog.pg_function_is_visible(p.oid)",
583 snprintf(nspname,
sizeof(nspname),
"nt%d.nspname",
i);
586 "pg_catalog.format_type(t%d.oid, NULL)",
i);
588 "pg_catalog.pg_type_is_visible(t%d.oid)",
i);
605 " AND n.nspname <> 'information_schema'\n");
614 myopt.title =
_(
"List of functions");
615 myopt.translate_header =
true;
618 myopt.translate_columns = translate_columns;
654 "SELECT n.nspname as \"%s\",\n"
655 " pg_catalog.format_type(t.oid, NULL) AS \"%s\",\n",
661 " t.typname AS \"%s\",\n"
662 " CASE WHEN t.typrelid != 0\n"
663 " THEN CAST('tuple' AS pg_catalog.text)\n"
664 " WHEN t.typlen < 0\n"
665 " THEN CAST('var' AS pg_catalog.text)\n"
666 " ELSE CAST(t.typlen AS pg_catalog.text)\n"
668 " pg_catalog.array_to_string(\n"
670 " SELECT e.enumlabel\n"
671 " FROM pg_catalog.pg_enum e\n"
672 " WHERE e.enumtypid = t.oid\n"
673 " ORDER BY e.enumsortorder\n"
677 " pg_catalog.pg_get_userbyid(t.typowner) AS \"%s\",\n",
687 " pg_catalog.obj_description(t.oid, 'pg_type') as \"%s\"\n",
691 " LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace\n");
699 " FROM pg_catalog.pg_class c "
700 "WHERE c.oid = t.typrelid))\n");
706 appendPQExpBufferStr(&
buf,
" AND NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type el WHERE el.oid = t.typelem AND el.typarray = t.oid)\n");
710 " AND n.nspname <> 'information_schema'\n");
715 "n.nspname",
"t.typname",
716 "pg_catalog.format_type(t.oid, NULL)",
717 "pg_catalog.pg_type_is_visible(t.oid)",
731 myopt.title =
_(
"List of data types");
732 myopt.translate_header =
true;
758 "decimal",
"numeric",
759 "float",
"double precision",
766 "bool[]",
"boolean[]",
767 "decimal[]",
"numeric[]",
768 "float[]",
"double precision[]",
769 "float4[]",
"real[]",
770 "float8[]",
"double precision[]",
771 "int[]",
"integer[]",
772 "int2[]",
"smallint[]",
773 "int4[]",
"integer[]",
774 "int8[]",
"bigint[]",
775 "time[]",
"time without time zone[]",
776 "timetz[]",
"time with time zone[]",
777 "timestamp[]",
"timestamp without time zone[]",
778 "timestamptz[]",
"timestamp with time zone[]",
779 "varbit[]",
"bit varying[]",
780 "varchar[]",
"character varying[]",
807 static const bool translate_columns[] = {
false,
false,
false,
false,
false,
false,
true,
false};
829 "SELECT n.nspname as \"%s\",\n"
830 " o.oprname AS \"%s\",\n"
831 " CASE WHEN o.oprkind='l' THEN NULL ELSE pg_catalog.format_type(o.oprleft, NULL) END AS \"%s\",\n"
832 " CASE WHEN o.oprkind='r' THEN NULL ELSE pg_catalog.format_type(o.oprright, NULL) END AS \"%s\",\n"
833 " pg_catalog.format_type(o.oprresult, NULL) AS \"%s\",\n",
842 " o.oprcode AS \"%s\",\n"
843 " CASE WHEN p.proleakproof THEN '%s' ELSE '%s' END AS \"%s\",\n",
850 " coalesce(pg_catalog.obj_description(o.oid, 'pg_operator'),\n"
851 " pg_catalog.obj_description(o.oprcode, 'pg_proc')) AS \"%s\"\n"
852 "FROM pg_catalog.pg_operator o\n"
853 " LEFT JOIN pg_catalog.pg_namespace n ON n.oid = o.oprnamespace\n",
860 " LEFT JOIN pg_catalog.pg_type t0 ON t0.oid = o.oprleft\n"
861 " LEFT JOIN pg_catalog.pg_namespace nt0 ON nt0.oid = t0.typnamespace\n"
862 " LEFT JOIN pg_catalog.pg_type t1 ON t1.oid = o.oprright\n"
863 " LEFT JOIN pg_catalog.pg_namespace nt1 ON nt1.oid = t1.typnamespace\n");
868 " LEFT JOIN pg_catalog.pg_type t0 ON t0.oid = o.oprright\n"
869 " LEFT JOIN pg_catalog.pg_namespace nt0 ON nt0.oid = t0.typnamespace\n");
874 " LEFT JOIN pg_catalog.pg_proc p ON p.oid = o.oprcode\n");
878 " AND n.nspname <> 'information_schema'\n");
882 "n.nspname",
"o.oprname",
NULL,
883 "pg_catalog.pg_operator_is_visible(o.oid)",
904 snprintf(nspname,
sizeof(nspname),
"nt%d.nspname",
i);
907 "pg_catalog.format_type(t%d.oid, NULL)",
i);
909 "pg_catalog.pg_type_is_visible(t%d.oid)",
i);
931 myopt.title =
_(
"List of operators");
932 myopt.translate_header =
true;
933 myopt.translate_columns = translate_columns;
964 " d.datname as \"%s\",\n"
965 " pg_catalog.pg_get_userbyid(d.datdba) as \"%s\",\n"
966 " pg_catalog.pg_encoding_to_char(d.encoding) as \"%s\",\n",
972 " CASE d.datlocprovider "
980 " 'libc' AS \"%s\",\n",
983 " d.datcollate as \"%s\",\n"
984 " d.datctype as \"%s\",\n",
989 " d.datlocale as \"%s\",\n",
993 " d.daticulocale as \"%s\",\n",
997 " NULL as \"%s\",\n",
1001 " d.daticurules as \"%s\",\n",
1005 " NULL as \"%s\",\n",
1011 ",\n CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT')\n"
1012 " THEN pg_catalog.pg_size_pretty(pg_catalog.pg_database_size(d.datname))\n"
1013 " ELSE 'No Access'\n"
1015 ",\n t.spcname as \"%s\""
1016 ",\n pg_catalog.shobj_description(d.oid, 'pg_database') as \"%s\"",
1021 "\nFROM pg_catalog.pg_database d\n");
1024 " JOIN pg_catalog.pg_tablespace t on d.dattablespace = t.oid\n");
1043 myopt.title =
_(
"List of databases");
1044 myopt.translate_header =
true;
1063 static const bool translate_columns[] = {
false,
false,
true,
false,
false,
false};
1071 _(
"Get access privileges of matching relations"));
1073 "SELECT n.nspname as \"%s\",\n"
1074 " c.relname as \"%s\",\n"
1104 ",\n pg_catalog.array_to_string(ARRAY(\n"
1105 " SELECT attname || E':\\n ' || pg_catalog.array_to_string(attacl, E'\\n ')\n"
1106 " FROM pg_catalog.pg_attribute a\n"
1107 " WHERE attrelid = c.oid AND NOT attisdropped AND attacl IS NOT NULL\n"
1108 " ), E'\\n') AS \"%s\"",
1113 ",\n pg_catalog.array_to_string(ARRAY(\n"
1115 " || CASE WHEN polcmd != '*' THEN\n"
1116 " E' (' || polcmd::pg_catalog.text || E'):'\n"
1119 " || CASE WHEN polqual IS NOT NULL THEN\n"
1120 " E'\\n (u): ' || pg_catalog.pg_get_expr(polqual, polrelid)\n"
1123 " || CASE WHEN polwithcheck IS NOT NULL THEN\n"
1124 " E'\\n (c): ' || pg_catalog.pg_get_expr(polwithcheck, polrelid)\n"
1127 " || CASE WHEN polroles <> '{0}' THEN\n"
1128 " E'\\n to: ' || pg_catalog.array_to_string(\n"
1131 " FROM pg_catalog.pg_roles\n"
1132 " WHERE oid = ANY (polroles)\n"
1137 " FROM pg_catalog.pg_policy pol\n"
1138 " WHERE polrelid = c.oid), E'\\n')\n"
1144 ",\n pg_catalog.array_to_string(ARRAY(\n"
1146 " || CASE WHEN NOT polpermissive THEN\n"
1147 " E' (RESTRICTIVE)'\n"
1149 " || CASE WHEN polcmd != '*' THEN\n"
1150 " E' (' || polcmd::pg_catalog.text || E'):'\n"
1153 " || CASE WHEN polqual IS NOT NULL THEN\n"
1154 " E'\\n (u): ' || pg_catalog.pg_get_expr(polqual, polrelid)\n"
1157 " || CASE WHEN polwithcheck IS NOT NULL THEN\n"
1158 " E'\\n (c): ' || pg_catalog.pg_get_expr(polwithcheck, polrelid)\n"
1161 " || CASE WHEN polroles <> '{0}' THEN\n"
1162 " E'\\n to: ' || pg_catalog.array_to_string(\n"
1165 " FROM pg_catalog.pg_roles\n"
1166 " WHERE oid = ANY (polroles)\n"
1171 " FROM pg_catalog.pg_policy pol\n"
1172 " WHERE polrelid = c.oid), E'\\n')\n"
1177 " LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n"
1178 "WHERE c.relkind IN ("
1189 " AND n.nspname <> 'information_schema'\n");
1192 "n.nspname",
"c.relname",
NULL,
1193 "pg_catalog.pg_table_is_visible(c.oid)",
1205 myopt.translate_header =
true;
1206 myopt.translate_columns = translate_columns;
1232 static const bool translate_columns[] = {
false,
false,
true,
false};
1238 "SELECT pg_catalog.pg_get_userbyid(d.defaclrole) AS \"%s\",\n"
1239 " n.nspname AS \"%s\",\n"
1240 " CASE d.defaclobjtype "
1241 " WHEN '%c' THEN '%s' WHEN '%c' THEN '%s' WHEN '%c' THEN '%s'"
1242 " WHEN '%c' THEN '%s' WHEN '%c' THEN '%s' WHEN '%c' THEN '%s' END AS \"%s\",\n"
1263 " LEFT JOIN pg_catalog.pg_namespace n ON n.oid = d.defaclnamespace\n");
1268 "pg_catalog.pg_get_userbyid(d.defaclrole)",
1281 myopt.translate_header =
true;
1282 myopt.translate_columns = translate_columns;
1314 static const bool translate_columns[] = {
false,
false,
true,
false};
1320 "SELECT DISTINCT tt.nspname AS \"%s\", tt.name AS \"%s\", tt.object AS \"%s\", d.description AS \"%s\"\n"
1329 " SELECT pgc.oid as oid, pgc.tableoid AS tableoid,\n"
1330 " n.nspname as nspname,\n"
1331 " CAST(pgc.conname AS pg_catalog.text) as name,"
1332 " CAST('%s' AS pg_catalog.text) as object\n"
1333 " FROM pg_catalog.pg_constraint pgc\n"
1334 " JOIN pg_catalog.pg_class c "
1335 "ON c.oid = pgc.conrelid\n"
1336 " LEFT JOIN pg_catalog.pg_namespace n "
1337 " ON n.oid = c.relnamespace\n",
1342 " AND n.nspname <> 'information_schema'\n");
1345 false,
"n.nspname",
"pgc.conname",
NULL,
1346 "pg_catalog.pg_table_is_visible(c.oid)",
1353 " SELECT pgc.oid as oid, pgc.tableoid AS tableoid,\n"
1354 " n.nspname as nspname,\n"
1355 " CAST(pgc.conname AS pg_catalog.text) as name,"
1356 " CAST('%s' AS pg_catalog.text) as object\n"
1357 " FROM pg_catalog.pg_constraint pgc\n"
1358 " JOIN pg_catalog.pg_type t "
1359 "ON t.oid = pgc.contypid\n"
1360 " LEFT JOIN pg_catalog.pg_namespace n "
1361 " ON n.oid = t.typnamespace\n",
1366 " AND n.nspname <> 'information_schema'\n");
1369 false,
"n.nspname",
"pgc.conname",
NULL,
1370 "pg_catalog.pg_type_is_visible(t.oid)",
1377 " SELECT o.oid as oid, o.tableoid as tableoid,\n"
1378 " n.nspname as nspname,\n"
1379 " CAST(o.opcname AS pg_catalog.text) as name,\n"
1380 " CAST('%s' AS pg_catalog.text) as object\n"
1381 " FROM pg_catalog.pg_opclass o\n"
1382 " JOIN pg_catalog.pg_am am ON "
1383 "o.opcmethod = am.oid\n"
1384 " JOIN pg_catalog.pg_namespace n ON "
1385 "n.oid = o.opcnamespace\n",
1390 " AND n.nspname <> 'information_schema'\n");
1393 "n.nspname",
"o.opcname",
NULL,
1394 "pg_catalog.pg_opclass_is_visible(o.oid)",
1401 " SELECT opf.oid as oid, opf.tableoid as tableoid,\n"
1402 " n.nspname as nspname,\n"
1403 " CAST(opf.opfname AS pg_catalog.text) AS name,\n"
1404 " CAST('%s' AS pg_catalog.text) as object\n"
1405 " FROM pg_catalog.pg_opfamily opf\n"
1406 " JOIN pg_catalog.pg_am am "
1407 "ON opf.opfmethod = am.oid\n"
1408 " JOIN pg_catalog.pg_namespace n "
1409 "ON opf.opfnamespace = n.oid\n",
1414 " AND n.nspname <> 'information_schema'\n");
1417 "n.nspname",
"opf.opfname",
NULL,
1418 "pg_catalog.pg_opfamily_is_visible(opf.oid)",
1425 " SELECT r.oid as oid, r.tableoid as tableoid,\n"
1426 " n.nspname as nspname,\n"
1427 " CAST(r.rulename AS pg_catalog.text) as name,"
1428 " CAST('%s' AS pg_catalog.text) as object\n"
1429 " FROM pg_catalog.pg_rewrite r\n"
1430 " JOIN pg_catalog.pg_class c ON c.oid = r.ev_class\n"
1431 " LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n"
1432 " WHERE r.rulename != '_RETURN'\n",
1437 " AND n.nspname <> 'information_schema'\n");
1440 "n.nspname",
"r.rulename",
NULL,
1441 "pg_catalog.pg_table_is_visible(c.oid)",
1448 " SELECT t.oid as oid, t.tableoid as tableoid,\n"
1449 " n.nspname as nspname,\n"
1450 " CAST(t.tgname AS pg_catalog.text) as name,"
1451 " CAST('%s' AS pg_catalog.text) as object\n"
1452 " FROM pg_catalog.pg_trigger t\n"
1453 " JOIN pg_catalog.pg_class c ON c.oid = t.tgrelid\n"
1454 " LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n",
1459 " AND n.nspname <> 'information_schema'\n");
1462 "n.nspname",
"t.tgname",
NULL,
1463 "pg_catalog.pg_table_is_visible(c.oid)",
1469 " JOIN pg_catalog.pg_description d ON (tt.oid = d.objoid AND tt.tableoid = d.classoid AND d.objsubid = 0)\n");
1478 myopt.title =
_(
"Object descriptions");
1479 myopt.translate_header =
true;
1480 myopt.translate_columns = translate_columns;
1512 _(
"Get matching relations to describe"));
1517 "FROM pg_catalog.pg_class c\n"
1518 " LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n");
1522 " AND n.nspname <> 'information_schema'\n");
1525 "n.nspname",
"c.relname",
NULL,
1526 "pg_catalog.pg_table_is_visible(c.oid)",
1545 pg_log_error(
"Did not find any relation named \"%s\".",
1557 const char *nspname;
1593 bool retval =
false;
1634 char relpersistence;
1640 myopt.default_footer =
false;
1642 myopt.expanded =
false;
1650 _(
"Get general information about one relation"));
1654 "SELECT c.relchecks, c.relkind, c.relhasindex, c.relhasrules, "
1655 "c.relhastriggers, c.relrowsecurity, c.relforcerowsecurity, "
1656 "false AS relhasoids, c.relispartition, %s, c.reltablespace, "
1657 "CASE WHEN c.reloftype = 0 THEN '' ELSE c.reloftype::pg_catalog.regtype::pg_catalog.text END, "
1658 "c.relpersistence, c.relreplident, am.amname\n"
1659 "FROM pg_catalog.pg_class c\n "
1660 "LEFT JOIN pg_catalog.pg_class tc ON (c.reltoastrelid = tc.oid)\n"
1661 "LEFT JOIN pg_catalog.pg_am am ON (c.relam = am.oid)\n"
1662 "WHERE c.oid = '%s';",
1664 "pg_catalog.array_to_string(c.reloptions || "
1665 "array(select 'toast.' || x from pg_catalog.unnest(tc.reloptions) x), ', ')\n"
1672 "SELECT c.relchecks, c.relkind, c.relhasindex, c.relhasrules, "
1673 "c.relhastriggers, c.relrowsecurity, c.relforcerowsecurity, "
1674 "c.relhasoids, c.relispartition, %s, c.reltablespace, "
1675 "CASE WHEN c.reloftype = 0 THEN '' ELSE c.reloftype::pg_catalog.regtype::pg_catalog.text END, "
1676 "c.relpersistence, c.relreplident\n"
1677 "FROM pg_catalog.pg_class c\n "
1678 "LEFT JOIN pg_catalog.pg_class tc ON (c.reltoastrelid = tc.oid)\n"
1679 "WHERE c.oid = '%s';",
1681 "pg_catalog.array_to_string(c.reloptions || "
1682 "array(select 'toast.' || x from pg_catalog.unnest(tc.reloptions) x), ', ')\n"
1689 "SELECT c.relchecks, c.relkind, c.relhasindex, c.relhasrules, "
1690 "c.relhastriggers, c.relrowsecurity, c.relforcerowsecurity, "
1691 "c.relhasoids, false as relispartition, %s, c.reltablespace, "
1692 "CASE WHEN c.reloftype = 0 THEN '' ELSE c.reloftype::pg_catalog.regtype::pg_catalog.text END, "
1693 "c.relpersistence, c.relreplident\n"
1694 "FROM pg_catalog.pg_class c\n "
1695 "LEFT JOIN pg_catalog.pg_class tc ON (c.reltoastrelid = tc.oid)\n"
1696 "WHERE c.oid = '%s';",
1698 "pg_catalog.array_to_string(c.reloptions || "
1699 "array(select 'toast.' || x from pg_catalog.unnest(tc.reloptions) x), ', ')\n"
1706 "SELECT c.relchecks, c.relkind, c.relhasindex, c.relhasrules, "
1707 "c.relhastriggers, false, false, c.relhasoids, "
1708 "false as relispartition, %s, c.reltablespace, "
1709 "CASE WHEN c.reloftype = 0 THEN '' ELSE c.reloftype::pg_catalog.regtype::pg_catalog.text END, "
1710 "c.relpersistence, c.relreplident\n"
1711 "FROM pg_catalog.pg_class c\n "
1712 "LEFT JOIN pg_catalog.pg_class tc ON (c.reltoastrelid = tc.oid)\n"
1713 "WHERE c.oid = '%s';",
1715 "pg_catalog.array_to_string(c.reloptions || "
1716 "array(select 'toast.' || x from pg_catalog.unnest(tc.reloptions) x), ', ')\n"
1723 "SELECT c.relchecks, c.relkind, c.relhasindex, c.relhasrules, "
1724 "c.relhastriggers, false, false, c.relhasoids, "
1725 "false as relispartition, %s, c.reltablespace, "
1726 "CASE WHEN c.reloftype = 0 THEN '' ELSE c.reloftype::pg_catalog.regtype::pg_catalog.text END, "
1727 "c.relpersistence\n"
1728 "FROM pg_catalog.pg_class c\n "
1729 "LEFT JOIN pg_catalog.pg_class tc ON (c.reltoastrelid = tc.oid)\n"
1730 "WHERE c.oid = '%s';",
1732 "pg_catalog.array_to_string(c.reloptions || "
1733 "array(select 'toast.' || x from pg_catalog.unnest(tc.reloptions) x), ', ')\n"
1746 pg_log_error(
"Did not find any relation with OID %s.", oid);
1787 "SELECT pg_catalog.format_type(seqtypid, NULL) AS \"%s\",\n"
1788 " seqstart AS \"%s\",\n"
1789 " seqmin AS \"%s\",\n"
1790 " seqmax AS \"%s\",\n"
1791 " seqincrement AS \"%s\",\n"
1792 " CASE WHEN seqcycle THEN '%s' ELSE '%s' END AS \"%s\",\n"
1793 " seqcache AS \"%s\"\n",
1804 "FROM pg_catalog.pg_sequence\n"
1805 "WHERE seqrelid = '%s';",
1811 "SELECT 'bigint' AS \"%s\",\n"
1812 " start_value AS \"%s\",\n"
1813 " min_value AS \"%s\",\n"
1814 " max_value AS \"%s\",\n"
1815 " increment_by AS \"%s\",\n"
1816 " CASE WHEN is_cycled THEN '%s' ELSE '%s' END AS \"%s\",\n"
1817 " cache_value AS \"%s\"\n",
1838 _(
"Get the column that owns this sequence"));
1840 "\n pg_catalog.quote_ident(relname) || '.' ||"
1841 "\n pg_catalog.quote_ident(attname),"
1843 "\nFROM pg_catalog.pg_class c"
1844 "\nINNER JOIN pg_catalog.pg_depend d ON c.oid=d.refobjid"
1845 "\nINNER JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace"
1846 "\nINNER JOIN pg_catalog.pg_attribute a ON ("
1847 "\n a.attrelid=c.oid AND"
1848 "\n a.attnum=d.refobjsubid)"
1849 "\nWHERE d.classid='pg_catalog.pg_class'::pg_catalog.regclass"
1850 "\n AND d.refclassid='pg_catalog.pg_class'::pg_catalog.regclass"
1851 "\n AND d.objid='%s'"
1852 "\n AND d.deptype IN ('a', 'i')",
1869 footers[0] =
psprintf(
_(
"Owned by: %s"),
1873 footers[0] =
psprintf(
_(
"Sequence for identity column: %s"),
1884 _(
"Get publications containing this sequence"));
1886 "\nWHERE p.puballsequences"
1887 "\n AND pg_catalog.pg_relation_is_publishable('%s')"
1899 for (
i = 0;
i < nrows;
i++)
1903 if (footers[0] ==
NULL)
1922 myopt.footers = footers;
1923 myopt.topt.default_footer =
false;
1925 myopt.translate_header =
true;
1946 "SELECT e.pgealias AS \"%s\","
1947 "\n pg_catalog.quote_ident(n.nspname) || '.' ||"
1948 "\n pg_catalog.quote_ident(c.relname) AS \"%s\","
1951 "\n s.pgealias as \"%s\","
1952 "\n d.pgealias as \"%s\""
1953 "\n FROM pg_propgraph_element e"
1954 "\n INNER JOIN pg_class c ON c.oid = e.pgerelid"
1955 "\n INNER JOIN pg_namespace n ON c.relnamespace = n.oid"
1956 "\n LEFT JOIN pg_propgraph_element s ON e.pgesrcvertexid = s.oid"
1957 "\n LEFT JOIN pg_propgraph_element d ON e.pgedestvertexid = d.oid"
1958 "\n WHERE e.pgepgid = '%s'"
1959 "\n ORDER BY e.pgealias",
1981 "SELECT pg_catalog.pg_get_propgraphdef('%s'::pg_catalog.oid);",
1989 footers[0] =
pg_strdup(
_(
"Property graph definition:"));
1996 myopt.footers = footers;
1997 myopt.topt.default_footer =
false;
1999 myopt.translate_header =
true;
2029 _(
"Get per-column information for one relation"));
2039 ",\n (SELECT pg_catalog.pg_get_expr(d.adbin, d.adrelid, true)"
2040 "\n FROM pg_catalog.pg_attrdef d"
2041 "\n WHERE d.adrelid = a.attrelid AND d.adnum = a.attnum AND a.atthasdef)"
2042 ",\n a.attnotnull");
2046 " WHERE c.oid = a.attcollation AND t.oid = a.atttypid AND a.attcollation <> t.typcollation) AS attcollation");
2064 appendPQExpBuffer(&
buf,
",\n 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",
2077 " '(' || pg_catalog.array_to_string(ARRAY(SELECT pg_catalog.quote_ident(option_name) || ' ' || pg_catalog.quote_literal(option_value) FROM "
2078 " pg_catalog.pg_options_to_table(attfdwoptions)), ', ') || ')' END AS attfdwoptions");
2105 appendPQExpBufferStr(&
buf,
",\n CASE WHEN a.attstattarget=-1 THEN NULL ELSE a.attstattarget END AS attstattarget");
2126 appendPQExpBuffer(&
buf,
"\nWHERE a.attrelid = '%s' AND a.attnum > 0 AND NOT a.attisdropped", oid);
2226 for (
i = 0;
i < cols;
i++)
2230 for (
i = 0;
i < numrows;
i++)
2308 (compression[0] ==
'l' ?
"lz4" :
2309 (compression[0] ==
'\0' ?
"" :
2333 _(
"Get partitioning information for this partition"));
2335 "SELECT inhparent::pg_catalog.regclass,\n"
2336 " pg_catalog.pg_get_expr(c.relpartbound, c.oid),\n ");
2340 "false as inhdetachpending");
2345 ",\n pg_catalog.pg_get_partition_constraintdef(c.oid)");
2347 "\nFROM pg_catalog.pg_class c"
2348 " JOIN pg_catalog.pg_inherits i"
2349 " ON c.oid = inhrelid"
2350 "\nWHERE c.oid = '%s';", oid);
2390 _(
"Get partitioning information for this table"));
2392 "SELECT pg_catalog.pg_get_partkeydef('%s'::pg_catalog.oid);",
2414 _(
"Get the table that owns this TOAST table"));
2416 "SELECT n.nspname, c.relname\n"
2417 "FROM pg_catalog.pg_class c"
2418 " JOIN pg_catalog.pg_namespace n"
2419 " ON n.oid = c.relnamespace\n"
2420 "WHERE reltoastrelid = '%s';", oid);
2445 "SELECT i.indisunique, i.indisprimary, i.indisclustered, "
2447 " (NOT i.indimmediate) AND "
2448 "EXISTS (SELECT 1 FROM pg_catalog.pg_constraint "
2449 "WHERE conrelid = i.indrelid AND "
2450 "conindid = i.indexrelid AND "
2454 "condeferrable) AS condeferrable,\n"
2455 " (NOT i.indimmediate) AND "
2456 "EXISTS (SELECT 1 FROM pg_catalog.pg_constraint "
2457 "WHERE conrelid = i.indrelid AND "
2458 "conindid = i.indexrelid AND "
2462 "condeferred) AS condeferred,\n");
2475 "pg_catalog.pg_get_expr(i.indpred, i.indrelid, true)\n"
2476 "FROM pg_catalog.pg_index i, pg_catalog.pg_class c, pg_catalog.pg_class c2, pg_catalog.pg_am a\n"
2477 "WHERE i.indexrelid = c.oid AND c.oid = '%s' AND c.relam = a.oid\n"
2478 "AND i.indrelid = c2.oid;",
2493 char *indisclustered =
PQgetvalue(result, 0, 2);
2497 char *indisreplident =
PQgetvalue(result, 0, 6);
2498 char *indnullsnotdistinct =
PQgetvalue(result, 0, 7);
2508 if (
strcmp(indnullsnotdistinct,
"t") == 0)
2518 schemaname, indtable);
2523 if (
strcmp(indisclustered,
"t") == 0)
2529 if (
strcmp(deferrable,
"t") == 0)
2532 if (
strcmp(deferred,
"t") == 0)
2535 if (
strcmp(indisreplident,
"t") == 0)
2567 "SELECT c2.relname, i.indisprimary, i.indisunique, "
2568 "i.indisclustered, i.indisvalid, "
2569 "pg_catalog.pg_get_indexdef(i.indexrelid, 0, true),\n "
2570 "pg_catalog.pg_get_constraintdef(con.oid, true), "
2571 "contype, condeferrable, condeferred");
2582 "\nFROM pg_catalog.pg_class c, pg_catalog.pg_class c2, pg_catalog.pg_index i\n"
2583 " LEFT JOIN pg_catalog.pg_constraint con ON (conrelid = i.indrelid AND conindid = i.indexrelid AND contype IN ("
2587 "WHERE c.oid = '%s' AND c.oid = i.indrelid AND i.indexrelid = c2.oid\n"
2588 "ORDER BY i.indisprimary DESC, c2.relname;",
2599 for (
i = 0;
i < tuples;
i++)
2617 const char *indexdef;
2671 _(
"Get check constraints for this table"));
2673 "SELECT r.conname, "
2674 "pg_catalog.pg_get_constraintdef(r.oid, true)\n"
2675 "FROM pg_catalog.pg_constraint r\n"
2676 "WHERE r.conrelid = '%s' "
2689 for (
i = 0;
i < tuples;
i++)
2704 _(
"Get foreign key constraints for this table"));
2713 "SELECT conrelid = '%s'::pg_catalog.regclass AS sametable,\n"
2715 " pg_catalog.pg_get_constraintdef(oid, true) AS condef,\n"
2716 " conrelid::pg_catalog.regclass AS ontable\n"
2717 " FROM pg_catalog.pg_constraint,\n"
2718 " pg_catalog.pg_partition_ancestors('%s')\n"
2720 "ORDER BY sametable DESC, conname;",
2726 "SELECT true as sametable, conname,\n"
2727 " pg_catalog.pg_get_constraintdef(r.oid, true) as condef,\n"
2728 " conrelid::pg_catalog.regclass AS ontable\n"
2729 "FROM pg_catalog.pg_constraint r\n"
2752 for (
i = 0;
i < tuples;
i++)
2776 _(
"Get foreign keys referencing this table"));
2780 "SELECT conname, conrelid::pg_catalog.regclass AS ontable,\n"
2781 " pg_catalog.pg_get_constraintdef(oid, true) AS condef\n"
2782 " FROM pg_catalog.pg_constraint c\n"
2783 " WHERE confrelid IN (SELECT pg_catalog.pg_partition_ancestors('%s')\n"
2784 " UNION ALL VALUES ('%s'::pg_catalog.regclass))\n"
2786 "ORDER BY conname;",
2792 "SELECT conname, conrelid::pg_catalog.regclass AS ontable,\n"
2793 " pg_catalog.pg_get_constraintdef(oid, true) AS condef\n"
2794 " FROM pg_catalog.pg_constraint\n"
2796 "ORDER BY conname;",
2813 for (
i = 0;
i < tuples;
i++)
2829 _(
"Get row-level policies for this table"));
2833 " pol.polpermissive,\n");
2836 " 't' as polpermissive,\n");
2838 " 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,\n"
2839 " pg_catalog.pg_get_expr(pol.polqual, pol.polrelid),\n"
2840 " pg_catalog.pg_get_expr(pol.polwithcheck, pol.polrelid),\n"
2841 " CASE pol.polcmd\n"
2842 " WHEN 'r' THEN 'SELECT'\n"
2843 " WHEN 'a' THEN 'INSERT'\n"
2844 " WHEN 'w' THEN 'UPDATE'\n"
2845 " WHEN 'd' THEN 'DELETE'\n"
2847 "FROM pg_catalog.pg_policy pol\n"
2848 "WHERE pol.polrelid = '%s' ORDER BY 1;",
2874 if (!
tableinfo.rowsecurity && tuples > 0)
2878 for (
i = 0;
i < tuples;
i++)
2913 _(
"Get extended statistics for this table"));
2916 "stxrelid::pg_catalog.regclass, "
2917 "stxnamespace::pg_catalog.regnamespace::pg_catalog.text AS nsp, "
2919 "pg_catalog.pg_get_statisticsobjdef_columns(oid) AS columns,\n"
2924 "FROM pg_catalog.pg_statistic_ext\n"
2925 "WHERE stxrelid = '%s'\n"
2926 "ORDER BY nsp, stxname;",
2939 for (
i = 0;
i < tuples;
i++)
3013 _(
"Get extended statistics for this table"));
3016 "stxrelid::pg_catalog.regclass, "
3017 "stxnamespace::pg_catalog.regnamespace AS nsp, "
3019 " (SELECT pg_catalog.string_agg(pg_catalog.quote_ident(attname),', ')\n"
3020 " FROM pg_catalog.unnest(stxkeys) s(attnum)\n"
3021 " JOIN pg_catalog.pg_attribute a ON (stxrelid = a.attrelid AND\n"
3022 " a.attnum = s.attnum AND NOT attisdropped)) AS columns,\n"
3032 "WHERE stxrelid = '%s'\n"
3046 for (
i = 0;
i < tuples;
i++)
3094 _(
"Get rules for this relation"));
3096 "SELECT r.rulename, trim(trailing ';' from pg_catalog.pg_get_ruledef(r.oid, true)), "
3098 "FROM pg_catalog.pg_rewrite r\n"
3099 "WHERE r.ev_class = '%s' ORDER BY 1;",
3112 for (category = 0; category < 4; category++)
3116 for (
i = 0;
i < tuples;
i++)
3179 _(
"Get publications that publish this table"));
3186 "FROM pg_catalog.pg_publication p\n"
3187 " JOIN pg_catalog.pg_publication_namespace pn ON p.oid = pn.pnpubid\n"
3188 " JOIN pg_catalog.pg_class pc ON pc.relnamespace = pn.pnnspid\n"
3189 "WHERE pc.oid ='%s' and pg_catalog.pg_relation_is_publishable('%s')\n"
3192 " , pg_get_expr(pr.prqual, c.oid)\n"
3193 " , (CASE WHEN pr.prattrs IS NOT NULL THEN\n"
3194 " (SELECT string_agg(attname, ', ')\n"
3195 " FROM pg_catalog.generate_series(0, pg_catalog.array_upper(pr.prattrs::pg_catalog.int2[], 1)) s,\n"
3196 " pg_catalog.pg_attribute\n"
3197 " WHERE attrelid = pr.prrelid AND attnum = prattrs[s])\n"
3199 "FROM pg_catalog.pg_publication p\n"
3200 " JOIN pg_catalog.pg_publication_rel pr ON p.oid = pr.prpubid\n"
3201 " JOIN pg_catalog.pg_class c ON c.oid = pr.prrelid\n"
3202 "WHERE pr.prrelid = '%s'\n",
3212 " AND NOT pr.prexcept\n"
3217 "FROM pg_catalog.pg_publication p\n"
3218 "WHERE p.puballtables AND pg_catalog.pg_relation_is_publishable('%s')\n"
3219 " AND NOT EXISTS (\n"
3221 " FROM pg_catalog.pg_publication_rel pr\n"
3222 " WHERE pr.prpubid = p.oid AND\n"
3223 " (pr.prrelid = '%s' OR pr.prrelid = pg_catalog.pg_partition_root('%s')))\n"
3234 "FROM pg_catalog.pg_publication p\n"
3235 "WHERE p.puballtables AND pg_catalog.pg_relation_is_publishable('%s')\n"
3246 "FROM pg_catalog.pg_publication p\n"
3247 "JOIN pg_catalog.pg_publication_rel pr ON p.oid = pr.prpubid\n"
3248 "WHERE pr.prrelid = '%s'\n"
3253 "FROM pg_catalog.pg_publication p\n"
3254 "WHERE p.puballtables AND pg_catalog.pg_relation_is_publishable('%s')\n"
3269 for (
i = 0;
i < tuples;
i++)
3293 _(
"Get publications that exclude this table"));
3296 "FROM pg_catalog.pg_publication p\n"
3297 "JOIN pg_catalog.pg_publication_rel pr ON p.oid = pr.prpubid\n"
3298 "WHERE (pr.prrelid = '%s' OR pr.prrelid = pg_catalog.pg_partition_root('%s'))\n"
3300 "ORDER BY 1;", oid, oid);
3312 for (
i = 0;
i < tuples;
i++)
3327 _(
"Get not-null constraints for this table"));
3329 "SELECT c.conname, a.attname, c.connoinherit,\n"
3330 " c.conislocal, c.coninhcount <> 0,\n"
3332 "FROM pg_catalog.pg_constraint c JOIN\n"
3333 " pg_catalog.pg_attribute a ON\n"
3334 " (a.attrelid = c.conrelid AND a.attnum = c.conkey[1])\n"
3336 " c.conrelid = '%s'::pg_catalog.regclass\n"
3337 "ORDER BY a.attnum",
3350 for (
i = 0;
i < tuples;
i++)
3379 "SELECT pg_catalog.pg_get_viewdef('%s'::pg_catalog.oid, true);",
3404 "SELECT r.rulename, trim(trailing ';' from pg_catalog.pg_get_ruledef(r.oid, true))\n"
3405 "FROM pg_catalog.pg_rewrite r\n"
3406 "WHERE r.ev_class = '%s' AND r.rulename != '_RETURN' ORDER BY 1;",
3441 _(
"Get triggers for this relation"));
3444 "pg_catalog.pg_get_triggerdef(t.oid, true), "
3445 "t.tgenabled, t.tgisinternal,\n");
3463 " CASE WHEN t.tgparentid != 0 THEN\n"
3464 " (SELECT u.tgrelid::pg_catalog.regclass\n"
3465 " FROM pg_catalog.pg_trigger AS u,\n"
3466 " pg_catalog.pg_partition_ancestors(t.tgrelid) WITH ORDINALITY AS a(relid, depth)\n"
3467 " WHERE u.tgname = t.tgname AND u.tgrelid = a.relid\n"
3468 " AND u.tgparentid = 0\n"
3469 " ORDER BY a.depth LIMIT 1)\n"
3470 " END AS parent\n");
3475 "FROM pg_catalog.pg_trigger t\n"
3476 "WHERE t.tgrelid = '%s' AND ",
3488 " OR EXISTS (SELECT 1 FROM pg_catalog.pg_depend WHERE objid = t.oid \n"
3489 " AND refclassid = 'pg_catalog.pg_trigger'::pg_catalog.regclass))");
3511 for (category = 0; category <= 4; category++)
3514 for (
i = 0;
i < tuples;
i++)
3519 const char *tgenabled;
3520 const char *tgisinternal;
3531 if (*tgenabled ==
'O' || *tgenabled ==
't')
3535 if ((*tgenabled ==
'D' || *tgenabled ==
'f') &&
3536 *tgisinternal ==
'f')
3540 if ((*tgenabled ==
'D' || *tgenabled ==
'f') &&
3541 *tgisinternal ==
't')
3545 if (*tgenabled ==
'A')
3549 if (*tgenabled ==
'R')
3626 _(
"Get foreign server for this table"));
3628 "SELECT s.srvname,\n"
3629 " pg_catalog.array_to_string(ARRAY(\n"
3630 " SELECT pg_catalog.quote_ident(option_name)"
3631 " || ' ' || pg_catalog.quote_literal(option_value)\n"
3632 " FROM pg_catalog.pg_options_to_table(ftoptions)), ', ')\n"
3633 "FROM pg_catalog.pg_foreign_table f,\n"
3634 " pg_catalog.pg_foreign_server s\n"
3635 "WHERE f.ftrelid = '%s' AND s.oid = f.ftserver;",
3663 _(
"Get inheritance parent tables"));
3665 "SELECT c.oid::pg_catalog.regclass\n"
3666 "FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i\n"
3667 "WHERE c.oid = i.inhparent AND i.inhrelid = '%s'\n"
3670 "\nORDER BY inhseqno;",
3678 const char *s =
_(
"Inherits");
3683 for (
i = 0;
i < tuples;
i++)
3704 "SELECT c.oid::pg_catalog.regclass, c.relkind,"
3705 " inhdetachpending,"
3706 " pg_catalog.pg_get_expr(c.relpartbound, c.oid)\n"
3707 "FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i\n"
3708 "WHERE c.oid = i.inhrelid AND i.inhparent = '%s'\n"
3709 "ORDER BY pg_catalog.pg_get_expr(c.relpartbound, c.oid) = 'DEFAULT',"
3710 " c.oid::pg_catalog.regclass::pg_catalog.text;",
3714 "SELECT c.oid::pg_catalog.regclass, c.relkind,"
3715 " false AS inhdetachpending,"
3716 " pg_catalog.pg_get_expr(c.relpartbound, c.oid)\n"
3717 "FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i\n"
3718 "WHERE c.oid = i.inhrelid AND i.inhparent = '%s'\n"
3719 "ORDER BY pg_catalog.pg_get_expr(c.relpartbound, c.oid) = 'DEFAULT',"
3720 " c.oid::pg_catalog.regclass::pg_catalog.text;",
3724 "SELECT c.oid::pg_catalog.regclass, c.relkind,"
3725 " false AS inhdetachpending, NULL\n"
3726 "FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i\n"
3727 "WHERE c.oid = i.inhrelid AND i.inhparent = '%s'\n"
3728 "ORDER BY c.oid::pg_catalog.regclass::pg_catalog.text;",
3765 for (
i = 0;
i < tuples;
i++)
3808 ((
strcmp(schemaname,
"pg_catalog") != 0 &&
3810 (
strcmp(schemaname,
"pg_catalog") == 0 &&
3813 const char *s =
_(
"Replica Identity");
3844 const char *t =
_(
"Options");
3898 _(
"Get tablespace information for this relation"));
3900 "SELECT spcname FROM pg_catalog.pg_tablespace\n"
3953 const char align =
'l';
3956 myopt.default_footer =
false;
3962 "SELECT r.rolname, r.rolsuper, r.rolinherit,\n"
3963 " r.rolcreaterole, r.rolcreatedb, r.rolcanlogin,\n"
3964 " r.rolconnlimit, r.rolvaliduntil");
4008 for (
i = 0;
i < nrows;
i++)
4070 for (
i = 0;
i < nrows;
i++)
4102 "pg_catalog.array_to_string(setconfig, E'\\n') AS \"%s\"\n"
4103 "FROM pg_catalog.pg_db_role_setting s\n"
4104 "LEFT JOIN pg_catalog.pg_database d ON d.oid = setdatabase\n"
4105 "LEFT JOIN pg_catalog.pg_roles r ON r.oid = setrole\n",
4132 pg_log_error(
"Did not find any settings for role \"%s\" and database \"%s\".",
4135 pg_log_error(
"Did not find any settings for role \"%s\".",
4142 myopt.title =
_(
"List of settings");
4143 myopt.translate_header =
true;
4170 "SELECT m.rolname AS \"%s\", r.rolname AS \"%s\",\n"
4171 " pg_catalog.concat_ws(', ',\n",
4177 " CASE WHEN pam.admin_option THEN 'ADMIN' END,\n"
4178 " CASE WHEN pam.inherit_option THEN 'INHERIT' END,\n"
4179 " CASE WHEN pam.set_option THEN 'SET' END\n");
4182 " CASE WHEN pam.admin_option THEN 'ADMIN' END,\n"
4183 " CASE WHEN m.rolinherit THEN 'INHERIT' END,\n"
4188 " g.rolname AS \"%s\"\n",
4193 "FROM pg_catalog.pg_roles m\n"
4194 " JOIN pg_catalog.pg_auth_members pam ON (pam.member = m.oid)\n"
4195 " LEFT JOIN pg_catalog.pg_roles r ON (pam.roleid = r.oid)\n"
4196 " LEFT JOIN pg_catalog.pg_roles g ON (pam.grantor = g.oid)\n");
4216 myopt.title =
_(
"List of role grants");
4217 myopt.translate_header =
true;
4257 bool translate_columns[] = {
false,
false,
true,
false,
false,
false,
false,
false,
false};
4270 "SELECT n.nspname as \"%s\",\n"
4271 " c.relname as \"%s\",\n"
4284 " pg_catalog.pg_get_userbyid(c.relowner) as \"%s\"",
4304 ",\n c2.relname as \"%s\"",
4315 ",\n CASE c.relpersistence "
4338 ",\n am.amname as \"%s\"",
4342 ",\n pg_catalog.pg_size_pretty(pg_catalog.pg_table_size(c.oid)) as \"%s\""
4343 ",\n pg_catalog.obj_description(c.oid, 'pg_class') as \"%s\"",
4349 "\nFROM pg_catalog.pg_class c"
4350 "\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace");
4355 "\n LEFT JOIN pg_catalog.pg_am am ON am.oid = c.relam");
4359 "\n LEFT JOIN pg_catalog.pg_index i ON i.indexrelid = c.oid"
4360 "\n LEFT JOIN pg_catalog.pg_class c2 ON i.indrelid = c2.oid");
4392 " AND n.nspname !~ '^pg_toast'\n"
4393 " AND n.nspname <> 'information_schema'\n");
4396 "n.nspname",
"c.relname",
NULL,
4397 "pg_catalog.pg_table_is_visible(c.oid)",
4421 pg_log_error(
"Did not find any relations named \"%s\".",
4433 pg_log_error(
"Did not find any materialized views named \"%s\".",
4436 pg_log_error(
"Did not find any sequences named \"%s\".",
4439 pg_log_error(
"Did not find any foreign tables named \"%s\".",
4442 pg_log_error(
"Did not find any property graphs named \"%s\".",
4473 (
ntypes != 1) ?
_(
"List of relations") :
4478 (
showSeq) ?
_(
"List of sequences") :
4482 myopt.translate_header =
true;
4483 myopt.translate_columns = translate_columns;
4518 bool translate_columns[] = {
false,
false,
false,
false,
false,
false,
false,
false,
false,
false};
4529 pg_log_error(
"The server (version %s) does not support declarative table partitioning.",
4553 _(
"Get matching partitioned relations"));
4555 "SELECT n.nspname as \"%s\",\n"
4556 " c.relname as \"%s\",\n"
4557 " pg_catalog.pg_get_userbyid(c.relowner) as \"%s\"",
4565 ",\n CASE c.relkind"
4573 translate_columns[3] =
true;
4578 ",\n inh.inhparent::pg_catalog.regclass as \"%s\"",
4583 ",\n c2.oid::pg_catalog.regclass as \"%s\"",
4598 ",\n s.dps as \"%s\"",
4601 ",\n s.tps as \"%s\"",
4607 ",\n s.tps as \"%s\"",
4611 ",\n pg_catalog.obj_description(c.oid, 'pg_class') as \"%s\"",
4616 "\nFROM pg_catalog.pg_class c"
4617 "\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace");
4621 "\n LEFT JOIN pg_catalog.pg_index i ON i.indexrelid = c.oid"
4622 "\n LEFT JOIN pg_catalog.pg_class c2 ON i.indrelid = c2.oid");
4626 "\n LEFT JOIN pg_catalog.pg_inherits inh ON c.oid = inh.inhrelid");
4631 "\n LEFT JOIN pg_catalog.pg_am am ON c.relam = am.oid");
4636 ",\n LATERAL (WITH RECURSIVE d\n"
4637 " AS (SELECT inhrelid AS oid, 1 AS level\n"
4638 " FROM pg_catalog.pg_inherits\n"
4639 " WHERE inhparent = c.oid\n"
4641 " SELECT inhrelid, level + 1\n"
4642 " FROM pg_catalog.pg_inherits i\n"
4643 " JOIN d ON i.inhparent = d.oid)\n"
4644 " SELECT pg_catalog.pg_size_pretty(sum(pg_catalog.pg_table_size("
4645 "d.oid))) AS tps,\n"
4646 " pg_catalog.pg_size_pretty(sum("
4647 "\n CASE WHEN d.level = 1"
4648 " THEN pg_catalog.pg_table_size(d.oid) ELSE 0 END)) AS dps\n"
4655 ",\n LATERAL (SELECT pg_catalog.pg_size_pretty(sum("
4656 "\n CASE WHEN ppt.isleaf AND ppt.level = 1"
4657 "\n THEN pg_catalog.pg_table_size(ppt.relid)"
4658 " ELSE 0 END)) AS dps"
4659 ",\n pg_catalog.pg_size_pretty(sum("
4660 "pg_catalog.pg_table_size(ppt.relid))) AS tps"
4661 "\n FROM pg_catalog.pg_partition_tree(c.oid) ppt) s");
4674 " AND NOT c.relispartition\n" :
"");
4678 " AND n.nspname !~ '^pg_toast'\n"
4679 " AND n.nspname <> 'information_schema'\n");
4682 "n.nspname",
"c.relname",
NULL,
4683 "pg_catalog.pg_table_is_visible(c.oid)",
4692 showNested || pattern ?
"\"Parent name\" NULLS FIRST, " :
"");
4703 myopt.translate_header =
true;
4704 myopt.translate_columns = translate_columns;
4731 "SELECT l.lanname AS \"%s\",\n"
4732 " pg_catalog.pg_get_userbyid(l.lanowner) as \"%s\",\n"
4733 " l.lanpltrusted AS \"%s\"",
4741 ",\n NOT l.lanispl AS \"%s\",\n"
4742 " l.lanplcallfoid::pg_catalog.regprocedure AS \"%s\",\n"
4743 " l.lanvalidator::pg_catalog.regprocedure AS \"%s\",\n "
4744 "l.laninline::pg_catalog.regprocedure AS \"%s\",\n ",
4753 ",\n d.description AS \"%s\""
4754 "\nFROM pg_catalog.pg_language l\n"
4755 "LEFT JOIN pg_catalog.pg_description d\n"
4756 " ON d.classoid = l.tableoid AND d.objoid = l.oid\n"
4757 " AND d.objsubid = 0\n",
4782 myopt.title =
_(
"List of languages");
4783 myopt.translate_header =
true;
4808 "SELECT n.nspname as \"%s\",\n"
4809 " t.typname as \"%s\",\n"
4810 " pg_catalog.format_type(t.typbasetype, t.typtypmod) as \"%s\",\n"
4811 " (SELECT c.collname FROM pg_catalog.pg_collation c, pg_catalog.pg_type bt\n"
4812 " WHERE c.oid = t.typcollation AND bt.oid = t.typbasetype AND t.typcollation <> bt.typcollation) as \"%s\",\n"
4813 " CASE WHEN t.typnotnull THEN 'not null' END as \"%s\",\n"
4814 " t.typdefault as \"%s\",\n"
4815 " pg_catalog.array_to_string(ARRAY(\n"
4816 " SELECT pg_catalog.pg_get_constraintdef(r.oid, true) FROM pg_catalog.pg_constraint r WHERE t.oid = r.contypid AND r.contype = " CppAsString2(
CONSTRAINT_CHECK)
" ORDER BY r.conname\n"
4817 " ), ' ') as \"%s\"",
4831 ",\n d.description as \"%s\"",
4836 "\nFROM pg_catalog.pg_type t\n"
4837 " LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace\n");
4841 " LEFT JOIN pg_catalog.pg_description d "
4842 "ON d.classoid = t.tableoid AND d.objoid = t.oid "
4843 "AND d.objsubid = 0\n");
4849 " AND n.nspname <> 'information_schema'\n");
4852 "n.nspname",
"t.typname",
NULL,
4853 "pg_catalog.pg_type_is_visible(t.oid)",
4867 myopt.title =
_(
"List of domains");
4868 myopt.translate_header =
true;
4887 static const bool translate_columns[] =
4888 {
false,
false,
false,
false,
true,
false};
4894 "SELECT n.nspname AS \"%s\",\n"
4895 " c.conname AS \"%s\",\n"
4896 " pg_catalog.pg_encoding_to_char(c.conforencoding) AS \"%s\",\n"
4897 " pg_catalog.pg_encoding_to_char(c.contoencoding) AS \"%s\",\n"
4898 " CASE WHEN c.condefault THEN '%s'\n"
4899 " ELSE '%s' END AS \"%s\"",
4909 ",\n d.description AS \"%s\"",
4913 "\nFROM pg_catalog.pg_conversion c\n"
4914 " JOIN pg_catalog.pg_namespace n "
4915 "ON n.oid = c.connamespace\n");
4919 "LEFT JOIN pg_catalog.pg_description d "
4920 "ON d.classoid = c.tableoid\n"
4921 " AND d.objoid = c.oid "
4922 "AND d.objsubid = 0\n");
4928 " AND n.nspname <> 'information_schema'\n");
4931 "n.nspname",
"c.conname",
NULL,
4932 "pg_catalog.pg_conversion_is_visible(c.oid)",
4946 myopt.title =
_(
"List of conversions");
4947 myopt.translate_header =
true;
4948 myopt.translate_columns = translate_columns;
4973 _(
"Get matching configuration parameters"));
4975 "SELECT s.name AS \"%s\", "
4976 "pg_catalog.current_setting(s.name) AS \"%s\"",
4983 ", s.vartype AS \"%s\", s.context AS \"%s\", ",
4997 " LEFT JOIN pg_catalog.pg_parameter_acl p\n"
4998 " ON pg_catalog.lower(s.name) = p.parname\n");
5003 NULL,
"pg_catalog.lower(s.name)",
NULL,
5007 " s.setting IS DISTINCT FROM s.boot_val\n");
5017 myopt.title =
_(
"List of configuration parameters");
5019 myopt.title =
_(
"List of non-default configuration parameters");
5020 myopt.translate_header =
true;
5039 static const bool translate_columns[] =
5040 {
false,
false,
false,
true,
false,
false,
false};
5046 pg_log_error(
"The server (version %s) does not support event triggers.",
5056 "SELECT evtname as \"%s\", "
5057 "evtevent as \"%s\", "
5058 "pg_catalog.pg_get_userbyid(e.evtowner) as \"%s\",\n"
5059 " case evtenabled when 'O' then '%s'"
5060 " when 'R' then '%s'"
5061 " when 'A' then '%s'"
5062 " when 'D' then '%s' end as \"%s\",\n"
5063 " e.evtfoid::pg_catalog.regproc as \"%s\", "
5064 "pg_catalog.array_to_string(array(select x"
5065 " from pg_catalog.unnest(evttags) as t(x)), ', ') as \"%s\"",
5078 ",\npg_catalog.obj_description(e.oid, 'pg_event_trigger') as \"%s\"",
5081 "\nFROM pg_catalog.pg_event_trigger e ");
5098 myopt.title =
_(
"List of event triggers");
5099 myopt.translate_header =
true;
5100 myopt.translate_columns = translate_columns;
5125 pg_log_error(
"The server (version %s) does not support extended statistics.",
5136 "es.stxnamespace::pg_catalog.regnamespace::pg_catalog.text AS \"%s\", \n"
5137 "es.stxname AS \"%s\", \n",
5143 "pg_catalog.format('%%s FROM %%s', \n"
5144 " pg_catalog.pg_get_statisticsobjdef_columns(es.oid), \n"
5145 " es.stxrelid::pg_catalog.regclass) AS \"%s\"",
5149 "pg_catalog.format('%%s FROM %%s', \n"
5150 " (SELECT pg_catalog.string_agg(pg_catalog.quote_ident(a.attname),', ') \n"
5151 " FROM pg_catalog.unnest(es.stxkeys) s(attnum) \n"
5152 " JOIN pg_catalog.pg_attribute a \n"
5153 " ON (es.stxrelid = a.attrelid \n"
5154 " AND a.attnum = s.attnum \n"
5155 " AND NOT a.attisdropped)), \n"
5156 "es.stxrelid::pg_catalog.regclass) AS \"%s\"",
5180 ", \npg_catalog.obj_description(oid, 'pg_statistic_ext') AS \"%s\"\n",
5184 " \nFROM pg_catalog.pg_statistic_ext es \n");
5188 "es.stxnamespace::pg_catalog.regnamespace::pg_catalog.text",
"es.stxname",
5189 NULL,
"pg_catalog.pg_statistics_obj_is_visible(es.oid)",
5203 myopt.title =
_(
"List of extended statistics");
5204 myopt.translate_header =
true;
5223 static const bool translate_columns[] = {
false,
false,
false,
true,
true,
false};
5229 "SELECT pg_catalog.format_type(castsource, NULL) AS \"%s\",\n"
5230 " pg_catalog.format_type(casttarget, NULL) AS \"%s\",\n",
5240 " CASE WHEN c.castmethod = '%c' THEN '(binary coercible)'\n"
5241 " WHEN c.castmethod = '%c' THEN '(with inout)'\n"
5243 " END AS \"%s\",\n",
5249 " CASE WHEN c.castcontext = '%c' THEN '%s'\n"
5250 " WHEN c.castcontext = '%c' THEN '%s'\n"
5262 ",\n CASE WHEN p.proleakproof THEN '%s'\n"
5265 " d.description AS \"%s\"",
5276 "\nFROM pg_catalog.pg_cast c LEFT JOIN pg_catalog.pg_proc p\n"
5277 " ON c.castfunc = p.oid\n"
5278 " LEFT JOIN pg_catalog.pg_type ts\n"
5279 " ON c.castsource = ts.oid\n"
5280 " LEFT JOIN pg_catalog.pg_namespace ns\n"
5281 " ON ns.oid = ts.typnamespace\n"
5282 " LEFT JOIN pg_catalog.pg_type tt\n"
5283 " ON c.casttarget = tt.oid\n"
5284 " LEFT JOIN pg_catalog.pg_namespace nt\n"
5285 " ON nt.oid = tt.typnamespace\n");
5289 " LEFT JOIN pg_catalog.pg_description d\n"
5290 " ON d.classoid = c.tableoid AND d.objoid = "
5291 "c.oid AND d.objsubid = 0\n");
5300 "ns.nspname",
"ts.typname",
5301 "pg_catalog.format_type(ts.oid, NULL)",
5302 "pg_catalog.pg_type_is_visible(ts.oid)",
5309 "nt.nspname",
"tt.typname",
5310 "pg_catalog.format_type(tt.oid, NULL)",
5311 "pg_catalog.pg_type_is_visible(tt.oid)",
5322 myopt.title =
_(
"List of casts");
5323 myopt.translate_header =
true;
5324 myopt.translate_columns = translate_columns;
5348 static const bool translate_columns[] = {
false,
false,
false,
false,
false,
false,
false,
true,
false};
5355 " n.nspname AS \"%s\",\n"
5356 " c.collname AS \"%s\",\n",
5362 " CASE c.collprovider "
5371 " 'libc' AS \"%s\",\n",
5375 " c.collcollate AS \"%s\",\n"
5376 " c.collctype AS \"%s\",\n",
5382 " c.colllocale AS \"%s\",\n",
5386 " c.colliculocale AS \"%s\",\n",
5390 " c.collcollate AS \"%s\",\n",
5395 " c.collicurules AS \"%s\",\n",
5399 " NULL AS \"%s\",\n",
5404 " CASE WHEN c.collisdeterministic THEN '%s' ELSE '%s' END AS \"%s\"",
5415 ",\n pg_catalog.obj_description(c.oid, 'pg_collation') AS \"%s\"",
5419 "\nFROM pg_catalog.pg_collation c, pg_catalog.pg_namespace n\n"
5420 "WHERE n.oid = c.collnamespace\n");
5424 " AND n.nspname <> 'information_schema'\n");
5432 appendPQExpBufferStr(&
buf,
" AND c.collencoding IN (-1, pg_catalog.pg_char_to_encoding(pg_catalog.getdatabaseencoding()))\n");
5435 "n.nspname",
"c.collname",
NULL,
5436 "pg_catalog.pg_collation_is_visible(c.oid)",
5450 myopt.title =
_(
"List of collations");
5451 myopt.translate_header =
true;
5452 myopt.translate_columns = translate_columns;
5473 char **footers =
NULL;
5479 "SELECT n.nspname AS \"%s\",\n"
5480 " pg_catalog.pg_get_userbyid(n.nspowner) AS \"%s\"",
5489 ",\n pg_catalog.obj_description(n.oid, 'pg_namespace') AS \"%s\"",
5494 "\nFROM pg_catalog.pg_namespace n\n");
5498 "WHERE n.nspname !~ '^pg_' AND n.nspname <> 'information_schema'\n");
5513 myopt.title =
_(
"List of schemas");
5514 myopt.translate_header =
true;
5522 _(
"Get publications that publish this schema"));
5525 "FROM pg_catalog.pg_publication p\n"
5526 " JOIN pg_catalog.pg_publication_namespace pn ON p.oid = pn.pnpubid\n"
5527 " JOIN pg_catalog.pg_namespace n ON n.oid = pn.pnnspid \n"
5528 "WHERE n.nspname = '%s'\n"
5556 footers[
i + 1] =
NULL;
5557 myopt.footers = footers;
5571 char **footer =
NULL;
5573 for (footer = footers; *footer; footer++)
5606 " n.nspname as \"%s\",\n"
5607 " p.prsname as \"%s\",\n"
5608 " pg_catalog.obj_description(p.oid, 'pg_ts_parser') as \"%s\"\n"
5609 "FROM pg_catalog.pg_ts_parser p\n"
5610 "LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.prsnamespace\n",
5617 "n.nspname",
"p.prsname",
NULL,
5618 "pg_catalog.pg_ts_parser_is_visible(p.oid)",
5632 myopt.title =
_(
"List of text search parsers");
5633 myopt.translate_header =
true;
5658 "FROM pg_catalog.pg_ts_parser p\n"
5659 "LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.prsnamespace\n"
5663 "n.nspname",
"p.prsname",
NULL,
5664 "pg_catalog.pg_ts_parser_is_visible(p.oid)",
5683 pg_log_error(
"Did not find any text search parser named \"%s\".",
5695 const char *nspname =
NULL;
5727 static const bool translate_columns[] = {
true,
false,
false};
5733 "SELECT '%s' AS \"%s\",\n"
5734 " p.prsstart::pg_catalog.regproc AS \"%s\",\n"
5735 " pg_catalog.obj_description(p.prsstart, 'pg_proc') as \"%s\"\n"
5736 " FROM pg_catalog.pg_ts_parser p\n"
5737 " WHERE p.oid = '%s'\n"
5740 " p.prstoken::pg_catalog.regproc,\n"
5741 " pg_catalog.obj_description(p.prstoken, 'pg_proc')\n"
5742 " FROM pg_catalog.pg_ts_parser p\n"
5743 " WHERE p.oid = '%s'\n"
5746 " p.prsend::pg_catalog.regproc,\n"
5747 " pg_catalog.obj_description(p.prsend, 'pg_proc')\n"
5748 " FROM pg_catalog.pg_ts_parser p\n"
5749 " WHERE p.oid = '%s'\n"
5752 " p.prsheadline::pg_catalog.regproc,\n"
5753 " pg_catalog.obj_description(p.prsheadline, 'pg_proc')\n"
5754 " FROM pg_catalog.pg_ts_parser p\n"
5755 " WHERE p.oid = '%s'\n"
5758 " p.prslextype::pg_catalog.regproc,\n"
5759 " pg_catalog.obj_description(p.prslextype, 'pg_proc')\n"
5760 " FROM pg_catalog.pg_ts_parser p\n"
5761 " WHERE p.oid = '%s';",
5789 myopt.topt.default_footer =
false;
5790 myopt.translate_header =
true;
5791 myopt.translate_columns = translate_columns;
5801 _(
"Get text search parser token types"));
5803 "SELECT t.alias as \"%s\",\n"
5804 " t.description as \"%s\"\n"
5805 "FROM pg_catalog.ts_token_type( '%s'::pg_catalog.oid ) as t\n"
5826 myopt.topt.default_footer =
true;
5827 myopt.translate_header =
true;
5829 myopt.n_translate_columns = 0;
5855 " n.nspname as \"%s\",\n"
5856 " d.dictname as \"%s\",\n",
5863 " ( SELECT COALESCE(nt.nspname, '(null)')::pg_catalog.text || '.' || t.tmplname FROM\n"
5864 " pg_catalog.pg_ts_template t\n"
5865 " LEFT JOIN pg_catalog.pg_namespace nt ON nt.oid = t.tmplnamespace\n"
5866 " WHERE d.dicttemplate = t.oid ) AS \"%s\",\n"
5867 " d.dictinitoption as \"%s\",\n",
5873 " pg_catalog.obj_description(d.oid, 'pg_ts_dict') as \"%s\"\n",
5877 "LEFT JOIN pg_catalog.pg_namespace n ON n.oid = d.dictnamespace\n");
5880 "n.nspname",
"d.dictname",
NULL,
5881 "pg_catalog.pg_ts_dict_is_visible(d.oid)",
5895 myopt.title =
_(
"List of text search dictionaries");
5896 myopt.translate_header =
true;
5922 " n.nspname AS \"%s\",\n"
5923 " t.tmplname AS \"%s\",\n"
5924 " t.tmplinit::pg_catalog.regproc AS \"%s\",\n"
5925 " t.tmpllexize::pg_catalog.regproc AS \"%s\",\n"
5926 " pg_catalog.obj_description(t.oid, 'pg_ts_template') AS \"%s\"\n",
5935 " n.nspname AS \"%s\",\n"
5936 " t.tmplname AS \"%s\",\n"
5937 " pg_catalog.obj_description(t.oid, 'pg_ts_template') AS \"%s\"\n",
5943 "LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.tmplnamespace\n");
5946 "n.nspname",
"t.tmplname",
NULL,
5947 "pg_catalog.pg_ts_template_is_visible(t.oid)",
5961 myopt.title =
_(
"List of text search templates");
5962 myopt.translate_header =
true;
5990 " n.nspname as \"%s\",\n"
5991 " c.cfgname as \"%s\",\n"
5992 " pg_catalog.obj_description(c.oid, 'pg_ts_config') as \"%s\"\n"
5993 "FROM pg_catalog.pg_ts_config c\n"
5994 "LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.cfgnamespace\n",
6001 "n.nspname",
"c.cfgname",
NULL,
6002 "pg_catalog.pg_ts_config_is_visible(c.oid)",
6016 myopt.title =
_(
"List of text search configurations");
6017 myopt.translate_header =
true;
6036 "SELECT c.oid, c.cfgname,\n"
6039 " np.nspname as pnspname\n"
6040 "FROM pg_catalog.pg_ts_config c\n"
6041 " LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.cfgnamespace,\n"
6042 " pg_catalog.pg_ts_parser p\n"
6043 " LEFT JOIN pg_catalog.pg_namespace np ON np.oid = p.prsnamespace\n"
6044 "WHERE p.oid = c.cfgparser\n"
6048 "n.nspname",
"c.cfgname",
NULL,
6049 "pg_catalog.pg_ts_config_is_visible(c.oid)",
6068 pg_log_error(
"Did not find any text search configuration named \"%s\".",
6071 pg_log_error(
"Did not find any text search configurations.");
6080 const char *cfgname;
6081 const char *nspname =
NULL;
6124 " ( SELECT t.alias FROM\n"
6125 " pg_catalog.ts_token_type(c.cfgparser) AS t\n"
6126 " WHERE t.tokid = m.maptokentype ) AS \"%s\",\n"
6127 " pg_catalog.btrim(\n"
6128 " ARRAY( SELECT mm.mapdict::pg_catalog.regdictionary\n"
6129 " FROM pg_catalog.pg_ts_config_map AS mm\n"
6130 " WHERE mm.mapcfg = m.mapcfg AND mm.maptokentype = m.maptokentype\n"
6131 " ORDER BY mapcfg, maptokentype, mapseqno\n"
6132 " ) :: pg_catalog.text,\n"
6133 " '{}') AS \"%s\"\n"
6134 "FROM pg_catalog.pg_ts_config AS c, pg_catalog.pg_ts_config_map AS m\n"
6135 "WHERE c.oid = '%s' AND m.mapcfg = c.oid\n"
6136 "GROUP BY m.mapcfg, m.maptokentype, c.cfgparser\n"
6165 myopt.topt.default_footer =
false;
6166 myopt.translate_header =
true;
6193 "SELECT fdw.fdwname AS \"%s\",\n"
6194 " pg_catalog.pg_get_userbyid(fdw.fdwowner) AS \"%s\",\n"
6195 " fdw.fdwhandler::pg_catalog.regproc AS \"%s\",\n"
6196 " fdw.fdwvalidator::pg_catalog.regproc AS \"%s\"",
6207 ",\n CASE WHEN fdwoptions IS NULL THEN '' ELSE "
6208 " '(' || pg_catalog.array_to_string(ARRAY(SELECT "
6209 " pg_catalog.quote_ident(option_name) || ' ' || "
6210 " pg_catalog.quote_literal(option_value) FROM "
6211 " pg_catalog.pg_options_to_table(fdwoptions)), ', ') || ')' "
6213 ",\n d.description AS \"%s\" ",
6222 "LEFT JOIN pg_catalog.pg_description d\n"
6223 " ON d.classoid = fdw.tableoid "
6224 "AND d.objoid = fdw.oid AND d.objsubid = 0\n");
6241 myopt.title =
_(
"List of foreign-data wrappers");
6242 myopt.translate_header =
true;
6266 "SELECT s.srvname AS \"%s\",\n"
6267 " pg_catalog.pg_get_userbyid(s.srvowner) AS \"%s\",\n"
6268 " f.fdwname AS \"%s\"",
6279 " s.srvtype AS \"%s\",\n"
6280 " s.srvversion AS \"%s\",\n"
6281 " CASE WHEN srvoptions IS NULL THEN '' ELSE "
6282 " '(' || pg_catalog.array_to_string(ARRAY(SELECT "
6283 " pg_catalog.quote_ident(option_name) || ' ' || "
6284 " pg_catalog.quote_literal(option_value) FROM "
6285 " pg_catalog.pg_options_to_table(srvoptions)), ', ') || ')' "
6287 " d.description AS \"%s\"",
6295 "\nFROM pg_catalog.pg_foreign_server s\n"
6296 " JOIN pg_catalog.pg_foreign_data_wrapper f ON f.oid=s.srvfdw\n");
6300 "LEFT JOIN pg_catalog.pg_description d\n "
6301 "ON d.classoid = s.tableoid AND d.objoid = s.oid "
6302 "AND d.objsubid = 0\n");
6319 myopt.title =
_(
"List of foreign servers");
6320 myopt.translate_header =
true;
6344 "SELECT um.srvname AS \"%s\",\n"
6345 " um.usename AS \"%s\"",
6351 ",\n CASE WHEN umoptions IS NULL THEN '' ELSE "
6352 " '(' || pg_catalog.array_to_string(ARRAY(SELECT "
6353 " pg_catalog.quote_ident(option_name) || ' ' || "
6354 " pg_catalog.quote_literal(option_value) FROM "
6355 " pg_catalog.pg_options_to_table(umoptions)), ', ') || ')' "
6362 NULL,
"um.srvname",
"um.usename",
NULL,
6376 myopt.title =
_(
"List of user mappings");
6377 myopt.translate_header =
true;
6401 "SELECT n.nspname AS \"%s\",\n"
6402 " c.relname AS \"%s\",\n"
6403 " s.srvname AS \"%s\"",
6410 ",\n CASE WHEN ftoptions IS NULL THEN '' ELSE "
6411 " '(' || pg_catalog.array_to_string(ARRAY(SELECT "
6412 " pg_catalog.quote_ident(option_name) || ' ' || "
6413 " pg_catalog.quote_literal(option_value) FROM "
6414 " pg_catalog.pg_options_to_table(ftoptions)), ', ') || ')' "
6416 " d.description AS \"%s\"",
6421 "\nFROM pg_catalog.pg_foreign_table ft\n"
6422 " INNER JOIN pg_catalog.pg_class c"
6423 " ON c.oid = ft.ftrelid\n"
6424 " INNER JOIN pg_catalog.pg_namespace n"
6425 " ON n.oid = c.relnamespace\n"
6426 " INNER JOIN pg_catalog.pg_foreign_server s"
6427 " ON s.oid = ft.ftserver\n");
6430 " LEFT JOIN pg_catalog.pg_description d\n"
6431 " ON d.classoid = c.tableoid AND "
6432 "d.objoid = c.oid AND d.objsubid = 0\n");
6435 "n.nspname",
"c.relname",
NULL,
6436 "pg_catalog.pg_table_is_visible(c.oid)",
6450 myopt.title =
_(
"List of foreign tables");
6451 myopt.translate_header =
true;
6475 "SELECT e.extname AS \"%s\", "
6476 "e.extversion AS \"%s\", ae.default_version AS \"%s\","
6477 "n.nspname AS \"%s\", d.description AS \"%s\"\n"
6478 "FROM pg_catalog.pg_extension e "
6479 "LEFT JOIN pg_catalog.pg_namespace n ON n.oid = e.extnamespace "
6480 "LEFT JOIN pg_catalog.pg_description d ON d.objoid = e.oid "
6481 "AND d.classoid = 'pg_catalog.pg_extension'::pg_catalog.regclass "
6482 "LEFT JOIN pg_catalog.pg_available_extensions() ae(name, default_version, comment) ON ae.name = e.extname\n",
6506 myopt.title =
_(
"List of installed extensions");
6507 myopt.translate_header =
true;
6531 "SELECT e.extname, e.oid\n"
6532 "FROM pg_catalog.pg_extension e\n");
6556 pg_log_error(
"Did not find any extension named \"%s\".",
6567 const char *extname;
6601 "SELECT pg_catalog.pg_describe_object(classid, objid, 0) AS \"%s\"\n"
6602 "FROM pg_catalog.pg_depend\n"
6603 "WHERE refclassid = 'pg_catalog.pg_extension'::pg_catalog.regclass AND refobjid = '%s' AND deptype = 'e'\n"
6616 myopt.translate_header =
true;
6655 pg_log_error(
"improper qualified name (too many dotted names): %s",
6664 pg_log_error(
"You are currently not connected to a database.");
6669 pg_log_error(
"cross-database references are not implemented: %s",
6694 static const bool translate_columns[] = {
false,
false,
false,
false,
false,
false,
false,
false,
false,
false};
6700 pg_log_error(
"The server (version %s) does not support publications.",
6710 "SELECT pubname AS \"%s\",\n"
6711 " pg_catalog.pg_get_userbyid(pubowner) AS \"%s\",\n"
6712 " puballtables AS \"%s\"",
6719 ",\n puballsequences AS \"%s\"",
6723 ",\n pubinsert AS \"%s\",\n"
6724 " pubupdate AS \"%s\",\n"
6725 " pubdelete AS \"%s\"",
6731 ",\n pubtruncate AS \"%s\"",
6735 ",\n (CASE pubgencols\n"
6736 " WHEN '%c' THEN 'none'\n"
6737 " WHEN '%c' THEN 'stored'\n"
6744 ",\n pubviaroot AS \"%s\"",
6748 "\nFROM pg_catalog.pg_publication\n");
6766 myopt.title =
_(
"List of publications");
6767 myopt.translate_header =
true;
6768 myopt.translate_columns = translate_columns;
6798 for (
i = 0;
i < count;
i++)
6847 pg_log_error(
"The server (version %s) does not support publications.",
6862 "SELECT oid, pubname,\n"
6863 " pg_catalog.pg_get_userbyid(pubowner) AS owner,\n"
6868 ", puballsequences");
6871 ", false AS puballsequences");
6874 ", pubinsert, pubupdate, pubdelete");
6881 ", false AS pubtruncate");
6885 ", (CASE pubgencols\n"
6886 " WHEN '%c' THEN 'none'\n"
6887 " WHEN '%c' THEN 'stored'\n"
6888 " END) AS \"%s\"\n",
6894 ", 'none' AS pubgencols");
6901 ", false AS pubviaroot");
6904 ", pg_catalog.obj_description(oid, 'pg_publication')");
6907 "\nFROM pg_catalog.pg_publication\n");
6932 pg_log_error(
"Did not find any publication named \"%s\".",
6954 const char align =
'l';
6998 _(
"Get tables published by this publication"));
7003 ", pg_get_expr(pr.prqual, c.oid)");
7005 ", (CASE WHEN pr.prattrs IS NOT NULL THEN\n"
7006 " pg_catalog.array_to_string("
7007 " ARRAY(SELECT attname\n"
7009 " pg_catalog.generate_series(0, pg_catalog.array_upper(pr.prattrs::pg_catalog.int2[], 1)) s,\n"
7010 " pg_catalog.pg_attribute\n"
7011 " WHERE attrelid = c.oid AND attnum = prattrs[s]), ', ')\n"
7018 "\nFROM pg_catalog.pg_class c,\n"
7019 " pg_catalog.pg_namespace n,\n"
7020 " pg_catalog.pg_publication_rel pr\n"
7021 "WHERE c.relnamespace = n.oid\n"
7022 " AND c.oid = pr.prrelid\n"
7023 " AND pr.prpubid = '%s'\n", pubid);
7036 _(
"Get schemas published by this publication"));
7038 "SELECT n.nspname\n"
7039 "FROM pg_catalog.pg_namespace n\n"
7040 " JOIN pg_catalog.pg_publication_namespace pn ON n.oid = pn.pnnspid\n"
7041 "WHERE pn.pnpubid = '%s'\n"
7042 "ORDER BY 1", pubid);
7054 _(
"Get tables excluded by this publication"));
7056 "SELECT n.nspname || '.' || c.relname\n"
7057 "FROM pg_catalog.pg_class c\n"
7058 " JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n"
7059 " JOIN pg_catalog.pg_publication_rel pr ON c.oid = pr.prrelid\n"
7060 "WHERE pr.prpubid = '%s' AND pr.prexcept\n"
7061 "ORDER BY 1", pubid);
7099 static const bool translate_columns[] = {
false,
false,
false,
false,
7100 false,
false,
false,
false,
false,
false,
false,
false,
false,
false,
7101 false,
false,
false,
false,
false,
false,
false};
7107 pg_log_error(
"The server (version %s) does not support subscriptions.",
7117 "SELECT subname AS \"%s\"\n"
7118 ", pg_catalog.pg_get_userbyid(subowner) AS \"%s\"\n"
7119 ", subenabled AS \"%s\"\n"
7120 ", subpublications AS \"%s\"\n",
7132 ", subbinary AS \"%s\"\n",
7137 ", (CASE substream\n"
7141 " END) AS \"%s\"\n",
7145 ", substream AS \"%s\"\n",
7152 ", subtwophasestate AS \"%s\"\n"
7153 ", subdisableonerr AS \"%s\"\n",
7159 ", suborigin AS \"%s\"\n"
7160 ", subpasswordrequired AS \"%s\"\n"
7161 ", subrunasowner AS \"%s\"\n",
7168 ", subfailover AS \"%s\"\n",
7173 ", (select srvname from pg_foreign_server where oid=subserver) AS \"%s\"\n",
7177 ", subretaindeadtuples AS \"%s\"\n",
7181 ", submaxretention AS \"%s\"\n",
7185 ", subretentionactive AS \"%s\"\n",
7190 ", subsynccommit AS \"%s\"\n"
7191 ", subconninfo AS \"%s\"\n",
7197 ", subwalrcvtimeout AS \"%s\"\n",
7203 ", subskiplsn AS \"%s\"\n",
7207 ", pg_catalog.obj_description(oid, 'pg_subscription') AS \"%s\"\n",
7213 "FROM pg_catalog.pg_subscription\n"
7214 "WHERE subdbid = (SELECT oid\n"
7215 " FROM pg_catalog.pg_database\n"
7216 " WHERE datname = pg_catalog.current_database())");
7234 myopt.title =
_(
"List of subscriptions");
7235 myopt.translate_header =
true;
7236 myopt.translate_columns = translate_columns;
7260 " WHEN pg_catalog.array_length(%s, 1) = 0 THEN '%s'"
7261 " ELSE pg_catalog.array_to_string(%s, E'\\n')"
7281 static const bool translate_columns[] = {
false,
false,
false,
false,
false,
false,
false};
7288 " am.amname AS \"%s\",\n"
7289 " pg_catalog.format_type(c.opcintype, NULL) AS \"%s\",\n"
7291 " WHEN c.opckeytype <> 0 AND c.opckeytype <> c.opcintype\n"
7292 " THEN pg_catalog.format_type(c.opckeytype, NULL)\n"
7296 " WHEN pg_catalog.pg_opclass_is_visible(c.oid)\n"
7297 " THEN pg_catalog.format('%%I', c.opcname)\n"
7298 " ELSE pg_catalog.format('%%I.%%I', n.nspname, c.opcname)\n"
7300 " (CASE WHEN c.opcdefault\n"
7314 " WHEN pg_catalog.pg_opfamily_is_visible(of.oid)\n"
7315 " THEN pg_catalog.format('%%I', of.opfname)\n"
7316 " ELSE pg_catalog.format('%%I.%%I', ofn.nspname, of.opfname)\n"
7318 " pg_catalog.pg_get_userbyid(c.opcowner) AS \"%s\"\n",
7322 "\nFROM pg_catalog.pg_opclass c\n"
7323 " LEFT JOIN pg_catalog.pg_am am on am.oid = c.opcmethod\n"
7324 " LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.opcnamespace\n"
7325 " LEFT JOIN pg_catalog.pg_type t ON t.oid = c.opcintype\n"
7326 " LEFT JOIN pg_catalog.pg_namespace tn ON tn.oid = t.typnamespace\n");
7329 " LEFT JOIN pg_catalog.pg_opfamily of ON of.oid = c.opcfamily\n"
7330 " LEFT JOIN pg_catalog.pg_namespace ofn ON ofn.oid = of.opfnamespace\n");
7341 "tn.nspname",
"t.typname",
7342 "pg_catalog.format_type(t.oid, NULL)",
7343 "pg_catalog.pg_type_is_visible(t.oid)",
7354 myopt.title =
_(
"List of operator classes");
7355 myopt.translate_header =
true;
7356 myopt.translate_columns = translate_columns;
7383 static const bool translate_columns[] = {
false,
false,
false,
false};
7390 " am.amname AS \"%s\",\n"
7392 " WHEN pg_catalog.pg_opfamily_is_visible(f.oid)\n"
7393 " THEN pg_catalog.format('%%I', f.opfname)\n"
7394 " ELSE pg_catalog.format('%%I.%%I', n.nspname, f.opfname)\n"
7397 " pg_catalog.string_agg(pg_catalog.format_type(oc.opcintype, NULL), ', ')\n"
7398 " FROM pg_catalog.pg_opclass oc\n"
7399 " WHERE oc.opcfamily = f.oid) \"%s\"",
7405 ",\n pg_catalog.pg_get_userbyid(f.opfowner) AS \"%s\"\n",
7408 "\nFROM pg_catalog.pg_opfamily f\n"
7409 " LEFT JOIN pg_catalog.pg_am am on am.oid = f.opfmethod\n"
7410 " LEFT JOIN pg_catalog.pg_namespace n ON n.oid = f.opfnamespace\n");
7422 " FROM pg_catalog.pg_type t\n"
7423 " JOIN pg_catalog.pg_opclass oc ON oc.opcintype = t.oid\n"
7424 " LEFT JOIN pg_catalog.pg_namespace tn ON tn.oid = t.typnamespace\n"
7425 " WHERE oc.opcfamily = f.oid\n",
7429 "tn.nspname",
"t.typname",
7430 "pg_catalog.format_type(t.oid, NULL)",
7431 "pg_catalog.pg_type_is_visible(t.oid)",
7443 myopt.title =
_(
"List of operator families");
7444 myopt.translate_header =
true;
7445 myopt.translate_columns = translate_columns;
7474 static const bool translate_columns[] = {
false,
false,
false,
false,
false,
false,
true};
7481 " am.amname AS \"%s\",\n"
7483 " WHEN pg_catalog.pg_opfamily_is_visible(of.oid)\n"
7484 " THEN pg_catalog.format('%%I', of.opfname)\n"
7485 " ELSE pg_catalog.format('%%I.%%I', nsf.nspname, of.opfname)\n"
7487 " o.amopopr::pg_catalog.regoperator AS \"%s\"\n,"
7488 " o.amopstrategy AS \"%s\",\n"
7489 " CASE o.amoppurpose\n"
7503 ", ofs.opfname AS \"%s\",\n"
7505 " WHEN p.proleakproof THEN '%s'\n"
7513 "FROM pg_catalog.pg_amop o\n"
7514 " LEFT JOIN pg_catalog.pg_opfamily of ON of.oid = o.amopfamily\n"
7515 " LEFT JOIN pg_catalog.pg_am am ON am.oid = of.opfmethod AND am.oid = o.amopmethod\n"
7516 " LEFT JOIN pg_catalog.pg_namespace nsf ON of.opfnamespace = nsf.oid\n");
7519 " LEFT JOIN pg_catalog.pg_opfamily ofs ON ofs.oid = o.amopsortfamily\n"
7520 " LEFT JOIN pg_catalog.pg_operator op ON op.oid = o.amopopr\n"
7521 " LEFT JOIN pg_catalog.pg_proc p ON p.oid = op.oprcode\n");
7526 false,
false,
NULL,
"am.amname",
7535 "nsf.nspname",
"of.opfname",
NULL,
NULL,
7541 " o.amoplefttype = o.amoprighttype DESC,\n"
7542 " pg_catalog.format_type(o.amoplefttype, NULL),\n"
7543 " pg_catalog.format_type(o.amoprighttype, NULL),\n"
7544 " o.amopstrategy;");
7551 myopt.title =
_(
"List of operators of operator families");
7552 myopt.translate_header =
true;
7553 myopt.translate_columns = translate_columns;
7581 static const bool translate_columns[] = {
false,
false,
false,
false,
false,
false};
7586 _(
"Get support functions of matching operator families"));
7589 " am.amname AS \"%s\",\n"
7591 " WHEN pg_catalog.pg_opfamily_is_visible(of.oid)\n"
7592 " THEN pg_catalog.format('%%I', of.opfname)\n"
7593 " ELSE pg_catalog.format('%%I.%%I', ns.nspname, of.opfname)\n"
7595 " pg_catalog.format_type(ap.amproclefttype, NULL) AS \"%s\",\n"
7596 " pg_catalog.format_type(ap.amprocrighttype, NULL) AS \"%s\",\n"
7597 " ap.amprocnum AS \"%s\"\n",
7606 ", p.proname AS \"%s\"\n",
7610 ", ap.amproc::pg_catalog.regprocedure AS \"%s\"\n",
7614 "FROM pg_catalog.pg_amproc ap\n"
7615 " LEFT JOIN pg_catalog.pg_opfamily of ON of.oid = ap.amprocfamily\n"
7616 " LEFT JOIN pg_catalog.pg_am am ON am.oid = of.opfmethod\n"
7617 " LEFT JOIN pg_catalog.pg_namespace ns ON of.opfnamespace = ns.oid\n"
7618 " LEFT JOIN pg_catalog.pg_proc p ON ap.amproc = p.oid\n");
7623 false,
false,
NULL,
"am.amname",
7631 "ns.nspname",
"of.opfname",
NULL,
NULL,
7637 " ap.amproclefttype = ap.amprocrighttype DESC,\n"
7645 myopt.title =
_(
"List of support functions of operator families");
7646 myopt.translate_header =
true;
7647 myopt.translate_columns = translate_columns;
7675 "SELECT oid as \"%s\",\n"
7676 " pg_catalog.pg_get_userbyid(lomowner) as \"%s\",\n ",
7687 "pg_catalog.obj_description(oid, 'pg_largeobject') as \"%s\"\n"
7688 "FROM pg_catalog.pg_largeobject_metadata\n"
7697 myopt.title =
_(
"Large objects");
7698 myopt.translate_header =
true;
PGresult * PSQLexec(const char *query)
#define ngettext(s, p, n)
#define Assert(condition)
bool listUserMappings(const char *pattern, bool verbose)
bool listTSConfigs(const char *pattern, bool verbose)
bool describeRoles(const char *pattern, bool verbose, bool showSystem)
bool listOpFamilyFunctions(const char *access_method_pattern, const char *family_pattern, bool verbose)
bool listPublications(const char *pattern)
bool listTSParsers(const char *pattern, bool verbose)
bool listExtensionContents(const char *pattern)
bool describeAggregates(const char *pattern, bool verbose, bool showSystem)
bool listForeignDataWrappers(const char *pattern, bool verbose)
bool listPartitionedTables(const char *reltypes, const char *pattern, bool verbose)
bool describeSubscriptions(const char *pattern, bool verbose)
bool describeRoleGrants(const char *pattern, bool showSystem)
bool describeTypes(const char *pattern, bool verbose, bool showSystem)
bool listOperatorFamilies(const char *access_method_pattern, const char *type_pattern, bool verbose)
bool listForeignServers(const char *pattern, bool verbose)
bool describeTableDetails(const char *pattern, bool verbose, bool showSystem)
bool listDomains(const char *pattern, bool verbose, bool showSystem)
bool listTSDictionaries(const char *pattern, bool verbose)
bool listDbRoleSettings(const char *pattern, const char *pattern2)
bool describeFunctions(const char *functypes, const char *func_pattern, char **arg_patterns, int num_arg_patterns, bool verbose, bool showSystem)
static void add_role_attribute(PQExpBuffer buf, const char *const str)
bool listCollations(const char *pattern, bool verbose, bool showSystem)
bool listSchemas(const char *pattern, bool verbose, bool showSystem)
bool listExtensions(const char *pattern)
static bool describeOneTSConfig(const char *oid, const char *nspname, const char *cfgname, const char *pnspname, const char *prsname)
static bool listOneExtensionContents(const char *extname, const char *oid)
static bool describeOneTableDetails(const char *schemaname, const char *relationname, const char *oid, bool verbose)
static bool listTSParsersVerbose(const char *pattern)
bool listTables(const char *tabtypes, const char *pattern, bool verbose, bool showSystem)
bool listTSTemplates(const char *pattern, bool verbose)
bool describeTablespaces(const char *pattern, bool verbose)
bool listCasts(const char *pattern, bool verbose)
bool listOpFamilyOperators(const char *access_method_pattern, const char *family_pattern, bool verbose)
bool describeOperators(const char *oper_pattern, char **arg_patterns, int num_arg_patterns, bool verbose, bool showSystem)
bool listOperatorClasses(const char *access_method_pattern, const char *type_pattern, bool verbose)
static const char * map_typename_pattern(const char *pattern)
bool listForeignTables(const char *pattern, bool verbose)
bool describeConfigurationParameters(const char *pattern, bool verbose, bool showSystem)
bool listEventTriggers(const char *pattern, bool verbose)
bool listDefaultACLs(const char *pattern)
static void printACLColumn(PQExpBuffer buf, const char *colname)
static bool addFooterToPublicationDesc(PQExpBuffer buf, const char *footermsg, bool as_schema, printTableContent *const cont)
static bool validateSQLNamePattern(PQExpBuffer buf, const char *pattern, bool have_where, bool force_escape, const char *schemavar, const char *namevar, const char *altnamevar, const char *visibilityrule, bool *added_clause, int maxparts)
bool listAllDbs(const char *pattern, bool verbose)
bool listConversions(const char *pattern, bool verbose, bool showSystem)
bool permissionsList(const char *pattern, bool showSystem)
bool describeAccessMethods(const char *pattern, bool verbose)
static bool listTSConfigsVerbose(const char *pattern)
bool listLargeObjects(bool verbose)
static bool describeOneTSParser(const char *oid, const char *nspname, const char *prsname)
static void add_tablespace_footer(printTableContent *const cont, char relkind, Oid tablespace, const bool newline)
bool listLanguages(const char *pattern, bool verbose, bool showSystem)
bool describePublications(const char *pattern)
bool listExtendedStats(const char *pattern, bool verbose)
bool objectDescription(const char *pattern, bool showSystem)
char * PQdb(const PGconn *conn)
int PQfnumber(const PGresult *res, const char *field_name)
char * pg_strdup(const char *in)
#define pg_malloc_array(type, count)
#define pg_malloc0_array(type, count)
void printTableInit(printTableContent *const content, const printTableOpt *opt, const char *title, const int ncolumns, const int nrows)
void printTableCleanup(printTableContent *const content)
void printQuery(const PGresult *result, const printQueryOpt *opt, FILE *fout, bool is_pager, FILE *flog)
void printTableAddCell(printTableContent *const content, char *cell, const bool translate, const bool mustfree)
void printTableSetFooter(printTableContent *const content, const char *footer)
void printTable(const printTableContent *cont, FILE *fout, bool is_pager, FILE *flog)
void printTableAddFooter(printTableContent *const content, const char *footer)
void printTableAddHeader(printTableContent *const content, char *header, const bool translate, const char align)
volatile sig_atomic_t cancel_pressed
static IsoConnInfo * conns
#define pg_log_error_internal(...)
#define pg_log_error(...)
int pg_wcswidth(const char *pwcs, size_t len, int encoding)
static char buf[DEFAULT_XLOG_SEG_SIZE]
int pg_strcasecmp(const char *s1, const char *s2)
void printfPQExpBuffer(PQExpBuffer str, const char *fmt,...)
void initPQExpBuffer(PQExpBuffer str)
void resetPQExpBuffer(PQExpBuffer str)
void appendPQExpBuffer(PQExpBuffer str, const char *fmt,...)
void appendPQExpBufferChar(PQExpBuffer str, char ch)
void appendPQExpBufferStr(PQExpBuffer str, const char *data)
void termPQExpBuffer(PQExpBuffer str)
char * psprintf(const char *fmt,...)
const char * fmtId(const char *rawid)
bool processSQLNamePattern(PGconn *conn, PQExpBuffer buf, const char *pattern, bool have_where, bool force_escape, const char *schemavar, const char *namevar, const char *altnamevar, const char *visibilityrule, PQExpBuffer dbnamebuf, int *dotcnt)
char * formatPGVersionNumber(int version_number, bool include_minor, char *buf, size_t buflen)
static StringInfoData tmpbuf