This graph shows which files directly or indirectly include this file:

Functions
bool	describeAggregates (const char *pattern, bool verbose, bool showSystem)

bool	describeAccessMethods (const char *pattern, bool verbose)

bool	describeTablespaces (const char *pattern, bool verbose)

bool	describeFunctions (const char functypes, const char func_pattern, char **arg_patterns, int num_arg_patterns, bool verbose, bool showSystem)

bool	describeTypes (const char *pattern, bool verbose, bool showSystem)

bool	describeOperators (const char oper_pattern, char *arg_patterns, int num_arg_patterns, bool verbose, bool showSystem)

bool	describeRoles (const char *pattern, bool verbose, bool showSystem)

bool	listDbRoleSettings (const char pattern, const char pattern2)

bool	describeRoleGrants (const char *pattern, bool showSystem)

bool	permissionsList (const char *pattern, bool showSystem)

bool	listDefaultACLs (const char *pattern)

bool	objectDescription (const char *pattern, bool showSystem)

bool	describeTableDetails (const char *pattern, bool verbose, bool showSystem)

bool	listTSConfigs (const char *pattern, bool verbose)

bool	listTSParsers (const char *pattern, bool verbose)

bool	listTSDictionaries (const char *pattern, bool verbose)

bool	listTSTemplates (const char *pattern, bool verbose)

bool	listAllDbs (const char *pattern, bool verbose)

bool	listTables (const char tabtypes, const char pattern, bool verbose, bool showSystem)

bool	listPartitionedTables (const char reltypes, const char pattern, bool verbose)

bool	listDomains (const char *pattern, bool verbose, bool showSystem)

bool	listConversions (const char *pattern, bool verbose, bool showSystem)

bool	describeConfigurationParameters (const char *pattern, bool verbose, bool showSystem)

bool	listCasts (const char *pattern, bool verbose)

bool	listCollations (const char *pattern, bool verbose, bool showSystem)

bool	listSchemas (const char *pattern, bool verbose, bool showSystem)

bool	listForeignDataWrappers (const char *pattern, bool verbose)

bool	listForeignServers (const char *pattern, bool verbose)

bool	listUserMappings (const char *pattern, bool verbose)

bool	listForeignTables (const char *pattern, bool verbose)

bool	listLanguages (const char *pattern, bool verbose, bool showSystem)

bool	listExtensions (const char *pattern)

bool	listExtensionContents (const char *pattern)

bool	listExtendedStats (const char *pattern)

bool	listEventTriggers (const char *pattern, bool verbose)

bool	listPublications (const char *pattern)

bool	describePublications (const char *pattern)

bool	describeSubscriptions (const char *pattern, bool verbose)

bool	listOperatorClasses (const char access_method_pattern, const char type_pattern, bool verbose)

bool	listOperatorFamilies (const char access_method_pattern, const char type_pattern, bool verbose)

bool	listOpFamilyOperators (const char access_method_pattern, const char family_pattern, bool verbose)

bool	listOpFamilyFunctions (const char access_method_pattern, const char family_pattern, bool verbose)

bool	listLargeObjects (bool verbose)

Function Documentation

◆ describeAccessMethods()

bool describeAccessMethods	(	const char *	pattern,
		bool	verbose
	)

Definition at line 141 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     static const bool translate_columns[] = {false, true, false, false};
  
     if (pset.sversion < 90600)
     {
         char        sverbuf[32];
  
         pg_log_error("The server (version %s) does not support access methods.",
                      formatPGVersionNumber(pset.sversion, false,
                                            sverbuf, sizeof(sverbuf)));
         return true;
     }
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT amname AS \"%s\",\n"
                       "  CASE amtype"
                       " WHEN 'i' THEN '%s'"
                       " WHEN 't' THEN '%s'"
                       " END AS \"%s\"",
                       gettext_noop("Name"),
                       gettext_noop("Index"),
                       gettext_noop("Table"),
                       gettext_noop("Type"));
  
     if (verbose)
     {
         appendPQExpBuffer(&buf,
                           ",\n  amhandler AS \"%s\",\n"
                           "  pg_catalog.obj_description(oid, 'pg_am') AS \"%s\"",
                           gettext_noop("Handler"),
                           gettext_noop("Description"));
     }
  
     appendPQExpBufferStr(&buf,
                          "\nFROM pg_catalog.pg_am\n");
  
     if (!validateSQLNamePattern(&buf, pattern, false, false,
                                 NULL, "amname", NULL,
                                 NULL,
                                 NULL, 1))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of access methods");
     myopt.translate_header = true;
     myopt.translate_columns = translate_columns;
     myopt.n_translate_columns = lengthof(translate_columns);
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, formatPGVersionNumber(), gettext_noop, initPQExpBuffer(), lengthof, _psqlSettings::logfile, printQueryOpt::n_translate_columns, pg_log_error, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, _psqlSettings::sversion, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_columns, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ describeAggregates()

bool describeAggregates	(	const char *	pattern,
		bool	verbose,
		bool	showSystem
	)

Definition at line 71 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT n.nspname as \"%s\",\n"
                       "  p.proname AS \"%s\",\n"
                       "  pg_catalog.format_type(p.prorettype, NULL) AS \"%s\",\n"
                       "  CASE WHEN p.pronargs = 0\n"
                       "    THEN CAST('*' AS pg_catalog.text)\n"
                       "    ELSE pg_catalog.pg_get_function_arguments(p.oid)\n"
                       "  END AS \"%s\",\n",
                       gettext_noop("Schema"),
                       gettext_noop("Name"),
                       gettext_noop("Result data type"),
                       gettext_noop("Argument data types"));
  
     if (pset.sversion >= 110000)
         appendPQExpBuffer(&buf,
                           "  pg_catalog.obj_description(p.oid, 'pg_proc') as \"%s\"\n"
                           "FROM pg_catalog.pg_proc p\n"
                           "     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace\n"
                           "WHERE p.prokind = 'a'\n",
                           gettext_noop("Description"));
     else
         appendPQExpBuffer(&buf,
                           "  pg_catalog.obj_description(p.oid, 'pg_proc') as \"%s\"\n"
                           "FROM pg_catalog.pg_proc p\n"
                           "     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace\n"
                           "WHERE p.proisagg\n",
                           gettext_noop("Description"));
  
     if (!showSystem && !pattern)
         appendPQExpBufferStr(&buf, "      AND n.nspname <> 'pg_catalog'\n"
                              "      AND n.nspname <> 'information_schema'\n");
  
     if (!validateSQLNamePattern(&buf, pattern, true, false,
                                 "n.nspname", "p.proname", NULL,
                                 "pg_catalog.pg_function_is_visible(p.oid)",
                                 NULL, 3))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2, 4;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of aggregate functions");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), _psqlSettings::logfile, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, _psqlSettings::sversion, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, and validateSQLNamePattern().

Referenced by exec_command_d().

◆ describeConfigurationParameters()

bool describeConfigurationParameters	(	const char *	pattern,
		bool	verbose,
		bool	showSystem
	)

Definition at line 4598 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     initPQExpBuffer(&buf);
     printfPQExpBuffer(&buf,
                       "SELECT s.name AS \"%s\", "
                       "pg_catalog.current_setting(s.name) AS \"%s\"",
                       gettext_noop("Parameter"),
                       gettext_noop("Value"));
  
     if (verbose)
     {
         appendPQExpBuffer(&buf,
                           ", s.vartype AS \"%s\", s.context AS \"%s\", ",
                           gettext_noop("Type"),
                           gettext_noop("Context"));
         if (pset.sversion >= 150000)
             printACLColumn(&buf, "p.paracl");
         else
             appendPQExpBuffer(&buf, "NULL AS \"%s\"",
                               gettext_noop("Access privileges"));
     }
  
     appendPQExpBufferStr(&buf, "\nFROM pg_catalog.pg_settings s\n");
  
     if (verbose && pset.sversion >= 150000)
         appendPQExpBufferStr(&buf,
                              "  LEFT JOIN pg_catalog.pg_parameter_acl p\n"
                              "  ON pg_catalog.lower(s.name) = p.parname\n");
  
     if (pattern)
         processSQLNamePattern(pset.db, &buf, pattern,
                               false, false,
                               NULL, "pg_catalog.lower(s.name)", NULL,
                               NULL, NULL, NULL);
     else
         appendPQExpBufferStr(&buf, "WHERE s.source <> 'default' AND\n"
                              "      s.setting IS DISTINCT FROM s.boot_val\n");
  
     appendPQExpBufferStr(&buf, "ORDER BY 1;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     if (pattern)
         myopt.title = _("List of configuration parameters");
     else
         myopt.title = _("List of non-default configuration parameters");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, _psqlSettings::db, gettext_noop, initPQExpBuffer(), _psqlSettings::logfile, _psqlSettings::popt, PQclear(), printACLColumn(), printfPQExpBuffer(), printQuery(), processSQLNamePattern(), pset, PSQLexec(), _psqlSettings::queryFout, res, _psqlSettings::sversion, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, and verbose.

Referenced by exec_command_d().

◆ describeFunctions()

bool describeFunctions	(	const char *	functypes,
		const char *	func_pattern,
		char **	arg_patterns,
		int	num_arg_patterns,
		bool	verbose,
		bool	showSystem
	)

Definition at line 288 of file describe.c.

 {
     bool        showAggregate = strchr(functypes, 'a') != NULL;
     bool        showNormal = strchr(functypes, 'n') != NULL;
     bool        showProcedure = strchr(functypes, 'p') != NULL;
     bool        showTrigger = strchr(functypes, 't') != NULL;
     bool        showWindow = strchr(functypes, 'w') != NULL;
     bool        have_where;
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     static const bool translate_columns[] = {false, false, false, false, true, true, true, false, true, false, false, false, false};
  
     /* No "Parallel" column before 9.6 */
     static const bool translate_columns_pre_96[] = {false, false, false, false, true, true, false, true, false, false, false, false};
  
     if (strlen(functypes) != strspn(functypes, "anptwS+"))
     {
         pg_log_error("\\df only takes [anptwS+] as options");
         return true;
     }
  
     if (showProcedure && pset.sversion < 110000)
     {
         char        sverbuf[32];
  
         pg_log_error("\\df does not take a \"%c\" option with server version %s",
                      'p',
                      formatPGVersionNumber(pset.sversion, false,
                                            sverbuf, sizeof(sverbuf)));
         return true;
     }
  
     if (!showAggregate && !showNormal && !showProcedure && !showTrigger && !showWindow)
     {
         showAggregate = showNormal = showTrigger = showWindow = true;
         if (pset.sversion >= 110000)
             showProcedure = true;
     }
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT n.nspname as \"%s\",\n"
                       "  p.proname as \"%s\",\n",
                       gettext_noop("Schema"),
                       gettext_noop("Name"));
  
     if (pset.sversion >= 110000)
         appendPQExpBuffer(&buf,
                           "  pg_catalog.pg_get_function_result(p.oid) as \"%s\",\n"
                           "  pg_catalog.pg_get_function_arguments(p.oid) as \"%s\",\n"
                           " CASE p.prokind\n"
                           "  WHEN 'a' THEN '%s'\n"
                           "  WHEN 'w' THEN '%s'\n"
                           "  WHEN 'p' THEN '%s'\n"
                           "  ELSE '%s'\n"
                           " END as \"%s\"",
                           gettext_noop("Result data type"),
                           gettext_noop("Argument data types"),
         /* translator: "agg" is short for "aggregate" */
                           gettext_noop("agg"),
                           gettext_noop("window"),
                           gettext_noop("proc"),
                           gettext_noop("func"),
                           gettext_noop("Type"));
     else
         appendPQExpBuffer(&buf,
                           "  pg_catalog.pg_get_function_result(p.oid) as \"%s\",\n"
                           "  pg_catalog.pg_get_function_arguments(p.oid) as \"%s\",\n"
                           " CASE\n"
                           "  WHEN p.proisagg THEN '%s'\n"
                           "  WHEN p.proiswindow THEN '%s'\n"
                           "  WHEN p.prorettype = 'pg_catalog.trigger'::pg_catalog.regtype THEN '%s'\n"
                           "  ELSE '%s'\n"
                           " END as \"%s\"",
                           gettext_noop("Result data type"),
                           gettext_noop("Argument data types"),
         /* translator: "agg" is short for "aggregate" */
                           gettext_noop("agg"),
                           gettext_noop("window"),
                           gettext_noop("trigger"),
                           gettext_noop("func"),
                           gettext_noop("Type"));
  
     if (verbose)
     {
         appendPQExpBuffer(&buf,
                           ",\n CASE\n"
                           "  WHEN p.provolatile = 'i' THEN '%s'\n"
                           "  WHEN p.provolatile = 's' THEN '%s'\n"
                           "  WHEN p.provolatile = 'v' THEN '%s'\n"
                           " END as \"%s\"",
                           gettext_noop("immutable"),
                           gettext_noop("stable"),
                           gettext_noop("volatile"),
                           gettext_noop("Volatility"));
         if (pset.sversion >= 90600)
             appendPQExpBuffer(&buf,
                               ",\n CASE\n"
                               "  WHEN p.proparallel = 'r' THEN '%s'\n"
                               "  WHEN p.proparallel = 's' THEN '%s'\n"
                               "  WHEN p.proparallel = 'u' THEN '%s'\n"
                               " END as \"%s\"",
                               gettext_noop("restricted"),
                               gettext_noop("safe"),
                               gettext_noop("unsafe"),
                               gettext_noop("Parallel"));
         appendPQExpBuffer(&buf,
                           ",\n pg_catalog.pg_get_userbyid(p.proowner) as \"%s\""
                           ",\n CASE WHEN prosecdef THEN '%s' ELSE '%s' END AS \"%s\"",
                           gettext_noop("Owner"),
                           gettext_noop("definer"),
                           gettext_noop("invoker"),
                           gettext_noop("Security"));
         appendPQExpBufferStr(&buf, ",\n ");
         printACLColumn(&buf, "p.proacl");
         appendPQExpBuffer(&buf,
                           ",\n l.lanname as \"%s\"",
                           gettext_noop("Language"));
         appendPQExpBuffer(&buf,
                           ",\n CASE WHEN l.lanname IN ('internal', 'c') THEN p.prosrc END as \"%s\"",
                           gettext_noop("Internal name"));
         appendPQExpBuffer(&buf,
                           ",\n pg_catalog.obj_description(p.oid, 'pg_proc') as \"%s\"",
                           gettext_noop("Description"));
     }
  
     appendPQExpBufferStr(&buf,
                          "\nFROM pg_catalog.pg_proc p"
                          "\n     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace\n");
  
     for (int i = 0; i < num_arg_patterns; i++)
     {
         appendPQExpBuffer(&buf,
                           "     LEFT JOIN pg_catalog.pg_type t%d ON t%d.oid = p.proargtypes[%d]\n"
                           "     LEFT JOIN pg_catalog.pg_namespace nt%d ON nt%d.oid = t%d.typnamespace\n",
                           i, i, i, i, i, i);
     }
  
     if (verbose)
         appendPQExpBufferStr(&buf,
                              "     LEFT JOIN pg_catalog.pg_language l ON l.oid = p.prolang\n");
  
     have_where = false;
  
     /* filter by function type, if requested */
     if (showNormal && showAggregate && showProcedure && showTrigger && showWindow)
          /* Do nothing */ ;
     else if (showNormal)
     {
         if (!showAggregate)
         {
             if (have_where)
                 appendPQExpBufferStr(&buf, "      AND ");
             else
             {
                 appendPQExpBufferStr(&buf, "WHERE ");
                 have_where = true;
             }
             if (pset.sversion >= 110000)
                 appendPQExpBufferStr(&buf, "p.prokind <> 'a'\n");
             else
                 appendPQExpBufferStr(&buf, "NOT p.proisagg\n");
         }
         if (!showProcedure && pset.sversion >= 110000)
         {
             if (have_where)
                 appendPQExpBufferStr(&buf, "      AND ");
             else
             {
                 appendPQExpBufferStr(&buf, "WHERE ");
                 have_where = true;
             }
             appendPQExpBufferStr(&buf, "p.prokind <> 'p'\n");
         }
         if (!showTrigger)
         {
             if (have_where)
                 appendPQExpBufferStr(&buf, "      AND ");
             else
             {
                 appendPQExpBufferStr(&buf, "WHERE ");
                 have_where = true;
             }
             appendPQExpBufferStr(&buf, "p.prorettype <> 'pg_catalog.trigger'::pg_catalog.regtype\n");
         }
         if (!showWindow)
         {
             if (have_where)
                 appendPQExpBufferStr(&buf, "      AND ");
             else
             {
                 appendPQExpBufferStr(&buf, "WHERE ");
                 have_where = true;
             }
             if (pset.sversion >= 110000)
                 appendPQExpBufferStr(&buf, "p.prokind <> 'w'\n");
             else
                 appendPQExpBufferStr(&buf, "NOT p.proiswindow\n");
         }
     }
     else
     {
         bool        needs_or = false;
  
         appendPQExpBufferStr(&buf, "WHERE (\n       ");
         have_where = true;
         /* Note: at least one of these must be true ... */
         if (showAggregate)
         {
             if (pset.sversion >= 110000)
                 appendPQExpBufferStr(&buf, "p.prokind = 'a'\n");
             else
                 appendPQExpBufferStr(&buf, "p.proisagg\n");
             needs_or = true;
         }
         if (showTrigger)
         {
             if (needs_or)
                 appendPQExpBufferStr(&buf, "       OR ");
             appendPQExpBufferStr(&buf,
                                  "p.prorettype = 'pg_catalog.trigger'::pg_catalog.regtype\n");
             needs_or = true;
         }
         if (showProcedure)
         {
             if (needs_or)
                 appendPQExpBufferStr(&buf, "       OR ");
             appendPQExpBufferStr(&buf, "p.prokind = 'p'\n");
             needs_or = true;
         }
         if (showWindow)
         {
             if (needs_or)
                 appendPQExpBufferStr(&buf, "       OR ");
             if (pset.sversion >= 110000)
                 appendPQExpBufferStr(&buf, "p.prokind = 'w'\n");
             else
                 appendPQExpBufferStr(&buf, "p.proiswindow\n");
         }
         appendPQExpBufferStr(&buf, "      )\n");
     }
  
     if (!validateSQLNamePattern(&buf, func_pattern, have_where, false,
                                 "n.nspname", "p.proname", NULL,
                                 "pg_catalog.pg_function_is_visible(p.oid)",
                                 NULL, 3))
         goto error_return;
  
     for (int i = 0; i < num_arg_patterns; i++)
     {
         if (strcmp(arg_patterns[i], "-") != 0)
         {
             /*
              * Match type-name patterns against either internal or external
              * name, like \dT.  Unlike \dT, there seems no reason to
              * discriminate against arrays or composite types.
              */
             char        nspname[64];
             char        typname[64];
             char        ft[64];
             char        tiv[64];
  
             snprintf(nspname, sizeof(nspname), "nt%d.nspname", i);
             snprintf(typname, sizeof(typname), "t%d.typname", i);
             snprintf(ft, sizeof(ft),
                      "pg_catalog.format_type(t%d.oid, NULL)", i);
             snprintf(tiv, sizeof(tiv),
                      "pg_catalog.pg_type_is_visible(t%d.oid)", i);
             if (!validateSQLNamePattern(&buf,
                                         map_typename_pattern(arg_patterns[i]),
                                         true, false,
                                         nspname, typname, ft, tiv,
                                         NULL, 3))
                 goto error_return;
         }
         else
         {
             /* "-" pattern specifies no such parameter */
             appendPQExpBuffer(&buf, "  AND t%d.typname IS NULL\n", i);
         }
     }
  
     if (!showSystem && !func_pattern)
         appendPQExpBufferStr(&buf, "      AND n.nspname <> 'pg_catalog'\n"
                              "      AND n.nspname <> 'information_schema'\n");
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2, 4;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of functions");
     myopt.translate_header = true;
     if (pset.sversion >= 90600)
     {
         myopt.translate_columns = translate_columns;
         myopt.n_translate_columns = lengthof(translate_columns);
     }
     else
     {
         myopt.translate_columns = translate_columns_pre_96;
         myopt.n_translate_columns = lengthof(translate_columns_pre_96);
     }
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
  
 error_return:
     termPQExpBuffer(&buf);
     return false;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, formatPGVersionNumber(), gettext_noop, i, initPQExpBuffer(), lengthof, _psqlSettings::logfile, map_typename_pattern(), printQueryOpt::n_translate_columns, pg_log_error, _psqlSettings::popt, PQclear(), printACLColumn(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, snprintf, _psqlSettings::sversion, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_columns, printQueryOpt::translate_header, typname, validateSQLNamePattern(), and verbose.

Referenced by exec_command_dfo().

◆ describeOperators()

bool describeOperators	(	const char *	oper_pattern,
		char **	arg_patterns,
		int	num_arg_patterns,
		bool	verbose,
		bool	showSystem
	)

Definition at line 770 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     initPQExpBuffer(&buf);
  
     /*
      * Note: before Postgres 9.1, we did not assign comments to any built-in
      * operators, preferring to let the comment on the underlying function
      * suffice.  The coalesce() on the obj_description() calls below supports
      * this convention by providing a fallback lookup of a comment on the
      * operator's function.  Since 9.1 there is a policy that every built-in
      * operator should have a comment; so the coalesce() is no longer
      * necessary so far as built-in operators are concerned.  We keep it
      * anyway, for now, because third-party modules may still be following the
      * old convention.
      *
      * The support for postfix operators in this query is dead code as of
      * Postgres 14, but we need to keep it for as long as we support talking
      * to pre-v14 servers.
      */
  
     printfPQExpBuffer(&buf,
                       "SELECT n.nspname as \"%s\",\n"
                       "  o.oprname AS \"%s\",\n"
                       "  CASE WHEN o.oprkind='l' THEN NULL ELSE pg_catalog.format_type(o.oprleft, NULL) END AS \"%s\",\n"
                       "  CASE WHEN o.oprkind='r' THEN NULL ELSE pg_catalog.format_type(o.oprright, NULL) END AS \"%s\",\n"
                       "  pg_catalog.format_type(o.oprresult, NULL) AS \"%s\",\n",
                       gettext_noop("Schema"),
                       gettext_noop("Name"),
                       gettext_noop("Left arg type"),
                       gettext_noop("Right arg type"),
                       gettext_noop("Result type"));
  
     if (verbose)
         appendPQExpBuffer(&buf,
                           "  o.oprcode AS \"%s\",\n",
                           gettext_noop("Function"));
  
     appendPQExpBuffer(&buf,
                       "  coalesce(pg_catalog.obj_description(o.oid, 'pg_operator'),\n"
                       "           pg_catalog.obj_description(o.oprcode, 'pg_proc')) AS \"%s\"\n"
                       "FROM pg_catalog.pg_operator o\n"
                       "     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = o.oprnamespace\n",
                       gettext_noop("Description"));
  
     if (num_arg_patterns >= 2)
     {
         num_arg_patterns = 2;   /* ignore any additional arguments */
         appendPQExpBufferStr(&buf,
                              "     LEFT JOIN pg_catalog.pg_type t0 ON t0.oid = o.oprleft\n"
                              "     LEFT JOIN pg_catalog.pg_namespace nt0 ON nt0.oid = t0.typnamespace\n"
                              "     LEFT JOIN pg_catalog.pg_type t1 ON t1.oid = o.oprright\n"
                              "     LEFT JOIN pg_catalog.pg_namespace nt1 ON nt1.oid = t1.typnamespace\n");
     }
     else if (num_arg_patterns == 1)
     {
         appendPQExpBufferStr(&buf,
                              "     LEFT JOIN pg_catalog.pg_type t0 ON t0.oid = o.oprright\n"
                              "     LEFT JOIN pg_catalog.pg_namespace nt0 ON nt0.oid = t0.typnamespace\n");
     }
  
     if (!showSystem && !oper_pattern)
         appendPQExpBufferStr(&buf, "WHERE n.nspname <> 'pg_catalog'\n"
                              "      AND n.nspname <> 'information_schema'\n");
  
     if (!validateSQLNamePattern(&buf, oper_pattern,
                                 !showSystem && !oper_pattern, true,
                                 "n.nspname", "o.oprname", NULL,
                                 "pg_catalog.pg_operator_is_visible(o.oid)",
                                 NULL, 3))
         goto error_return;
  
     if (num_arg_patterns == 1)
         appendPQExpBufferStr(&buf, "  AND o.oprleft = 0\n");
  
     for (int i = 0; i < num_arg_patterns; i++)
     {
         if (strcmp(arg_patterns[i], "-") != 0)
         {
             /*
              * Match type-name patterns against either internal or external
              * name, like \dT.  Unlike \dT, there seems no reason to
              * discriminate against arrays or composite types.
              */
             char        nspname[64];
             char        typname[64];
             char        ft[64];
             char        tiv[64];
  
             snprintf(nspname, sizeof(nspname), "nt%d.nspname", i);
             snprintf(typname, sizeof(typname), "t%d.typname", i);
             snprintf(ft, sizeof(ft),
                      "pg_catalog.format_type(t%d.oid, NULL)", i);
             snprintf(tiv, sizeof(tiv),
                      "pg_catalog.pg_type_is_visible(t%d.oid)", i);
             if (!validateSQLNamePattern(&buf,
                                         map_typename_pattern(arg_patterns[i]),
                                         true, false,
                                         nspname, typname, ft, tiv,
                                         NULL, 3))
                 goto error_return;
         }
         else
         {
             /* "-" pattern specifies no such parameter */
             appendPQExpBuffer(&buf, "  AND t%d.typname IS NULL\n", i);
         }
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2, 3, 4;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of operators");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
  
 error_return:
     termPQExpBuffer(&buf);
     return false;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, i, initPQExpBuffer(), _psqlSettings::logfile, map_typename_pattern(), _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, snprintf, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, typname, validateSQLNamePattern(), and verbose.

Referenced by exec_command_dfo().

◆ describePublications()

bool describePublications ( const char * pattern )

Definition at line 6391 of file describe.c.

 {
     PQExpBufferData buf;
     int         i;
     PGresult   *res;
     bool        has_pubtruncate;
     bool        has_pubviaroot;
  
     PQExpBufferData title;
     printTableContent cont;
  
     if (pset.sversion < 100000)
     {
         char        sverbuf[32];
  
         pg_log_error("The server (version %s) does not support publications.",
                      formatPGVersionNumber(pset.sversion, false,
                                            sverbuf, sizeof(sverbuf)));
         return true;
     }
  
     has_pubtruncate = (pset.sversion >= 110000);
     has_pubviaroot = (pset.sversion >= 130000);
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT oid, pubname,\n"
                       "  pg_catalog.pg_get_userbyid(pubowner) AS owner,\n"
                       "  puballtables, pubinsert, pubupdate, pubdelete");
     if (has_pubtruncate)
         appendPQExpBufferStr(&buf,
                              ", pubtruncate");
     if (has_pubviaroot)
         appendPQExpBufferStr(&buf,
                              ", pubviaroot");
     appendPQExpBufferStr(&buf,
                          "\nFROM pg_catalog.pg_publication\n");
  
     if (!validateSQLNamePattern(&buf, pattern, false, false,
                                 NULL, "pubname", NULL,
                                 NULL,
                                 NULL, 1))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 2;");
  
     res = PSQLexec(buf.data);
     if (!res)
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     if (PQntuples(res) == 0)
     {
         if (!pset.quiet)
         {
             if (pattern)
                 pg_log_error("Did not find any publication named \"%s\".",
                              pattern);
             else
                 pg_log_error("Did not find any publications.");
         }
  
         termPQExpBuffer(&buf);
         PQclear(res);
         return false;
     }
  
     for (i = 0; i < PQntuples(res); i++)
     {
         const char  align = 'l';
         int         ncols = 5;
         int         nrows = 1;
         char       *pubid = PQgetvalue(res, i, 0);
         char       *pubname = PQgetvalue(res, i, 1);
         bool        puballtables = strcmp(PQgetvalue(res, i, 3), "t") == 0;
         printTableOpt myopt = pset.popt.topt;
  
         if (has_pubtruncate)
             ncols++;
         if (has_pubviaroot)
             ncols++;
  
         initPQExpBuffer(&title);
         printfPQExpBuffer(&title, _("Publication %s"), pubname);
         printTableInit(&cont, &myopt, title.data, ncols, nrows);
  
         printTableAddHeader(&cont, gettext_noop("Owner"), true, align);
         printTableAddHeader(&cont, gettext_noop("All tables"), true, align);
         printTableAddHeader(&cont, gettext_noop("Inserts"), true, align);
         printTableAddHeader(&cont, gettext_noop("Updates"), true, align);
         printTableAddHeader(&cont, gettext_noop("Deletes"), true, align);
         if (has_pubtruncate)
             printTableAddHeader(&cont, gettext_noop("Truncates"), true, align);
         if (has_pubviaroot)
             printTableAddHeader(&cont, gettext_noop("Via root"), true, align);
  
         printTableAddCell(&cont, PQgetvalue(res, i, 2), false, false);
         printTableAddCell(&cont, PQgetvalue(res, i, 3), false, false);
         printTableAddCell(&cont, PQgetvalue(res, i, 4), false, false);
         printTableAddCell(&cont, PQgetvalue(res, i, 5), false, false);
         printTableAddCell(&cont, PQgetvalue(res, i, 6), false, false);
         if (has_pubtruncate)
             printTableAddCell(&cont, PQgetvalue(res, i, 7), false, false);
         if (has_pubviaroot)
             printTableAddCell(&cont, PQgetvalue(res, i, 8), false, false);
  
         if (!puballtables)
         {
             /* Get the tables for the specified publication */
             printfPQExpBuffer(&buf,
                               "SELECT n.nspname, c.relname");
             if (pset.sversion >= 150000)
             {
                 appendPQExpBufferStr(&buf,
                                      ", pg_get_expr(pr.prqual, c.oid)");
                 appendPQExpBufferStr(&buf,
                                      ", (CASE WHEN pr.prattrs IS NOT NULL THEN\n"
                                      "     pg_catalog.array_to_string("
                                      "      ARRAY(SELECT attname\n"
                                      "              FROM\n"
                                      "                pg_catalog.generate_series(0, pg_catalog.array_upper(pr.prattrs::pg_catalog.int2[], 1)) s,\n"
                                      "                pg_catalog.pg_attribute\n"
                                      "        WHERE attrelid = c.oid AND attnum = prattrs[s]), ', ')\n"
                                      "       ELSE NULL END)");
             }
             else
                 appendPQExpBufferStr(&buf,
                                      ", NULL, NULL");
             appendPQExpBuffer(&buf,
                               "\nFROM pg_catalog.pg_class c,\n"
                               "     pg_catalog.pg_namespace n,\n"
                               "     pg_catalog.pg_publication_rel pr\n"
                               "WHERE c.relnamespace = n.oid\n"
                               "  AND c.oid = pr.prrelid\n"
                               "  AND pr.prpubid = '%s'\n"
                               "ORDER BY 1,2", pubid);
             if (!addFooterToPublicationDesc(&buf, _("Tables:"), false, &cont))
                 goto error_return;
  
             if (pset.sversion >= 150000)
             {
                 /* Get the schemas for the specified publication */
                 printfPQExpBuffer(&buf,
                                   "SELECT n.nspname\n"
                                   "FROM pg_catalog.pg_namespace n\n"
                                   "     JOIN pg_catalog.pg_publication_namespace pn ON n.oid = pn.pnnspid\n"
                                   "WHERE pn.pnpubid = '%s'\n"
                                   "ORDER BY 1", pubid);
                 if (!addFooterToPublicationDesc(&buf, _("Tables from schemas:"),
                                                 true, &cont))
                     goto error_return;
             }
         }
  
         printTable(&cont, pset.queryFout, false, pset.logfile);
         printTableCleanup(&cont);
  
         termPQExpBuffer(&title);
     }
  
     termPQExpBuffer(&buf);
     PQclear(res);
  
     return true;
  
 error_return:
     printTableCleanup(&cont);
     PQclear(res);
     termPQExpBuffer(&buf);
     termPQExpBuffer(&title);
     return false;
 }

References _, addFooterToPublicationDesc(), appendPQExpBuffer(), appendPQExpBufferStr(), buf, PQExpBufferData::data, formatPGVersionNumber(), gettext_noop, i, initPQExpBuffer(), _psqlSettings::logfile, pg_log_error, _psqlSettings::popt, PQclear(), PQgetvalue(), PQntuples(), printfPQExpBuffer(), printTable(), printTableAddCell(), printTableAddHeader(), printTableCleanup(), printTableInit(), pset, PSQLexec(), _psqlSettings::queryFout, _psqlSettings::quiet, res, _psqlSettings::sversion, termPQExpBuffer(), printQueryOpt::topt, and validateSQLNamePattern().

Referenced by exec_command_d().

◆ describeRoleGrants()

bool describeRoleGrants	(	const char *	pattern,
		bool	showSystem
	)

Definition at line 3882 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     initPQExpBuffer(&buf);
     printfPQExpBuffer(&buf,
                       "SELECT m.rolname AS \"%s\", r.rolname AS \"%s\",\n"
                       "  pg_catalog.concat_ws(', ',\n",
                       gettext_noop("Role name"),
                       gettext_noop("Member of"));
  
     if (pset.sversion >= 160000)
         appendPQExpBufferStr(&buf,
                              "    CASE WHEN pam.admin_option THEN 'ADMIN' END,\n"
                              "    CASE WHEN pam.inherit_option THEN 'INHERIT' END,\n"
                              "    CASE WHEN pam.set_option THEN 'SET' END\n");
     else
         appendPQExpBufferStr(&buf,
                              "    CASE WHEN pam.admin_option THEN 'ADMIN' END,\n"
                              "    CASE WHEN m.rolinherit THEN 'INHERIT' END,\n"
                              "    'SET'\n");
  
     appendPQExpBuffer(&buf,
                       "  ) AS \"%s\",\n"
                       "  g.rolname AS \"%s\"\n",
                       gettext_noop("Options"),
                       gettext_noop("Grantor"));
  
     appendPQExpBufferStr(&buf,
                          "FROM pg_catalog.pg_roles m\n"
                          "     JOIN pg_catalog.pg_auth_members pam ON (pam.member = m.oid)\n"
                          "     LEFT JOIN pg_catalog.pg_roles r ON (pam.roleid = r.oid)\n"
                          "     LEFT JOIN pg_catalog.pg_roles g ON (pam.grantor = g.oid)\n");
  
     if (!showSystem && !pattern)
         appendPQExpBufferStr(&buf, "WHERE m.rolname !~ '^pg_'\n");
  
     if (!validateSQLNamePattern(&buf, pattern, false, false,
                                 NULL, "m.rolname", NULL, NULL,
                                 NULL, 1))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2, 4;\n");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of role grants");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), _psqlSettings::logfile, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, _psqlSettings::sversion, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, and validateSQLNamePattern().

Referenced by exec_command_d().

◆ describeRoles()

bool describeRoles	(	const char *	pattern,
		bool	verbose,
		bool	showSystem
	)

Definition at line 3666 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printTableContent cont;
     printTableOpt myopt = pset.popt.topt;
     int         ncols = 2;
     int         nrows = 0;
     int         i;
     int         conns;
     const char  align = 'l';
     char      **attr;
  
     myopt.default_footer = false;
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT r.rolname, r.rolsuper, r.rolinherit,\n"
                       "  r.rolcreaterole, r.rolcreatedb, r.rolcanlogin,\n"
                       "  r.rolconnlimit, r.rolvaliduntil");
  
     if (verbose)
     {
         appendPQExpBufferStr(&buf, "\n, pg_catalog.shobj_description(r.oid, 'pg_authid') AS description");
         ncols++;
     }
     appendPQExpBufferStr(&buf, "\n, r.rolreplication");
  
     if (pset.sversion >= 90500)
     {
         appendPQExpBufferStr(&buf, "\n, r.rolbypassrls");
     }
  
     appendPQExpBufferStr(&buf, "\nFROM pg_catalog.pg_roles r\n");
  
     if (!showSystem && !pattern)
         appendPQExpBufferStr(&buf, "WHERE r.rolname !~ '^pg_'\n");
  
     if (!validateSQLNamePattern(&buf, pattern, false, false,
                                 NULL, "r.rolname", NULL, NULL,
                                 NULL, 1))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1;");
  
     res = PSQLexec(buf.data);
     if (!res)
         return false;
  
     nrows = PQntuples(res);
     attr = pg_malloc0((nrows + 1) * sizeof(*attr));
  
     printTableInit(&cont, &myopt, _("List of roles"), ncols, nrows);
  
     printTableAddHeader(&cont, gettext_noop("Role name"), true, align);
     printTableAddHeader(&cont, gettext_noop("Attributes"), true, align);
  
     if (verbose)
         printTableAddHeader(&cont, gettext_noop("Description"), true, align);
  
     for (i = 0; i < nrows; i++)
     {
         printTableAddCell(&cont, PQgetvalue(res, i, 0), false, false);
  
         resetPQExpBuffer(&buf);
         if (strcmp(PQgetvalue(res, i, 1), "t") == 0)
             add_role_attribute(&buf, _("Superuser"));
  
         if (strcmp(PQgetvalue(res, i, 2), "t") != 0)
             add_role_attribute(&buf, _("No inheritance"));
  
         if (strcmp(PQgetvalue(res, i, 3), "t") == 0)
             add_role_attribute(&buf, _("Create role"));
  
         if (strcmp(PQgetvalue(res, i, 4), "t") == 0)
             add_role_attribute(&buf, _("Create DB"));
  
         if (strcmp(PQgetvalue(res, i, 5), "t") != 0)
             add_role_attribute(&buf, _("Cannot login"));
  
         if (strcmp(PQgetvalue(res, i, (verbose ? 9 : 8)), "t") == 0)
             add_role_attribute(&buf, _("Replication"));
  
         if (pset.sversion >= 90500)
             if (strcmp(PQgetvalue(res, i, (verbose ? 10 : 9)), "t") == 0)
                 add_role_attribute(&buf, _("Bypass RLS"));
  
         conns = atoi(PQgetvalue(res, i, 6));
         if (conns >= 0)
         {
             if (buf.len > 0)
                 appendPQExpBufferChar(&buf, '\n');
  
             if (conns == 0)
                 appendPQExpBufferStr(&buf, _("No connections"));
             else
                 appendPQExpBuffer(&buf, ngettext("%d connection",
                                                  "%d connections",
                                                  conns),
                                   conns);
         }
  
         if (strcmp(PQgetvalue(res, i, 7), "") != 0)
         {
             if (buf.len > 0)
                 appendPQExpBufferChar(&buf, '\n');
             appendPQExpBufferStr(&buf, _("Password valid until "));
             appendPQExpBufferStr(&buf, PQgetvalue(res, i, 7));
         }
  
         attr[i] = pg_strdup(buf.data);
  
         printTableAddCell(&cont, attr[i], false, false);
  
         if (verbose)
             printTableAddCell(&cont, PQgetvalue(res, i, 8), false, false);
     }
     termPQExpBuffer(&buf);
  
     printTable(&cont, pset.queryFout, false, pset.logfile);
     printTableCleanup(&cont);
  
     for (i = 0; i < nrows; i++)
         free(attr[i]);
     free(attr);
  
     PQclear(res);
     return true;
 }

References _, add_role_attribute(), appendPQExpBuffer(), appendPQExpBufferChar(), appendPQExpBufferStr(), buf, conns, printTableOpt::default_footer, free, gettext_noop, i, initPQExpBuffer(), _psqlSettings::logfile, ngettext, pg_malloc0(), pg_strdup(), _psqlSettings::popt, PQclear(), PQgetvalue(), PQntuples(), printfPQExpBuffer(), printTable(), printTableAddCell(), printTableAddHeader(), printTableCleanup(), printTableInit(), pset, PSQLexec(), _psqlSettings::queryFout, res, resetPQExpBuffer(), _psqlSettings::sversion, termPQExpBuffer(), printQueryOpt::topt, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ describeSubscriptions()

bool describeSubscriptions	(	const char *	pattern,
		bool	verbose
	)

Definition at line 6577 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     static const bool translate_columns[] = {false, false, false, false,
         false, false, false, false, false, false, false, false, false, false,
     false};
  
     if (pset.sversion < 100000)
     {
         char        sverbuf[32];
  
         pg_log_error("The server (version %s) does not support subscriptions.",
                      formatPGVersionNumber(pset.sversion, false,
                                            sverbuf, sizeof(sverbuf)));
         return true;
     }
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT subname AS \"%s\"\n"
                       ",  pg_catalog.pg_get_userbyid(subowner) AS \"%s\"\n"
                       ",  subenabled AS \"%s\"\n"
                       ",  subpublications AS \"%s\"\n",
                       gettext_noop("Name"),
                       gettext_noop("Owner"),
                       gettext_noop("Enabled"),
                       gettext_noop("Publication"));
  
     if (verbose)
     {
         /* Binary mode and streaming are only supported in v14 and higher */
         if (pset.sversion >= 140000)
         {
             appendPQExpBuffer(&buf,
                               ", subbinary AS \"%s\"\n",
                               gettext_noop("Binary"));
  
             if (pset.sversion >= 160000)
                 appendPQExpBuffer(&buf,
                                   ", (CASE substream\n"
                                   "    WHEN 'f' THEN 'off'\n"
                                   "    WHEN 't' THEN 'on'\n"
                                   "    WHEN 'p' THEN 'parallel'\n"
                                   "   END) AS \"%s\"\n",
                                   gettext_noop("Streaming"));
             else
                 appendPQExpBuffer(&buf,
                                   ", substream AS \"%s\"\n",
                                   gettext_noop("Streaming"));
         }
  
         /* Two_phase and disable_on_error are only supported in v15 and higher */
         if (pset.sversion >= 150000)
             appendPQExpBuffer(&buf,
                               ", subtwophasestate AS \"%s\"\n"
                               ", subdisableonerr AS \"%s\"\n",
                               gettext_noop("Two-phase commit"),
                               gettext_noop("Disable on error"));
  
         if (pset.sversion >= 160000)
             appendPQExpBuffer(&buf,
                               ", suborigin AS \"%s\"\n"
                               ", subpasswordrequired AS \"%s\"\n"
                               ", subrunasowner AS \"%s\"\n",
                               gettext_noop("Origin"),
                               gettext_noop("Password required"),
                               gettext_noop("Run as owner?"));
  
         if (pset.sversion >= 170000)
             appendPQExpBuffer(&buf,
                               ", subfailover AS \"%s\"\n",
                               gettext_noop("Failover"));
  
         appendPQExpBuffer(&buf,
                           ",  subsynccommit AS \"%s\"\n"
                           ",  subconninfo AS \"%s\"\n",
                           gettext_noop("Synchronous commit"),
                           gettext_noop("Conninfo"));
  
         /* Skip LSN is only supported in v15 and higher */
         if (pset.sversion >= 150000)
             appendPQExpBuffer(&buf,
                               ", subskiplsn AS \"%s\"\n",
                               gettext_noop("Skip LSN"));
     }
  
     /* Only display subscriptions in current database. */
     appendPQExpBufferStr(&buf,
                          "FROM pg_catalog.pg_subscription\n"
                          "WHERE subdbid = (SELECT oid\n"
                          "                 FROM pg_catalog.pg_database\n"
                          "                 WHERE datname = pg_catalog.current_database())");
  
     if (!validateSQLNamePattern(&buf, pattern, true, false,
                                 NULL, "subname", NULL,
                                 NULL,
                                 NULL, 1))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of subscriptions");
     myopt.translate_header = true;
     myopt.translate_columns = translate_columns;
     myopt.n_translate_columns = lengthof(translate_columns);
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, formatPGVersionNumber(), gettext_noop, initPQExpBuffer(), lengthof, _psqlSettings::logfile, printQueryOpt::n_translate_columns, pg_log_error, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, _psqlSettings::sversion, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_columns, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ describeTableDetails()

bool describeTableDetails	(	const char *	pattern,
		bool	verbose,
		bool	showSystem
	)

Definition at line 1445 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     int         i;
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT c.oid,\n"
                       "  n.nspname,\n"
                       "  c.relname\n"
                       "FROM pg_catalog.pg_class c\n"
                       "     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n");
  
     if (!showSystem && !pattern)
         appendPQExpBufferStr(&buf, "WHERE n.nspname <> 'pg_catalog'\n"
                              "      AND n.nspname <> 'information_schema'\n");
  
     if (!validateSQLNamePattern(&buf, pattern, !showSystem && !pattern, false,
                                 "n.nspname", "c.relname", NULL,
                                 "pg_catalog.pg_table_is_visible(c.oid)",
                                 NULL, 3))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 2, 3;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     if (PQntuples(res) == 0)
     {
         if (!pset.quiet)
         {
             if (pattern)
                 pg_log_error("Did not find any relation named \"%s\".",
                              pattern);
             else
                 pg_log_error("Did not find any relations.");
         }
         PQclear(res);
         return false;
     }
  
     for (i = 0; i < PQntuples(res); i++)
     {
         const char *oid;
         const char *nspname;
         const char *relname;
  
         oid = PQgetvalue(res, i, 0);
         nspname = PQgetvalue(res, i, 1);
         relname = PQgetvalue(res, i, 2);
  
         if (!describeOneTableDetails(nspname, relname, oid, verbose))
         {
             PQclear(res);
             return false;
         }
         if (cancel_pressed)
         {
             PQclear(res);
             return false;
         }
     }
  
     PQclear(res);
     return true;
 }

References appendPQExpBufferStr(), buf, cancel_pressed, describeOneTableDetails(), i, initPQExpBuffer(), pg_log_error, PQclear(), PQgetvalue(), PQntuples(), printfPQExpBuffer(), pset, PSQLexec(), _psqlSettings::quiet, relname, res, termPQExpBuffer(), validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ describeTablespaces()

bool describeTablespaces	(	const char *	pattern,
		bool	verbose
	)

Definition at line 215 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT spcname AS \"%s\",\n"
                       "  pg_catalog.pg_get_userbyid(spcowner) AS \"%s\",\n"
                       "  pg_catalog.pg_tablespace_location(oid) AS \"%s\"",
                       gettext_noop("Name"),
                       gettext_noop("Owner"),
                       gettext_noop("Location"));
  
     if (verbose)
     {
         appendPQExpBufferStr(&buf, ",\n  ");
         printACLColumn(&buf, "spcacl");
         appendPQExpBuffer(&buf,
                           ",\n  spcoptions AS \"%s\""
                           ",\n  pg_catalog.pg_size_pretty(pg_catalog.pg_tablespace_size(oid)) AS \"%s\""
                           ",\n  pg_catalog.shobj_description(oid, 'pg_tablespace') AS \"%s\"",
                           gettext_noop("Options"),
                           gettext_noop("Size"),
                           gettext_noop("Description"));
     }
  
     appendPQExpBufferStr(&buf,
                          "\nFROM pg_catalog.pg_tablespace\n");
  
     if (!validateSQLNamePattern(&buf, pattern, false, false,
                                 NULL, "spcname", NULL,
                                 NULL,
                                 NULL, 1))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of tablespaces");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), _psqlSettings::logfile, _psqlSettings::popt, PQclear(), printACLColumn(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ describeTypes()

bool describeTypes	(	const char *	pattern,
		bool	verbose,
		bool	showSystem
	)

Definition at line 615 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT n.nspname as \"%s\",\n"
                       "  pg_catalog.format_type(t.oid, NULL) AS \"%s\",\n",
                       gettext_noop("Schema"),
                       gettext_noop("Name"));
     if (verbose)
     {
         appendPQExpBuffer(&buf,
                           "  t.typname AS \"%s\",\n"
                           "  CASE WHEN t.typrelid != 0\n"
                           "      THEN CAST('tuple' AS pg_catalog.text)\n"
                           "    WHEN t.typlen < 0\n"
                           "      THEN CAST('var' AS pg_catalog.text)\n"
                           "    ELSE CAST(t.typlen AS pg_catalog.text)\n"
                           "  END AS \"%s\",\n"
                           "  pg_catalog.array_to_string(\n"
                           "      ARRAY(\n"
                           "          SELECT e.enumlabel\n"
                           "          FROM pg_catalog.pg_enum e\n"
                           "          WHERE e.enumtypid = t.oid\n"
                           "          ORDER BY e.enumsortorder\n"
                           "      ),\n"
                           "      E'\\n'\n"
                           "  ) AS \"%s\",\n"
                           "  pg_catalog.pg_get_userbyid(t.typowner) AS \"%s\",\n",
                           gettext_noop("Internal name"),
                           gettext_noop("Size"),
                           gettext_noop("Elements"),
                           gettext_noop("Owner"));
         printACLColumn(&buf, "t.typacl");
         appendPQExpBufferStr(&buf, ",\n  ");
     }
  
     appendPQExpBuffer(&buf,
                       "  pg_catalog.obj_description(t.oid, 'pg_type') as \"%s\"\n",
                       gettext_noop("Description"));
  
     appendPQExpBufferStr(&buf, "FROM pg_catalog.pg_type t\n"
                          "     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace\n");
  
     /*
      * do not include complex types (typrelid!=0) unless they are standalone
      * composite types
      */
     appendPQExpBufferStr(&buf, "WHERE (t.typrelid = 0 ");
     appendPQExpBufferStr(&buf, "OR (SELECT c.relkind = " CppAsString2(RELKIND_COMPOSITE_TYPE)
                          " FROM pg_catalog.pg_class c "
                          "WHERE c.oid = t.typrelid))\n");
  
     /*
      * do not include array types unless the pattern contains []
      */
     if (pattern == NULL || strstr(pattern, "[]") == NULL)
         appendPQExpBufferStr(&buf, "  AND NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type el WHERE el.oid = t.typelem AND el.typarray = t.oid)\n");
  
     if (!showSystem && !pattern)
         appendPQExpBufferStr(&buf, "      AND n.nspname <> 'pg_catalog'\n"
                              "      AND n.nspname <> 'information_schema'\n");
  
     /* Match name pattern against either internal or external name */
     if (!validateSQLNamePattern(&buf, map_typename_pattern(pattern),
                                 true, false,
                                 "n.nspname", "t.typname",
                                 "pg_catalog.format_type(t.oid, NULL)",
                                 "pg_catalog.pg_type_is_visible(t.oid)",
                                 NULL, 3))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of data types");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, CppAsString2, gettext_noop, initPQExpBuffer(), _psqlSettings::logfile, map_typename_pattern(), _psqlSettings::popt, PQclear(), printACLColumn(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listAllDbs()

bool listAllDbs	(	const char *	pattern,
		bool	verbose
	)

Definition at line 911 of file describe.c.

 {
     PGresult   *res;
     PQExpBufferData buf;
     printQueryOpt myopt = pset.popt;
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT\n"
                       "  d.datname as \"%s\",\n"
                       "  pg_catalog.pg_get_userbyid(d.datdba) as \"%s\",\n"
                       "  pg_catalog.pg_encoding_to_char(d.encoding) as \"%s\",\n",
                       gettext_noop("Name"),
                       gettext_noop("Owner"),
                       gettext_noop("Encoding"));
     if (pset.sversion >= 150000)
         appendPQExpBuffer(&buf,
                           "  CASE d.datlocprovider WHEN 'b' THEN 'builtin' WHEN 'c' THEN 'libc' WHEN 'i' THEN 'icu' END AS \"%s\",\n",
                           gettext_noop("Locale Provider"));
     else
         appendPQExpBuffer(&buf,
                           "  'libc' AS \"%s\",\n",
                           gettext_noop("Locale Provider"));
     appendPQExpBuffer(&buf,
                       "  d.datcollate as \"%s\",\n"
                       "  d.datctype as \"%s\",\n",
                       gettext_noop("Collate"),
                       gettext_noop("Ctype"));
     if (pset.sversion >= 170000)
         appendPQExpBuffer(&buf,
                           "  d.datlocale as \"%s\",\n",
                           gettext_noop("Locale"));
     else if (pset.sversion >= 150000)
         appendPQExpBuffer(&buf,
                           "  d.daticulocale as \"%s\",\n",
                           gettext_noop("Locale"));
     else
         appendPQExpBuffer(&buf,
                           "  NULL as \"%s\",\n",
                           gettext_noop("Locale"));
     if (pset.sversion >= 160000)
         appendPQExpBuffer(&buf,
                           "  d.daticurules as \"%s\",\n",
                           gettext_noop("ICU Rules"));
     else
         appendPQExpBuffer(&buf,
                           "  NULL as \"%s\",\n",
                           gettext_noop("ICU Rules"));
     appendPQExpBufferStr(&buf, "  ");
     printACLColumn(&buf, "d.datacl");
     if (verbose)
         appendPQExpBuffer(&buf,
                           ",\n  CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT')\n"
                           "       THEN pg_catalog.pg_size_pretty(pg_catalog.pg_database_size(d.datname))\n"
                           "       ELSE 'No Access'\n"
                           "  END as \"%s\""
                           ",\n  t.spcname as \"%s\""
                           ",\n  pg_catalog.shobj_description(d.oid, 'pg_database') as \"%s\"",
                           gettext_noop("Size"),
                           gettext_noop("Tablespace"),
                           gettext_noop("Description"));
     appendPQExpBufferStr(&buf,
                          "\nFROM pg_catalog.pg_database d\n");
     if (verbose)
         appendPQExpBufferStr(&buf,
                              "  JOIN pg_catalog.pg_tablespace t on d.dattablespace = t.oid\n");
  
     if (pattern)
     {
         if (!validateSQLNamePattern(&buf, pattern, false, false,
                                     NULL, "d.datname", NULL, NULL,
                                     NULL, 1))
         {
             termPQExpBuffer(&buf);
             return false;
         }
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1;");
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of databases");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), _psqlSettings::logfile, _psqlSettings::popt, PQclear(), printACLColumn(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, _psqlSettings::sversion, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_list(), and main().

◆ listCasts()

bool listCasts	(	const char *	pattern,
		bool	verbose
	)

Definition at line 4842 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     static const bool translate_columns[] = {false, false, false, true, false};
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT pg_catalog.format_type(castsource, NULL) AS \"%s\",\n"
                       "       pg_catalog.format_type(casttarget, NULL) AS \"%s\",\n",
                       gettext_noop("Source type"),
                       gettext_noop("Target type"));
  
     /*
      * We don't attempt to localize '(binary coercible)' or '(with inout)',
      * because there's too much risk of gettext translating a function name
      * that happens to match some string in the PO database.
      */
     appendPQExpBuffer(&buf,
                       "       CASE WHEN c.castmethod = '%c' THEN '(binary coercible)'\n"
                       "            WHEN c.castmethod = '%c' THEN '(with inout)'\n"
                       "            ELSE p.proname\n"
                       "       END AS \"%s\",\n",
                       COERCION_METHOD_BINARY,
                       COERCION_METHOD_INOUT,
                       gettext_noop("Function"));
  
     appendPQExpBuffer(&buf,
                       "       CASE WHEN c.castcontext = '%c' THEN '%s'\n"
                       "            WHEN c.castcontext = '%c' THEN '%s'\n"
                       "            ELSE '%s'\n"
                       "       END AS \"%s\"",
                       COERCION_CODE_EXPLICIT,
                       gettext_noop("no"),
                       COERCION_CODE_ASSIGNMENT,
                       gettext_noop("in assignment"),
                       gettext_noop("yes"),
                       gettext_noop("Implicit?"));
  
     if (verbose)
         appendPQExpBuffer(&buf,
                           ",\n       d.description AS \"%s\"",
                           gettext_noop("Description"));
  
     /*
      * We need a left join to pg_proc for binary casts; the others are just
      * paranoia.
      */
     appendPQExpBufferStr(&buf,
                          "\nFROM pg_catalog.pg_cast c LEFT JOIN pg_catalog.pg_proc p\n"
                          "     ON c.castfunc = p.oid\n"
                          "     LEFT JOIN pg_catalog.pg_type ts\n"
                          "     ON c.castsource = ts.oid\n"
                          "     LEFT JOIN pg_catalog.pg_namespace ns\n"
                          "     ON ns.oid = ts.typnamespace\n"
                          "     LEFT JOIN pg_catalog.pg_type tt\n"
                          "     ON c.casttarget = tt.oid\n"
                          "     LEFT JOIN pg_catalog.pg_namespace nt\n"
                          "     ON nt.oid = tt.typnamespace\n");
  
     if (verbose)
         appendPQExpBufferStr(&buf,
                              "     LEFT JOIN pg_catalog.pg_description d\n"
                              "     ON d.classoid = c.tableoid AND d.objoid = "
                              "c.oid AND d.objsubid = 0\n");
  
     appendPQExpBufferStr(&buf, "WHERE ( (true");
  
     /*
      * Match name pattern against either internal or external name of either
      * castsource or casttarget
      */
     if (!validateSQLNamePattern(&buf, pattern, true, false,
                                 "ns.nspname", "ts.typname",
                                 "pg_catalog.format_type(ts.oid, NULL)",
                                 "pg_catalog.pg_type_is_visible(ts.oid)",
                                 NULL, 3))
         goto error_return;
  
     appendPQExpBufferStr(&buf, ") OR (true");
  
     if (!validateSQLNamePattern(&buf, pattern, true, false,
                                 "nt.nspname", "tt.typname",
                                 "pg_catalog.format_type(tt.oid, NULL)",
                                 "pg_catalog.pg_type_is_visible(tt.oid)",
                                 NULL, 3))
         goto error_return;
  
     appendPQExpBufferStr(&buf, ") )\nORDER BY 1, 2;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of casts");
     myopt.translate_header = true;
     myopt.translate_columns = translate_columns;
     myopt.n_translate_columns = lengthof(translate_columns);
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
  
 error_return:
     termPQExpBuffer(&buf);
     return false;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), lengthof, _psqlSettings::logfile, printQueryOpt::n_translate_columns, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_columns, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listCollations()

bool listCollations	(	const char *	pattern,
		bool	verbose,
		bool	showSystem
	)

Definition at line 4960 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     static const bool translate_columns[] = {false, false, false, false, false, false, false, true, false};
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT\n"
                       "  n.nspname AS \"%s\",\n"
                       "  c.collname AS \"%s\",\n",
                       gettext_noop("Schema"),
                       gettext_noop("Name"));
  
     if (pset.sversion >= 100000)
         appendPQExpBuffer(&buf,
                           "  CASE c.collprovider WHEN 'd' THEN 'default' WHEN 'b' THEN 'builtin' WHEN 'c' THEN 'libc' WHEN 'i' THEN 'icu' END AS \"%s\",\n",
                           gettext_noop("Provider"));
     else
         appendPQExpBuffer(&buf,
                           "  'libc' AS \"%s\",\n",
                           gettext_noop("Provider"));
  
     appendPQExpBuffer(&buf,
                       "  c.collcollate AS \"%s\",\n"
                       "  c.collctype AS \"%s\",\n",
                       gettext_noop("Collate"),
                       gettext_noop("Ctype"));
  
     if (pset.sversion >= 170000)
         appendPQExpBuffer(&buf,
                           "  c.colllocale AS \"%s\",\n",
                           gettext_noop("Locale"));
     else if (pset.sversion >= 150000)
         appendPQExpBuffer(&buf,
                           "  c.colliculocale AS \"%s\",\n",
                           gettext_noop("Locale"));
     else
         appendPQExpBuffer(&buf,
                           "  c.collcollate AS \"%s\",\n",
                           gettext_noop("Locale"));
  
     if (pset.sversion >= 160000)
         appendPQExpBuffer(&buf,
                           "  c.collicurules AS \"%s\",\n",
                           gettext_noop("ICU Rules"));
     else
         appendPQExpBuffer(&buf,
                           "  NULL AS \"%s\",\n",
                           gettext_noop("ICU Rules"));
  
     if (pset.sversion >= 120000)
         appendPQExpBuffer(&buf,
                           "  CASE WHEN c.collisdeterministic THEN '%s' ELSE '%s' END AS \"%s\"",
                           gettext_noop("yes"), gettext_noop("no"),
                           gettext_noop("Deterministic?"));
     else
         appendPQExpBuffer(&buf,
                           "  '%s' AS \"%s\"",
                           gettext_noop("yes"),
                           gettext_noop("Deterministic?"));
  
     if (verbose)
         appendPQExpBuffer(&buf,
                           ",\n  pg_catalog.obj_description(c.oid, 'pg_collation') AS \"%s\"",
                           gettext_noop("Description"));
  
     appendPQExpBufferStr(&buf,
                          "\nFROM pg_catalog.pg_collation c, pg_catalog.pg_namespace n\n"
                          "WHERE n.oid = c.collnamespace\n");
  
     if (!showSystem && !pattern)
         appendPQExpBufferStr(&buf, "      AND n.nspname <> 'pg_catalog'\n"
                              "      AND n.nspname <> 'information_schema'\n");
  
     /*
      * Hide collations that aren't usable in the current database's encoding.
      * If you think to change this, note that pg_collation_is_visible rejects
      * unusable collations, so you will need to hack name pattern processing
      * somehow to avoid inconsistent behavior.
      */
     appendPQExpBufferStr(&buf, "      AND c.collencoding IN (-1, pg_catalog.pg_char_to_encoding(pg_catalog.getdatabaseencoding()))\n");
  
     if (!validateSQLNamePattern(&buf, pattern, true, false,
                                 "n.nspname", "c.collname", NULL,
                                 "pg_catalog.pg_collation_is_visible(c.oid)",
                                 NULL, 3))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of collations");
     myopt.translate_header = true;
     myopt.translate_columns = translate_columns;
     myopt.n_translate_columns = lengthof(translate_columns);
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), lengthof, _psqlSettings::logfile, printQueryOpt::n_translate_columns, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, _psqlSettings::sversion, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_columns, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listConversions()

bool listConversions	(	const char *	pattern,
		bool	verbose,
		bool	showSystem
	)

Definition at line 4518 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     static const bool translate_columns[] =
     {false, false, false, false, true, false};
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT n.nspname AS \"%s\",\n"
                       "       c.conname AS \"%s\",\n"
                       "       pg_catalog.pg_encoding_to_char(c.conforencoding) AS \"%s\",\n"
                       "       pg_catalog.pg_encoding_to_char(c.contoencoding) AS \"%s\",\n"
                       "       CASE WHEN c.condefault THEN '%s'\n"
                       "       ELSE '%s' END AS \"%s\"",
                       gettext_noop("Schema"),
                       gettext_noop("Name"),
                       gettext_noop("Source"),
                       gettext_noop("Destination"),
                       gettext_noop("yes"), gettext_noop("no"),
                       gettext_noop("Default?"));
  
     if (verbose)
         appendPQExpBuffer(&buf,
                           ",\n       d.description AS \"%s\"",
                           gettext_noop("Description"));
  
     appendPQExpBufferStr(&buf,
                          "\nFROM pg_catalog.pg_conversion c\n"
                          "     JOIN pg_catalog.pg_namespace n "
                          "ON n.oid = c.connamespace\n");
  
     if (verbose)
         appendPQExpBufferStr(&buf,
                              "LEFT JOIN pg_catalog.pg_description d "
                              "ON d.classoid = c.tableoid\n"
                              "          AND d.objoid = c.oid "
                              "AND d.objsubid = 0\n");
  
     appendPQExpBufferStr(&buf, "WHERE true\n");
  
     if (!showSystem && !pattern)
         appendPQExpBufferStr(&buf, "  AND n.nspname <> 'pg_catalog'\n"
                              "  AND n.nspname <> 'information_schema'\n");
  
     if (!validateSQLNamePattern(&buf, pattern, true, false,
                                 "n.nspname", "c.conname", NULL,
                                 "pg_catalog.pg_conversion_is_visible(c.oid)",
                                 NULL, 3))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of conversions");
     myopt.translate_header = true;
     myopt.translate_columns = translate_columns;
     myopt.n_translate_columns = lengthof(translate_columns);
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), lengthof, _psqlSettings::logfile, printQueryOpt::n_translate_columns, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_columns, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listDbRoleSettings()

bool listDbRoleSettings	(	const char *	pattern,
		const char *	pattern2
	)

Definition at line 3813 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     bool        havewhere;
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf, "SELECT rolname AS \"%s\", datname AS \"%s\",\n"
                       "pg_catalog.array_to_string(setconfig, E'\\n') AS \"%s\"\n"
                       "FROM pg_catalog.pg_db_role_setting s\n"
                       "LEFT JOIN pg_catalog.pg_database d ON d.oid = setdatabase\n"
                       "LEFT JOIN pg_catalog.pg_roles r ON r.oid = setrole\n",
                       gettext_noop("Role"),
                       gettext_noop("Database"),
                       gettext_noop("Settings"));
     if (!validateSQLNamePattern(&buf, pattern, false, false,
                                 NULL, "r.rolname", NULL, NULL, &havewhere, 1))
         goto error_return;
     if (!validateSQLNamePattern(&buf, pattern2, havewhere, false,
                                 NULL, "d.datname", NULL, NULL,
                                 NULL, 1))
         goto error_return;
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     /*
      * Most functions in this file are content to print an empty table when
      * there are no matching objects.  We intentionally deviate from that
      * here, but only in !quiet mode, because of the possibility that the user
      * is confused about what the two pattern arguments mean.
      */
     if (PQntuples(res) == 0 && !pset.quiet)
     {
         if (pattern && pattern2)
             pg_log_error("Did not find any settings for role \"%s\" and database \"%s\".",
                          pattern, pattern2);
         else if (pattern)
             pg_log_error("Did not find any settings for role \"%s\".",
                          pattern);
         else
             pg_log_error("Did not find any settings.");
     }
     else
     {
         myopt.title = _("List of settings");
         myopt.translate_header = true;
  
         printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
     }
  
     PQclear(res);
     return true;
  
 error_return:
     termPQExpBuffer(&buf);
     return false;
 }

References _, appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), _psqlSettings::logfile, pg_log_error, _psqlSettings::popt, PQclear(), PQntuples(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, _psqlSettings::quiet, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, and validateSQLNamePattern().

Referenced by exec_command_d().

◆ listDefaultACLs()

bool listDefaultACLs ( const char * pattern )

Definition at line 1175 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     static const bool translate_columns[] = {false, false, true, false};
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT pg_catalog.pg_get_userbyid(d.defaclrole) AS \"%s\",\n"
                       "  n.nspname AS \"%s\",\n"
                       "  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\",\n"
                       "  ",
                       gettext_noop("Owner"),
                       gettext_noop("Schema"),
                       DEFACLOBJ_RELATION,
                       gettext_noop("table"),
                       DEFACLOBJ_SEQUENCE,
                       gettext_noop("sequence"),
                       DEFACLOBJ_FUNCTION,
                       gettext_noop("function"),
                       DEFACLOBJ_TYPE,
                       gettext_noop("type"),
                       DEFACLOBJ_NAMESPACE,
                       gettext_noop("schema"),
                       gettext_noop("Type"));
  
     printACLColumn(&buf, "d.defaclacl");
  
     appendPQExpBufferStr(&buf, "\nFROM pg_catalog.pg_default_acl d\n"
                          "     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = d.defaclnamespace\n");
  
     if (!validateSQLNamePattern(&buf, pattern, false, false,
                                 NULL,
                                 "n.nspname",
                                 "pg_catalog.pg_get_userbyid(d.defaclrole)",
                                 NULL,
                                 NULL, 3))
         goto error_return;
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2, 3;");
  
     res = PSQLexec(buf.data);
     if (!res)
         goto error_return;
  
     printfPQExpBuffer(&buf, _("Default access privileges"));
     myopt.title = buf.data;
     myopt.translate_header = true;
     myopt.translate_columns = translate_columns;
     myopt.n_translate_columns = lengthof(translate_columns);
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     termPQExpBuffer(&buf);
     PQclear(res);
     return true;
  
 error_return:
     termPQExpBuffer(&buf);
     return false;
 }

References _, appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), lengthof, _psqlSettings::logfile, printQueryOpt::n_translate_columns, _psqlSettings::popt, PQclear(), printACLColumn(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_columns, printQueryOpt::translate_header, and validateSQLNamePattern().

Referenced by exec_command_d().

◆ listDomains()

bool listDomains	(	const char *	pattern,
		bool	verbose,
		bool	showSystem
	)

Definition at line 4435 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT n.nspname as \"%s\",\n"
                       "       t.typname as \"%s\",\n"
                       "       pg_catalog.format_type(t.typbasetype, t.typtypmod) as \"%s\",\n"
                       "       (SELECT c.collname FROM pg_catalog.pg_collation c, pg_catalog.pg_type bt\n"
                       "        WHERE c.oid = t.typcollation AND bt.oid = t.typbasetype AND t.typcollation <> bt.typcollation) as \"%s\",\n"
                       "       CASE WHEN t.typnotnull THEN 'not null' END as \"%s\",\n"
                       "       t.typdefault as \"%s\",\n"
                       "       pg_catalog.array_to_string(ARRAY(\n"
                       "         SELECT pg_catalog.pg_get_constraintdef(r.oid, true) FROM pg_catalog.pg_constraint r WHERE t.oid = r.contypid AND r.contype = 'c' ORDER BY r.conname\n"
                       "       ), ' ') as \"%s\"",
                       gettext_noop("Schema"),
                       gettext_noop("Name"),
                       gettext_noop("Type"),
                       gettext_noop("Collation"),
                       gettext_noop("Nullable"),
                       gettext_noop("Default"),
                       gettext_noop("Check"));
  
     if (verbose)
     {
         appendPQExpBufferStr(&buf, ",\n  ");
         printACLColumn(&buf, "t.typacl");
         appendPQExpBuffer(&buf,
                           ",\n       d.description as \"%s\"",
                           gettext_noop("Description"));
     }
  
     appendPQExpBufferStr(&buf,
                          "\nFROM pg_catalog.pg_type t\n"
                          "     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace\n");
  
     if (verbose)
         appendPQExpBufferStr(&buf,
                              "     LEFT JOIN pg_catalog.pg_description d "
                              "ON d.classoid = t.tableoid AND d.objoid = t.oid "
                              "AND d.objsubid = 0\n");
  
     appendPQExpBufferStr(&buf, "WHERE t.typtype = 'd'\n");
  
     if (!showSystem && !pattern)
         appendPQExpBufferStr(&buf, "      AND n.nspname <> 'pg_catalog'\n"
                              "      AND n.nspname <> 'information_schema'\n");
  
     if (!validateSQLNamePattern(&buf, pattern, true, false,
                                 "n.nspname", "t.typname", NULL,
                                 "pg_catalog.pg_type_is_visible(t.oid)",
                                 NULL, 3))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of domains");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), _psqlSettings::logfile, _psqlSettings::popt, PQclear(), printACLColumn(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listEventTriggers()

bool listEventTriggers	(	const char *	pattern,
		bool	verbose
	)

Definition at line 4666 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     static const bool translate_columns[] =
     {false, false, false, true, false, false, false};
  
     if (pset.sversion < 90300)
     {
         char        sverbuf[32];
  
         pg_log_error("The server (version %s) does not support event triggers.",
                      formatPGVersionNumber(pset.sversion, false,
                                            sverbuf, sizeof(sverbuf)));
         return true;
     }
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT evtname as \"%s\", "
                       "evtevent as \"%s\", "
                       "pg_catalog.pg_get_userbyid(e.evtowner) as \"%s\",\n"
                       " case evtenabled when 'O' then '%s'"
                       "  when 'R' then '%s'"
                       "  when 'A' then '%s'"
                       "  when 'D' then '%s' end as \"%s\",\n"
                       " e.evtfoid::pg_catalog.regproc as \"%s\", "
                       "pg_catalog.array_to_string(array(select x"
                       " from pg_catalog.unnest(evttags) as t(x)), ', ') as \"%s\"",
                       gettext_noop("Name"),
                       gettext_noop("Event"),
                       gettext_noop("Owner"),
                       gettext_noop("enabled"),
                       gettext_noop("replica"),
                       gettext_noop("always"),
                       gettext_noop("disabled"),
                       gettext_noop("Enabled"),
                       gettext_noop("Function"),
                       gettext_noop("Tags"));
     if (verbose)
         appendPQExpBuffer(&buf,
                           ",\npg_catalog.obj_description(e.oid, 'pg_event_trigger') as \"%s\"",
                           gettext_noop("Description"));
     appendPQExpBufferStr(&buf,
                          "\nFROM pg_catalog.pg_event_trigger e ");
  
     if (!validateSQLNamePattern(&buf, pattern, false, false,
                                 NULL, "evtname", NULL, NULL,
                                 NULL, 1))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of event triggers");
     myopt.translate_header = true;
     myopt.translate_columns = translate_columns;
     myopt.n_translate_columns = lengthof(translate_columns);
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, formatPGVersionNumber(), gettext_noop, initPQExpBuffer(), lengthof, _psqlSettings::logfile, printQueryOpt::n_translate_columns, pg_log_error, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, _psqlSettings::sversion, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_columns, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listExtendedStats()

bool listExtendedStats ( const char * pattern )

Definition at line 4746 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     if (pset.sversion < 100000)
     {
         char        sverbuf[32];
  
         pg_log_error("The server (version %s) does not support extended statistics.",
                      formatPGVersionNumber(pset.sversion, false,
                                            sverbuf, sizeof(sverbuf)));
         return true;
     }
  
     initPQExpBuffer(&buf);
     printfPQExpBuffer(&buf,
                       "SELECT \n"
                       "es.stxnamespace::pg_catalog.regnamespace::pg_catalog.text AS \"%s\", \n"
                       "es.stxname AS \"%s\", \n",
                       gettext_noop("Schema"),
                       gettext_noop("Name"));
  
     if (pset.sversion >= 140000)
         appendPQExpBuffer(&buf,
                           "pg_catalog.format('%%s FROM %%s', \n"
                           "  pg_catalog.pg_get_statisticsobjdef_columns(es.oid), \n"
                           "  es.stxrelid::pg_catalog.regclass) AS \"%s\"",
                           gettext_noop("Definition"));
     else
         appendPQExpBuffer(&buf,
                           "pg_catalog.format('%%s FROM %%s', \n"
                           "  (SELECT pg_catalog.string_agg(pg_catalog.quote_ident(a.attname),', ') \n"
                           "   FROM pg_catalog.unnest(es.stxkeys) s(attnum) \n"
                           "   JOIN pg_catalog.pg_attribute a \n"
                           "   ON (es.stxrelid = a.attrelid \n"
                           "   AND a.attnum = s.attnum \n"
                           "   AND NOT a.attisdropped)), \n"
                           "es.stxrelid::pg_catalog.regclass) AS \"%s\"",
                           gettext_noop("Definition"));
  
     appendPQExpBuffer(&buf,
                       ",\nCASE WHEN 'd' = any(es.stxkind) THEN 'defined' \n"
                       "END AS \"%s\", \n"
                       "CASE WHEN 'f' = any(es.stxkind) THEN 'defined' \n"
                       "END AS \"%s\"",
                       gettext_noop("Ndistinct"),
                       gettext_noop("Dependencies"));
  
     /*
      * Include the MCV statistics kind.
      */
     if (pset.sversion >= 120000)
     {
         appendPQExpBuffer(&buf,
                           ",\nCASE WHEN 'm' = any(es.stxkind) THEN 'defined' \n"
                           "END AS \"%s\" ",
                           gettext_noop("MCV"));
     }
  
     appendPQExpBufferStr(&buf,
                          " \nFROM pg_catalog.pg_statistic_ext es \n");
  
     if (!validateSQLNamePattern(&buf, pattern,
                                 false, false,
                                 "es.stxnamespace::pg_catalog.regnamespace::pg_catalog.text", "es.stxname",
                                 NULL, "pg_catalog.pg_statistics_obj_is_visible(es.oid)",
                                 NULL, 3))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of extended statistics");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, formatPGVersionNumber(), gettext_noop, initPQExpBuffer(), _psqlSettings::logfile, pg_log_error, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, _psqlSettings::sversion, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, and validateSQLNamePattern().

Referenced by exec_command_d().

◆ listExtensionContents()

bool listExtensionContents ( const char * pattern )

Definition at line 6105 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     int         i;
  
     initPQExpBuffer(&buf);
     printfPQExpBuffer(&buf,
                       "SELECT e.extname, e.oid\n"
                       "FROM pg_catalog.pg_extension e\n");
  
     if (!validateSQLNamePattern(&buf, pattern,
                                 false, false,
                                 NULL, "e.extname", NULL,
                                 NULL,
                                 NULL, 1))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     if (PQntuples(res) == 0)
     {
         if (!pset.quiet)
         {
             if (pattern)
                 pg_log_error("Did not find any extension named \"%s\".",
                              pattern);
             else
                 pg_log_error("Did not find any extensions.");
         }
         PQclear(res);
         return false;
     }
  
     for (i = 0; i < PQntuples(res); i++)
     {
         const char *extname;
         const char *oid;
  
         extname = PQgetvalue(res, i, 0);
         oid = PQgetvalue(res, i, 1);
  
         if (!listOneExtensionContents(extname, oid))
         {
             PQclear(res);
             return false;
         }
         if (cancel_pressed)
         {
             PQclear(res);
             return false;
         }
     }
  
     PQclear(res);
     return true;
 }

References appendPQExpBufferStr(), buf, cancel_pressed, i, initPQExpBuffer(), listOneExtensionContents(), pg_log_error, PQclear(), PQgetvalue(), PQntuples(), printfPQExpBuffer(), pset, PSQLexec(), _psqlSettings::quiet, res, termPQExpBuffer(), and validateSQLNamePattern().

Referenced by exec_command_d().

◆ listExtensions()

bool listExtensions ( const char * pattern )

Definition at line 6054 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     initPQExpBuffer(&buf);
     printfPQExpBuffer(&buf,
                       "SELECT e.extname AS \"%s\", "
                       "e.extversion AS \"%s\", n.nspname AS \"%s\", c.description AS \"%s\"\n"
                       "FROM pg_catalog.pg_extension e "
                       "LEFT JOIN pg_catalog.pg_namespace n ON n.oid = e.extnamespace "
                       "LEFT JOIN pg_catalog.pg_description c ON c.objoid = e.oid "
                       "AND c.classoid = 'pg_catalog.pg_extension'::pg_catalog.regclass\n",
                       gettext_noop("Name"),
                       gettext_noop("Version"),
                       gettext_noop("Schema"),
                       gettext_noop("Description"));
  
     if (!validateSQLNamePattern(&buf, pattern,
                                 false, false,
                                 NULL, "e.extname", NULL,
                                 NULL,
                                 NULL, 1))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of installed extensions");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), _psqlSettings::logfile, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, and validateSQLNamePattern().

Referenced by exec_command_d().

◆ listForeignDataWrappers()

bool listForeignDataWrappers	(	const char *	pattern,
		bool	verbose
	)

Definition at line 5780 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     initPQExpBuffer(&buf);
     printfPQExpBuffer(&buf,
                       "SELECT fdw.fdwname AS \"%s\",\n"
                       "  pg_catalog.pg_get_userbyid(fdw.fdwowner) AS \"%s\",\n"
                       "  fdw.fdwhandler::pg_catalog.regproc AS \"%s\",\n"
                       "  fdw.fdwvalidator::pg_catalog.regproc AS \"%s\"",
                       gettext_noop("Name"),
                       gettext_noop("Owner"),
                       gettext_noop("Handler"),
                       gettext_noop("Validator"));
  
     if (verbose)
     {
         appendPQExpBufferStr(&buf, ",\n  ");
         printACLColumn(&buf, "fdwacl");
         appendPQExpBuffer(&buf,
                           ",\n CASE WHEN fdwoptions 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(fdwoptions)),  ', ') || ')' "
                           "  END AS \"%s\""
                           ",\n  d.description AS \"%s\" ",
                           gettext_noop("FDW options"),
                           gettext_noop("Description"));
     }
  
     appendPQExpBufferStr(&buf, "\nFROM pg_catalog.pg_foreign_data_wrapper fdw\n");
  
     if (verbose)
         appendPQExpBufferStr(&buf,
                              "LEFT JOIN pg_catalog.pg_description d\n"
                              "       ON d.classoid = fdw.tableoid "
                              "AND d.objoid = fdw.oid AND d.objsubid = 0\n");
  
     if (!validateSQLNamePattern(&buf, pattern, false, false,
                                 NULL, "fdwname", NULL, NULL,
                                 NULL, 1))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of foreign-data wrappers");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), _psqlSettings::logfile, _psqlSettings::popt, PQclear(), printACLColumn(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listForeignServers()

bool listForeignServers	(	const char *	pattern,
		bool	verbose
	)

Definition at line 5851 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     initPQExpBuffer(&buf);
     printfPQExpBuffer(&buf,
                       "SELECT s.srvname AS \"%s\",\n"
                       "  pg_catalog.pg_get_userbyid(s.srvowner) AS \"%s\",\n"
                       "  f.fdwname AS \"%s\"",
                       gettext_noop("Name"),
                       gettext_noop("Owner"),
                       gettext_noop("Foreign-data wrapper"));
  
     if (verbose)
     {
         appendPQExpBufferStr(&buf, ",\n  ");
         printACLColumn(&buf, "s.srvacl");
         appendPQExpBuffer(&buf,
                           ",\n"
                           "  s.srvtype AS \"%s\",\n"
                           "  s.srvversion AS \"%s\",\n"
                           "  CASE WHEN srvoptions 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(srvoptions)),  ', ') || ')' "
                           "  END AS \"%s\",\n"
                           "  d.description AS \"%s\"",
                           gettext_noop("Type"),
                           gettext_noop("Version"),
                           gettext_noop("FDW options"),
                           gettext_noop("Description"));
     }
  
     appendPQExpBufferStr(&buf,
                          "\nFROM pg_catalog.pg_foreign_server s\n"
                          "     JOIN pg_catalog.pg_foreign_data_wrapper f ON f.oid=s.srvfdw\n");
  
     if (verbose)
         appendPQExpBufferStr(&buf,
                              "LEFT JOIN pg_catalog.pg_description d\n       "
                              "ON d.classoid = s.tableoid AND d.objoid = s.oid "
                              "AND d.objsubid = 0\n");
  
     if (!validateSQLNamePattern(&buf, pattern, false, false,
                                 NULL, "s.srvname", NULL, NULL,
                                 NULL, 1))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of foreign servers");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), _psqlSettings::logfile, _psqlSettings::popt, PQclear(), printACLColumn(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listForeignTables()

bool listForeignTables	(	const char *	pattern,
		bool	verbose
	)

Definition at line 5982 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     initPQExpBuffer(&buf);
     printfPQExpBuffer(&buf,
                       "SELECT n.nspname AS \"%s\",\n"
                       "  c.relname AS \"%s\",\n"
                       "  s.srvname AS \"%s\"",
                       gettext_noop("Schema"),
                       gettext_noop("Table"),
                       gettext_noop("Server"));
  
     if (verbose)
         appendPQExpBuffer(&buf,
                           ",\n CASE WHEN ftoptions 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(ftoptions)),  ', ') || ')' "
                           "  END AS \"%s\",\n"
                           "  d.description AS \"%s\"",
                           gettext_noop("FDW options"),
                           gettext_noop("Description"));
  
     appendPQExpBufferStr(&buf,
                          "\nFROM pg_catalog.pg_foreign_table ft\n"
                          "  INNER JOIN pg_catalog.pg_class c"
                          " ON c.oid = ft.ftrelid\n"
                          "  INNER JOIN pg_catalog.pg_namespace n"
                          " ON n.oid = c.relnamespace\n"
                          "  INNER JOIN pg_catalog.pg_foreign_server s"
                          " ON s.oid = ft.ftserver\n");
     if (verbose)
         appendPQExpBufferStr(&buf,
                              "   LEFT JOIN pg_catalog.pg_description d\n"
                              "          ON d.classoid = c.tableoid AND "
                              "d.objoid = c.oid AND d.objsubid = 0\n");
  
     if (!validateSQLNamePattern(&buf, pattern, false, false,
                                 "n.nspname", "c.relname", NULL,
                                 "pg_catalog.pg_table_is_visible(c.oid)",
                                 NULL, 3))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of foreign tables");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), _psqlSettings::logfile, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listLanguages()

bool listLanguages	(	const char *	pattern,
		bool	verbose,
		bool	showSystem
	)

Definition at line 4359 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT l.lanname AS \"%s\",\n"
                       "       pg_catalog.pg_get_userbyid(l.lanowner) as \"%s\",\n"
                       "       l.lanpltrusted AS \"%s\"",
                       gettext_noop("Name"),
                       gettext_noop("Owner"),
                       gettext_noop("Trusted"));
  
     if (verbose)
     {
         appendPQExpBuffer(&buf,
                           ",\n       NOT l.lanispl AS \"%s\",\n"
                           "       l.lanplcallfoid::pg_catalog.regprocedure AS \"%s\",\n"
                           "       l.lanvalidator::pg_catalog.regprocedure AS \"%s\",\n       "
                           "l.laninline::pg_catalog.regprocedure AS \"%s\",\n       ",
                           gettext_noop("Internal language"),
                           gettext_noop("Call handler"),
                           gettext_noop("Validator"),
                           gettext_noop("Inline handler"));
         printACLColumn(&buf, "l.lanacl");
     }
  
     appendPQExpBuffer(&buf,
                       ",\n       d.description AS \"%s\""
                       "\nFROM pg_catalog.pg_language l\n"
                       "LEFT JOIN pg_catalog.pg_description d\n"
                       "  ON d.classoid = l.tableoid AND d.objoid = l.oid\n"
                       "  AND d.objsubid = 0\n",
                       gettext_noop("Description"));
  
     if (pattern)
     {
         if (!validateSQLNamePattern(&buf, pattern, false, false,
                                     NULL, "l.lanname", NULL, NULL,
                                     NULL, 2))
         {
             termPQExpBuffer(&buf);
             return false;
         }
     }
  
     if (!showSystem && !pattern)
         appendPQExpBufferStr(&buf, "WHERE l.lanplcallfoid != 0\n");
  
  
     appendPQExpBufferStr(&buf, "ORDER BY 1;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of languages");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), _psqlSettings::logfile, _psqlSettings::popt, PQclear(), printACLColumn(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listLargeObjects()

bool listLargeObjects ( bool verbose )

Definition at line 7106 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT oid as \"%s\",\n"
                       "  pg_catalog.pg_get_userbyid(lomowner) as \"%s\",\n  ",
                       gettext_noop("ID"),
                       gettext_noop("Owner"));
  
     if (verbose)
     {
         printACLColumn(&buf, "lomacl");
         appendPQExpBufferStr(&buf, ",\n  ");
     }
  
     appendPQExpBuffer(&buf,
                       "pg_catalog.obj_description(oid, 'pg_largeobject') as \"%s\"\n"
                       "FROM pg_catalog.pg_largeobject_metadata\n"
                       "ORDER BY oid",
                       gettext_noop("Description"));
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("Large objects");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), _psqlSettings::logfile, _psqlSettings::popt, PQclear(), printACLColumn(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, and verbose.

Referenced by exec_command_d(), and exec_command_lo().

◆ listOperatorClasses()

bool listOperatorClasses	(	const char *	access_method_pattern,
		const char *	type_pattern,
		bool	verbose
	)

Definition at line 6729 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     bool        have_where = false;
     static const bool translate_columns[] = {false, false, false, false, false, false, false};
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT\n"
                       "  am.amname AS \"%s\",\n"
                       "  pg_catalog.format_type(c.opcintype, NULL) AS \"%s\",\n"
                       "  CASE\n"
                       "    WHEN c.opckeytype <> 0 AND c.opckeytype <> c.opcintype\n"
                       "    THEN pg_catalog.format_type(c.opckeytype, NULL)\n"
                       "    ELSE NULL\n"
                       "  END AS \"%s\",\n"
                       "  CASE\n"
                       "    WHEN pg_catalog.pg_opclass_is_visible(c.oid)\n"
                       "    THEN pg_catalog.format('%%I', c.opcname)\n"
                       "    ELSE pg_catalog.format('%%I.%%I', n.nspname, c.opcname)\n"
                       "  END AS \"%s\",\n"
                       "  (CASE WHEN c.opcdefault\n"
                       "    THEN '%s'\n"
                       "    ELSE '%s'\n"
                       "  END) AS \"%s\"",
                       gettext_noop("AM"),
                       gettext_noop("Input type"),
                       gettext_noop("Storage type"),
                       gettext_noop("Operator class"),
                       gettext_noop("yes"),
                       gettext_noop("no"),
                       gettext_noop("Default?"));
     if (verbose)
         appendPQExpBuffer(&buf,
                           ",\n  CASE\n"
                           "    WHEN pg_catalog.pg_opfamily_is_visible(of.oid)\n"
                           "    THEN pg_catalog.format('%%I', of.opfname)\n"
                           "    ELSE pg_catalog.format('%%I.%%I', ofn.nspname, of.opfname)\n"
                           "  END AS \"%s\",\n"
                           " pg_catalog.pg_get_userbyid(c.opcowner) AS \"%s\"\n",
                           gettext_noop("Operator family"),
                           gettext_noop("Owner"));
     appendPQExpBufferStr(&buf,
                          "\nFROM pg_catalog.pg_opclass c\n"
                          "  LEFT JOIN pg_catalog.pg_am am on am.oid = c.opcmethod\n"
                          "  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.opcnamespace\n"
                          "  LEFT JOIN pg_catalog.pg_type t ON t.oid = c.opcintype\n"
                          "  LEFT JOIN pg_catalog.pg_namespace tn ON tn.oid = t.typnamespace\n");
     if (verbose)
         appendPQExpBufferStr(&buf,
                              "  LEFT JOIN pg_catalog.pg_opfamily of ON of.oid = c.opcfamily\n"
                              "  LEFT JOIN pg_catalog.pg_namespace ofn ON ofn.oid = of.opfnamespace\n");
  
     if (access_method_pattern)
         if (!validateSQLNamePattern(&buf, access_method_pattern,
                                     false, false, NULL, "am.amname", NULL, NULL,
                                     &have_where, 1))
             goto error_return;
     if (type_pattern)
     {
         /* Match type name pattern against either internal or external name */
         if (!validateSQLNamePattern(&buf, type_pattern, have_where, false,
                                     "tn.nspname", "t.typname",
                                     "pg_catalog.format_type(t.oid, NULL)",
                                     "pg_catalog.pg_type_is_visible(t.oid)",
                                     NULL, 3))
             goto error_return;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2, 4;");
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of operator classes");
     myopt.translate_header = true;
     myopt.translate_columns = translate_columns;
     myopt.n_translate_columns = lengthof(translate_columns);
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
  
 error_return:
     termPQExpBuffer(&buf);
     return false;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), lengthof, _psqlSettings::logfile, printQueryOpt::n_translate_columns, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_columns, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listOperatorFamilies()

bool listOperatorFamilies	(	const char *	access_method_pattern,
		const char *	type_pattern,
		bool	verbose
	)

Definition at line 6830 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     bool        have_where = false;
     static const bool translate_columns[] = {false, false, false, false};
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT\n"
                       "  am.amname AS \"%s\",\n"
                       "  CASE\n"
                       "    WHEN pg_catalog.pg_opfamily_is_visible(f.oid)\n"
                       "    THEN pg_catalog.format('%%I', f.opfname)\n"
                       "    ELSE pg_catalog.format('%%I.%%I', n.nspname, f.opfname)\n"
                       "  END AS \"%s\",\n"
                       "  (SELECT\n"
                       "     pg_catalog.string_agg(pg_catalog.format_type(oc.opcintype, NULL), ', ')\n"
                       "   FROM pg_catalog.pg_opclass oc\n"
                       "   WHERE oc.opcfamily = f.oid) \"%s\"",
                       gettext_noop("AM"),
                       gettext_noop("Operator family"),
                       gettext_noop("Applicable types"));
     if (verbose)
         appendPQExpBuffer(&buf,
                           ",\n  pg_catalog.pg_get_userbyid(f.opfowner) AS \"%s\"\n",
                           gettext_noop("Owner"));
     appendPQExpBufferStr(&buf,
                          "\nFROM pg_catalog.pg_opfamily f\n"
                          "  LEFT JOIN pg_catalog.pg_am am on am.oid = f.opfmethod\n"
                          "  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = f.opfnamespace\n");
  
     if (access_method_pattern)
         if (!validateSQLNamePattern(&buf, access_method_pattern,
                                     false, false, NULL, "am.amname", NULL, NULL,
                                     &have_where, 1))
             goto error_return;
     if (type_pattern)
     {
         appendPQExpBuffer(&buf,
                           "  %s EXISTS (\n"
                           "    SELECT 1\n"
                           "    FROM pg_catalog.pg_type t\n"
                           "    JOIN pg_catalog.pg_opclass oc ON oc.opcintype = t.oid\n"
                           "    LEFT JOIN pg_catalog.pg_namespace tn ON tn.oid = t.typnamespace\n"
                           "    WHERE oc.opcfamily = f.oid\n",
                           have_where ? "AND" : "WHERE");
         /* Match type name pattern against either internal or external name */
         if (!validateSQLNamePattern(&buf, type_pattern, true, false,
                                     "tn.nspname", "t.typname",
                                     "pg_catalog.format_type(t.oid, NULL)",
                                     "pg_catalog.pg_type_is_visible(t.oid)",
                                     NULL, 3))
             goto error_return;
         appendPQExpBufferStr(&buf, "  )\n");
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2;");
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of operator families");
     myopt.translate_header = true;
     myopt.translate_columns = translate_columns;
     myopt.n_translate_columns = lengthof(translate_columns);
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
  
 error_return:
     termPQExpBuffer(&buf);
     return false;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), lengthof, _psqlSettings::logfile, printQueryOpt::n_translate_columns, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_columns, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listOpFamilyFunctions()

bool listOpFamilyFunctions	(	const char *	access_method_pattern,
		const char *	family_pattern,
		bool	verbose
	)

Definition at line 7017 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     bool        have_where = false;
     static const bool translate_columns[] = {false, false, false, false, false, false};
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT\n"
                       "  am.amname AS \"%s\",\n"
                       "  CASE\n"
                       "    WHEN pg_catalog.pg_opfamily_is_visible(of.oid)\n"
                       "    THEN pg_catalog.format('%%I', of.opfname)\n"
                       "    ELSE pg_catalog.format('%%I.%%I', ns.nspname, of.opfname)\n"
                       "  END AS \"%s\",\n"
                       "  pg_catalog.format_type(ap.amproclefttype, NULL) AS \"%s\",\n"
                       "  pg_catalog.format_type(ap.amprocrighttype, NULL) AS \"%s\",\n"
                       "  ap.amprocnum AS \"%s\"\n",
                       gettext_noop("AM"),
                       gettext_noop("Operator family"),
                       gettext_noop("Registered left type"),
                       gettext_noop("Registered right type"),
                       gettext_noop("Number"));
  
     if (!verbose)
         appendPQExpBuffer(&buf,
                           ", p.proname AS \"%s\"\n",
                           gettext_noop("Function"));
     else
         appendPQExpBuffer(&buf,
                           ", ap.amproc::pg_catalog.regprocedure AS \"%s\"\n",
                           gettext_noop("Function"));
  
     appendPQExpBufferStr(&buf,
                          "FROM pg_catalog.pg_amproc ap\n"
                          "  LEFT JOIN pg_catalog.pg_opfamily of ON of.oid = ap.amprocfamily\n"
                          "  LEFT JOIN pg_catalog.pg_am am ON am.oid = of.opfmethod\n"
                          "  LEFT JOIN pg_catalog.pg_namespace ns ON of.opfnamespace = ns.oid\n"
                          "  LEFT JOIN pg_catalog.pg_proc p ON ap.amproc = p.oid\n");
  
     if (access_method_pattern)
     {
         if (!validateSQLNamePattern(&buf, access_method_pattern,
                                     false, false, NULL, "am.amname",
                                     NULL, NULL,
                                     &have_where, 1))
             goto error_return;
     }
     if (family_pattern)
     {
         if (!validateSQLNamePattern(&buf, family_pattern, have_where, false,
                                     "ns.nspname", "of.opfname", NULL, NULL,
                                     NULL, 3))
             goto error_return;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2,\n"
                          "  ap.amproclefttype = ap.amprocrighttype DESC,\n"
                          "  3, 4, 5;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of support functions of operator families");
     myopt.translate_header = true;
     myopt.translate_columns = translate_columns;
     myopt.n_translate_columns = lengthof(translate_columns);
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
  
 error_return:
     termPQExpBuffer(&buf);
     return false;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), lengthof, _psqlSettings::logfile, printQueryOpt::n_translate_columns, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_columns, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listOpFamilyOperators()

bool listOpFamilyOperators	(	const char *	access_method_pattern,
		const char *	family_pattern,
		bool	verbose
	)

Definition at line 6919 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     bool        have_where = false;
  
     static const bool translate_columns[] = {false, false, false, false, false, false};
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT\n"
                       "  am.amname AS \"%s\",\n"
                       "  CASE\n"
                       "    WHEN pg_catalog.pg_opfamily_is_visible(of.oid)\n"
                       "    THEN pg_catalog.format('%%I', of.opfname)\n"
                       "    ELSE pg_catalog.format('%%I.%%I', nsf.nspname, of.opfname)\n"
                       "  END AS \"%s\",\n"
                       "  o.amopopr::pg_catalog.regoperator AS \"%s\"\n,"
                       "  o.amopstrategy AS \"%s\",\n"
                       "  CASE o.amoppurpose\n"
                       "    WHEN 'o' THEN '%s'\n"
                       "    WHEN 's' THEN '%s'\n"
                       "  END AS \"%s\"\n",
                       gettext_noop("AM"),
                       gettext_noop("Operator family"),
                       gettext_noop("Operator"),
                       gettext_noop("Strategy"),
                       gettext_noop("ordering"),
                       gettext_noop("search"),
                       gettext_noop("Purpose"));
  
     if (verbose)
         appendPQExpBuffer(&buf,
                           ", ofs.opfname AS \"%s\"\n",
                           gettext_noop("Sort opfamily"));
     appendPQExpBufferStr(&buf,
                          "FROM pg_catalog.pg_amop o\n"
                          "  LEFT JOIN pg_catalog.pg_opfamily of ON of.oid = o.amopfamily\n"
                          "  LEFT JOIN pg_catalog.pg_am am ON am.oid = of.opfmethod AND am.oid = o.amopmethod\n"
                          "  LEFT JOIN pg_catalog.pg_namespace nsf ON of.opfnamespace = nsf.oid\n");
     if (verbose)
         appendPQExpBufferStr(&buf,
                              "  LEFT JOIN pg_catalog.pg_opfamily ofs ON ofs.oid = o.amopsortfamily\n");
  
     if (access_method_pattern)
     {
         if (!validateSQLNamePattern(&buf, access_method_pattern,
                                     false, false, NULL, "am.amname",
                                     NULL, NULL,
                                     &have_where, 1))
             goto error_return;
     }
  
     if (family_pattern)
     {
         if (!validateSQLNamePattern(&buf, family_pattern, have_where, false,
                                     "nsf.nspname", "of.opfname", NULL, NULL,
                                     NULL, 3))
             goto error_return;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2,\n"
                          "  o.amoplefttype = o.amoprighttype DESC,\n"
                          "  pg_catalog.format_type(o.amoplefttype, NULL),\n"
                          "  pg_catalog.format_type(o.amoprighttype, NULL),\n"
                          "  o.amopstrategy;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of operators of operator families");
     myopt.translate_header = true;
     myopt.translate_columns = translate_columns;
     myopt.n_translate_columns = lengthof(translate_columns);
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
  
 error_return:
     termPQExpBuffer(&buf);
     return false;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), lengthof, _psqlSettings::logfile, printQueryOpt::n_translate_columns, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_columns, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listPartitionedTables()

bool listPartitionedTables	(	const char *	reltypes,
		const char *	pattern,
		bool	verbose
	)

Definition at line 4159 of file describe.c.

 {
     bool        showTables = strchr(reltypes, 't') != NULL;
     bool        showIndexes = strchr(reltypes, 'i') != NULL;
     bool        showNested = strchr(reltypes, 'n') != NULL;
     PQExpBufferData buf;
     PQExpBufferData title;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     bool        translate_columns[] = {false, false, false, false, false, false, false, false, false};
     const char *tabletitle;
     bool        mixed_output = false;
  
     /*
      * Note: Declarative table partitioning is only supported as of Pg 10.0.
      */
     if (pset.sversion < 100000)
     {
         char        sverbuf[32];
  
         pg_log_error("The server (version %s) does not support declarative table partitioning.",
                      formatPGVersionNumber(pset.sversion, false,
                                            sverbuf, sizeof(sverbuf)));
         return true;
     }
  
     /* If no relation kind was selected, show them all */
     if (!showTables && !showIndexes)
         showTables = showIndexes = true;
  
     if (showIndexes && !showTables)
         tabletitle = _("List of partitioned indexes");  /* \dPi */
     else if (showTables && !showIndexes)
         tabletitle = _("List of partitioned tables");   /* \dPt */
     else
     {
         /* show all kinds */
         tabletitle = _("List of partitioned relations");
         mixed_output = true;
     }
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT n.nspname as \"%s\",\n"
                       "  c.relname as \"%s\",\n"
                       "  pg_catalog.pg_get_userbyid(c.relowner) as \"%s\"",
                       gettext_noop("Schema"),
                       gettext_noop("Name"),
                       gettext_noop("Owner"));
  
     if (mixed_output)
     {
         appendPQExpBuffer(&buf,
                           ",\n  CASE c.relkind"
                           " WHEN " CppAsString2(RELKIND_PARTITIONED_TABLE) " THEN '%s'"
                           " WHEN " CppAsString2(RELKIND_PARTITIONED_INDEX) " THEN '%s'"
                           " END as \"%s\"",
                           gettext_noop("partitioned table"),
                           gettext_noop("partitioned index"),
                           gettext_noop("Type"));
  
         translate_columns[3] = true;
     }
  
     if (showNested || pattern)
         appendPQExpBuffer(&buf,
                           ",\n  inh.inhparent::pg_catalog.regclass as \"%s\"",
                           gettext_noop("Parent name"));
  
     if (showIndexes)
         appendPQExpBuffer(&buf,
                           ",\n c2.oid::pg_catalog.regclass as \"%s\"",
                           gettext_noop("Table"));
  
     if (verbose)
     {
         if (showNested)
         {
             appendPQExpBuffer(&buf,
                               ",\n  s.dps as \"%s\"",
                               gettext_noop("Leaf partition size"));
             appendPQExpBuffer(&buf,
                               ",\n  s.tps as \"%s\"",
                               gettext_noop("Total size"));
         }
         else
             /* Sizes of all partitions are considered in this case. */
             appendPQExpBuffer(&buf,
                               ",\n  s.tps as \"%s\"",
                               gettext_noop("Total size"));
  
         appendPQExpBuffer(&buf,
                           ",\n  pg_catalog.obj_description(c.oid, 'pg_class') as \"%s\"",
                           gettext_noop("Description"));
     }
  
     appendPQExpBufferStr(&buf,
                          "\nFROM pg_catalog.pg_class c"
                          "\n     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace");
  
     if (showIndexes)
         appendPQExpBufferStr(&buf,
                              "\n     LEFT JOIN pg_catalog.pg_index i ON i.indexrelid = c.oid"
                              "\n     LEFT JOIN pg_catalog.pg_class c2 ON i.indrelid = c2.oid");
  
     if (showNested || pattern)
         appendPQExpBufferStr(&buf,
                              "\n     LEFT JOIN pg_catalog.pg_inherits inh ON c.oid = inh.inhrelid");
  
     if (verbose)
     {
         if (pset.sversion < 120000)
         {
             appendPQExpBufferStr(&buf,
                                  ",\n     LATERAL (WITH RECURSIVE d\n"
                                  "                AS (SELECT inhrelid AS oid, 1 AS level\n"
                                  "                      FROM pg_catalog.pg_inherits\n"
                                  "                     WHERE inhparent = c.oid\n"
                                  "                    UNION ALL\n"
                                  "                    SELECT inhrelid, level + 1\n"
                                  "                      FROM pg_catalog.pg_inherits i\n"
                                  "                           JOIN d ON i.inhparent = d.oid)\n"
                                  "                SELECT pg_catalog.pg_size_pretty(sum(pg_catalog.pg_table_size("
                                  "d.oid))) AS tps,\n"
                                  "                       pg_catalog.pg_size_pretty(sum("
                                  "\n             CASE WHEN d.level = 1"
                                  " THEN pg_catalog.pg_table_size(d.oid) ELSE 0 END)) AS dps\n"
                                  "               FROM d) s");
         }
         else
         {
             /* PostgreSQL 12 has pg_partition_tree function */
             appendPQExpBufferStr(&buf,
                                  ",\n     LATERAL (SELECT pg_catalog.pg_size_pretty(sum("
                                  "\n                 CASE WHEN ppt.isleaf AND ppt.level = 1"
                                  "\n                      THEN pg_catalog.pg_table_size(ppt.relid)"
                                  " ELSE 0 END)) AS dps"
                                  ",\n                     pg_catalog.pg_size_pretty(sum("
                                  "pg_catalog.pg_table_size(ppt.relid))) AS tps"
                                  "\n              FROM pg_catalog.pg_partition_tree(c.oid) ppt) s");
         }
     }
  
     appendPQExpBufferStr(&buf, "\nWHERE c.relkind IN (");
     if (showTables)
         appendPQExpBufferStr(&buf, CppAsString2(RELKIND_PARTITIONED_TABLE) ",");
     if (showIndexes)
         appendPQExpBufferStr(&buf, CppAsString2(RELKIND_PARTITIONED_INDEX) ",");
     appendPQExpBufferStr(&buf, "''");   /* dummy */
     appendPQExpBufferStr(&buf, ")\n");
  
     appendPQExpBufferStr(&buf, !showNested && !pattern ?
                          " AND NOT c.relispartition\n" : "");
  
     if (!pattern)
         appendPQExpBufferStr(&buf, "      AND n.nspname <> 'pg_catalog'\n"
                              "      AND n.nspname !~ '^pg_toast'\n"
                              "      AND n.nspname <> 'information_schema'\n");
  
     if (!validateSQLNamePattern(&buf, pattern, true, false,
                                 "n.nspname", "c.relname", NULL,
                                 "pg_catalog.pg_table_is_visible(c.oid)",
                                 NULL, 3))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBuffer(&buf, "ORDER BY \"Schema\", %s%s\"Name\";",
                       mixed_output ? "\"Type\" DESC, " : "",
                       showNested || pattern ? "\"Parent name\" NULLS FIRST, " : "");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     initPQExpBuffer(&title);
     appendPQExpBufferStr(&title, tabletitle);
  
     myopt.title = title.data;
     myopt.translate_header = true;
     myopt.translate_columns = translate_columns;
     myopt.n_translate_columns = lengthof(translate_columns);
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     termPQExpBuffer(&title);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, CppAsString2, PQExpBufferData::data, formatPGVersionNumber(), gettext_noop, initPQExpBuffer(), lengthof, _psqlSettings::logfile, printQueryOpt::n_translate_columns, pg_log_error, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, _psqlSettings::sversion, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_columns, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listPublications()

bool listPublications ( const char * pattern )

Definition at line 6269 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     static const bool translate_columns[] = {false, false, false, false, false, false, false, false};
  
     if (pset.sversion < 100000)
     {
         char        sverbuf[32];
  
         pg_log_error("The server (version %s) does not support publications.",
                      formatPGVersionNumber(pset.sversion, false,
                                            sverbuf, sizeof(sverbuf)));
         return true;
     }
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT pubname AS \"%s\",\n"
                       "  pg_catalog.pg_get_userbyid(pubowner) AS \"%s\",\n"
                       "  puballtables AS \"%s\",\n"
                       "  pubinsert AS \"%s\",\n"
                       "  pubupdate AS \"%s\",\n"
                       "  pubdelete AS \"%s\"",
                       gettext_noop("Name"),
                       gettext_noop("Owner"),
                       gettext_noop("All tables"),
                       gettext_noop("Inserts"),
                       gettext_noop("Updates"),
                       gettext_noop("Deletes"));
     if (pset.sversion >= 110000)
         appendPQExpBuffer(&buf,
                           ",\n  pubtruncate AS \"%s\"",
                           gettext_noop("Truncates"));
     if (pset.sversion >= 130000)
         appendPQExpBuffer(&buf,
                           ",\n  pubviaroot AS \"%s\"",
                           gettext_noop("Via root"));
  
     appendPQExpBufferStr(&buf,
                          "\nFROM pg_catalog.pg_publication\n");
  
     if (!validateSQLNamePattern(&buf, pattern, false, false,
                                 NULL, "pubname", NULL,
                                 NULL,
                                 NULL, 1))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of publications");
     myopt.translate_header = true;
     myopt.translate_columns = translate_columns;
     myopt.n_translate_columns = lengthof(translate_columns);
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
  
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, formatPGVersionNumber(), gettext_noop, initPQExpBuffer(), lengthof, _psqlSettings::logfile, printQueryOpt::n_translate_columns, pg_log_error, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, _psqlSettings::sversion, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_columns, printQueryOpt::translate_header, and validateSQLNamePattern().

Referenced by exec_command_d().

◆ listSchemas()

bool listSchemas	(	const char *	pattern,
		bool	verbose,
		bool	showSystem
	)

Definition at line 5078 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     int         pub_schema_tuples = 0;
     char      **footers = NULL;
  
     initPQExpBuffer(&buf);
     printfPQExpBuffer(&buf,
                       "SELECT n.nspname AS \"%s\",\n"
                       "  pg_catalog.pg_get_userbyid(n.nspowner) AS \"%s\"",
                       gettext_noop("Name"),
                       gettext_noop("Owner"));
  
     if (verbose)
     {
         appendPQExpBufferStr(&buf, ",\n  ");
         printACLColumn(&buf, "n.nspacl");
         appendPQExpBuffer(&buf,
                           ",\n  pg_catalog.obj_description(n.oid, 'pg_namespace') AS \"%s\"",
                           gettext_noop("Description"));
     }
  
     appendPQExpBufferStr(&buf,
                          "\nFROM pg_catalog.pg_namespace n\n");
  
     if (!showSystem && !pattern)
         appendPQExpBufferStr(&buf,
                              "WHERE n.nspname !~ '^pg_' AND n.nspname <> 'information_schema'\n");
  
     if (!validateSQLNamePattern(&buf, pattern,
                                 !showSystem && !pattern, false,
                                 NULL, "n.nspname", NULL,
                                 NULL,
                                 NULL, 2))
         goto error_return;
  
     appendPQExpBufferStr(&buf, "ORDER BY 1;");
  
     res = PSQLexec(buf.data);
     if (!res)
         goto error_return;
  
     myopt.title = _("List of schemas");
     myopt.translate_header = true;
  
     if (pattern && pset.sversion >= 150000)
     {
         PGresult   *result;
         int         i;
  
         printfPQExpBuffer(&buf,
                           "SELECT pubname \n"
                           "FROM pg_catalog.pg_publication p\n"
                           "     JOIN pg_catalog.pg_publication_namespace pn ON p.oid = pn.pnpubid\n"
                           "     JOIN pg_catalog.pg_namespace n ON n.oid = pn.pnnspid \n"
                           "WHERE n.nspname = '%s'\n"
                           "ORDER BY 1",
                           pattern);
         result = PSQLexec(buf.data);
         if (!result)
             goto error_return;
         else
             pub_schema_tuples = PQntuples(result);
  
         if (pub_schema_tuples > 0)
         {
             /*
              * Allocate memory for footers. Size of footers will be 1 (for
              * storing "Publications:" string) + publication schema mapping
              * count +  1 (for storing NULL).
              */
             footers = (char **) pg_malloc((1 + pub_schema_tuples + 1) * sizeof(char *));
             footers[0] = pg_strdup(_("Publications:"));
  
             /* Might be an empty set - that's ok */
             for (i = 0; i < pub_schema_tuples; i++)
             {
                 printfPQExpBuffer(&buf, "    \"%s\"",
                                   PQgetvalue(result, i, 0));
  
                 footers[i + 1] = pg_strdup(buf.data);
             }
  
             footers[i + 1] = NULL;
             myopt.footers = footers;
         }
  
         PQclear(result);
     }
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     termPQExpBuffer(&buf);
     PQclear(res);
  
     /* Free the memory allocated for the footer */
     if (footers)
     {
         char      **footer = NULL;
  
         for (footer = footers; *footer; footer++)
             pg_free(*footer);
  
         pg_free(footers);
     }
  
     return true;
  
 error_return:
     termPQExpBuffer(&buf);
     return false;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, printQueryOpt::footers, gettext_noop, i, initPQExpBuffer(), _psqlSettings::logfile, pg_free(), pg_malloc(), pg_strdup(), _psqlSettings::popt, PQclear(), PQgetvalue(), PQntuples(), printACLColumn(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, _psqlSettings::sversion, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listTables()

bool listTables	(	const char *	tabtypes,
		const char *	pattern,
		bool	verbose,
		bool	showSystem
	)

Definition at line 3961 of file describe.c.

 {
     bool        showTables = strchr(tabtypes, 't') != NULL;
     bool        showIndexes = strchr(tabtypes, 'i') != NULL;
     bool        showViews = strchr(tabtypes, 'v') != NULL;
     bool        showMatViews = strchr(tabtypes, 'm') != NULL;
     bool        showSeq = strchr(tabtypes, 's') != NULL;
     bool        showForeign = strchr(tabtypes, 'E') != NULL;
  
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     int         cols_so_far;
     bool        translate_columns[] = {false, false, true, false, false, false, false, false, false};
  
     /* If tabtypes is empty, we default to \dtvmsE (but see also command.c) */
     if (!(showTables || showIndexes || showViews || showMatViews || showSeq || showForeign))
         showTables = showViews = showMatViews = showSeq = showForeign = true;
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT n.nspname as \"%s\",\n"
                       "  c.relname as \"%s\",\n"
                       "  CASE c.relkind"
                       " WHEN " CppAsString2(RELKIND_RELATION) " THEN '%s'"
                       " WHEN " CppAsString2(RELKIND_VIEW) " THEN '%s'"
                       " WHEN " CppAsString2(RELKIND_MATVIEW) " THEN '%s'"
                       " WHEN " CppAsString2(RELKIND_INDEX) " THEN '%s'"
                       " WHEN " CppAsString2(RELKIND_SEQUENCE) " THEN '%s'"
                       " WHEN " CppAsString2(RELKIND_TOASTVALUE) " THEN '%s'"
                       " WHEN " CppAsString2(RELKIND_FOREIGN_TABLE) " THEN '%s'"
                       " WHEN " CppAsString2(RELKIND_PARTITIONED_TABLE) " THEN '%s'"
                       " WHEN " CppAsString2(RELKIND_PARTITIONED_INDEX) " THEN '%s'"
                       " END as \"%s\",\n"
                       "  pg_catalog.pg_get_userbyid(c.relowner) as \"%s\"",
                       gettext_noop("Schema"),
                       gettext_noop("Name"),
                       gettext_noop("table"),
                       gettext_noop("view"),
                       gettext_noop("materialized view"),
                       gettext_noop("index"),
                       gettext_noop("sequence"),
                       gettext_noop("TOAST table"),
                       gettext_noop("foreign table"),
                       gettext_noop("partitioned table"),
                       gettext_noop("partitioned index"),
                       gettext_noop("Type"),
                       gettext_noop("Owner"));
     cols_so_far = 4;
  
     if (showIndexes)
     {
         appendPQExpBuffer(&buf,
                           ",\n  c2.relname as \"%s\"",
                           gettext_noop("Table"));
         cols_so_far++;
     }
  
     if (verbose)
     {
         /*
          * Show whether a relation is permanent, temporary, or unlogged.
          */
         appendPQExpBuffer(&buf,
                           ",\n  CASE c.relpersistence WHEN 'p' THEN '%s' WHEN 't' THEN '%s' WHEN 'u' THEN '%s' END as \"%s\"",
                           gettext_noop("permanent"),
                           gettext_noop("temporary"),
                           gettext_noop("unlogged"),
                           gettext_noop("Persistence"));
         translate_columns[cols_so_far] = true;
  
         /*
          * We don't bother to count cols_so_far below here, as there's no need
          * to; this might change with future additions to the output columns.
          */
  
         /*
          * Access methods exist for tables, materialized views and indexes.
          * This has been introduced in PostgreSQL 12 for tables.
          */
         if (pset.sversion >= 120000 && !pset.hide_tableam &&
             (showTables || showMatViews || showIndexes))
             appendPQExpBuffer(&buf,
                               ",\n  am.amname as \"%s\"",
                               gettext_noop("Access method"));
  
         appendPQExpBuffer(&buf,
                           ",\n  pg_catalog.pg_size_pretty(pg_catalog.pg_table_size(c.oid)) as \"%s\""
                           ",\n  pg_catalog.obj_description(c.oid, 'pg_class') as \"%s\"",
                           gettext_noop("Size"),
                           gettext_noop("Description"));
     }
  
     appendPQExpBufferStr(&buf,
                          "\nFROM pg_catalog.pg_class c"
                          "\n     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace");
  
     if (pset.sversion >= 120000 && !pset.hide_tableam &&
         (showTables || showMatViews || showIndexes))
         appendPQExpBufferStr(&buf,
                              "\n     LEFT JOIN pg_catalog.pg_am am ON am.oid = c.relam");
  
     if (showIndexes)
         appendPQExpBufferStr(&buf,
                              "\n     LEFT JOIN pg_catalog.pg_index i ON i.indexrelid = c.oid"
                              "\n     LEFT JOIN pg_catalog.pg_class c2 ON i.indrelid = c2.oid");
  
     appendPQExpBufferStr(&buf, "\nWHERE c.relkind IN (");
     if (showTables)
     {
         appendPQExpBufferStr(&buf, CppAsString2(RELKIND_RELATION) ","
                              CppAsString2(RELKIND_PARTITIONED_TABLE) ",");
         /* with 'S' or a pattern, allow 't' to match TOAST tables too */
         if (showSystem || pattern)
             appendPQExpBufferStr(&buf, CppAsString2(RELKIND_TOASTVALUE) ",");
     }
     if (showViews)
         appendPQExpBufferStr(&buf, CppAsString2(RELKIND_VIEW) ",");
     if (showMatViews)
         appendPQExpBufferStr(&buf, CppAsString2(RELKIND_MATVIEW) ",");
     if (showIndexes)
         appendPQExpBufferStr(&buf, CppAsString2(RELKIND_INDEX) ","
                              CppAsString2(RELKIND_PARTITIONED_INDEX) ",");
     if (showSeq)
         appendPQExpBufferStr(&buf, CppAsString2(RELKIND_SEQUENCE) ",");
     if (showSystem || pattern)
         appendPQExpBufferStr(&buf, "'s',"); /* was RELKIND_SPECIAL */
     if (showForeign)
         appendPQExpBufferStr(&buf, CppAsString2(RELKIND_FOREIGN_TABLE) ",");
  
     appendPQExpBufferStr(&buf, "''");   /* dummy */
     appendPQExpBufferStr(&buf, ")\n");
  
     if (!showSystem && !pattern)
         appendPQExpBufferStr(&buf, "      AND n.nspname <> 'pg_catalog'\n"
                              "      AND n.nspname !~ '^pg_toast'\n"
                              "      AND n.nspname <> 'information_schema'\n");
  
     if (!validateSQLNamePattern(&buf, pattern, true, false,
                                 "n.nspname", "c.relname", NULL,
                                 "pg_catalog.pg_table_is_visible(c.oid)",
                                 NULL, 3))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1,2;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     /*
      * Most functions in this file are content to print an empty table when
      * there are no matching objects.  We intentionally deviate from that
      * here, but only in !quiet mode, for historical reasons.
      */
     if (PQntuples(res) == 0 && !pset.quiet)
     {
         if (pattern)
             pg_log_error("Did not find any relation named \"%s\".",
                          pattern);
         else
             pg_log_error("Did not find any relations.");
     }
     else
     {
         myopt.title = _("List of relations");
         myopt.translate_header = true;
         myopt.translate_columns = translate_columns;
         myopt.n_translate_columns = lengthof(translate_columns);
  
         printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
     }
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, CppAsString2, gettext_noop, _psqlSettings::hide_tableam, initPQExpBuffer(), lengthof, _psqlSettings::logfile, printQueryOpt::n_translate_columns, pg_log_error, _psqlSettings::popt, PQclear(), PQntuples(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, _psqlSettings::quiet, res, _psqlSettings::sversion, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_columns, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listTSConfigs()

bool listTSConfigs	(	const char *	pattern,
		bool	verbose
	)

Definition at line 5576 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     if (verbose)
         return listTSConfigsVerbose(pattern);
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT\n"
                       "   n.nspname as \"%s\",\n"
                       "   c.cfgname as \"%s\",\n"
                       "   pg_catalog.obj_description(c.oid, 'pg_ts_config') as \"%s\"\n"
                       "FROM pg_catalog.pg_ts_config c\n"
                       "LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.cfgnamespace\n",
                       gettext_noop("Schema"),
                       gettext_noop("Name"),
                       gettext_noop("Description")
         );
  
     if (!validateSQLNamePattern(&buf, pattern, false, false,
                                 "n.nspname", "c.cfgname", NULL,
                                 "pg_catalog.pg_ts_config_is_visible(c.oid)",
                                 NULL, 3))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of text search configurations");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), listTSConfigsVerbose(), _psqlSettings::logfile, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listTSDictionaries()

bool listTSDictionaries	(	const char *	pattern,
		bool	verbose
	)

Definition at line 5446 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT\n"
                       "  n.nspname as \"%s\",\n"
                       "  d.dictname as \"%s\",\n",
                       gettext_noop("Schema"),
                       gettext_noop("Name"));
  
     if (verbose)
     {
         appendPQExpBuffer(&buf,
                           "  ( SELECT COALESCE(nt.nspname, '(null)')::pg_catalog.text || '.' || t.tmplname FROM\n"
                           "    pg_catalog.pg_ts_template t\n"
                           "    LEFT JOIN pg_catalog.pg_namespace nt ON nt.oid = t.tmplnamespace\n"
                           "    WHERE d.dicttemplate = t.oid ) AS  \"%s\",\n"
                           "  d.dictinitoption as \"%s\",\n",
                           gettext_noop("Template"),
                           gettext_noop("Init options"));
     }
  
     appendPQExpBuffer(&buf,
                       "  pg_catalog.obj_description(d.oid, 'pg_ts_dict') as \"%s\"\n",
                       gettext_noop("Description"));
  
     appendPQExpBufferStr(&buf, "FROM pg_catalog.pg_ts_dict d\n"
                          "LEFT JOIN pg_catalog.pg_namespace n ON n.oid = d.dictnamespace\n");
  
     if (!validateSQLNamePattern(&buf, pattern, false, false,
                                 "n.nspname", "d.dictname", NULL,
                                 "pg_catalog.pg_ts_dict_is_visible(d.oid)",
                                 NULL, 3))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of text search dictionaries");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), _psqlSettings::logfile, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listTSParsers()

bool listTSParsers	(	const char *	pattern,
		bool	verbose
	)

Definition at line 5199 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     if (verbose)
         return listTSParsersVerbose(pattern);
  
     initPQExpBuffer(&buf);
  
     printfPQExpBuffer(&buf,
                       "SELECT\n"
                       "  n.nspname as \"%s\",\n"
                       "  p.prsname as \"%s\",\n"
                       "  pg_catalog.obj_description(p.oid, 'pg_ts_parser') as \"%s\"\n"
                       "FROM pg_catalog.pg_ts_parser p\n"
                       "LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.prsnamespace\n",
                       gettext_noop("Schema"),
                       gettext_noop("Name"),
                       gettext_noop("Description")
         );
  
     if (!validateSQLNamePattern(&buf, pattern, false, false,
                                 "n.nspname", "p.prsname", NULL,
                                 "pg_catalog.pg_ts_parser_is_visible(p.oid)",
                                 NULL, 3))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of text search parsers");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), listTSParsersVerbose(), _psqlSettings::logfile, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listTSTemplates()

bool listTSTemplates	(	const char *	pattern,
		bool	verbose
	)

Definition at line 5511 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     initPQExpBuffer(&buf);
  
     if (verbose)
         printfPQExpBuffer(&buf,
                           "SELECT\n"
                           "  n.nspname AS \"%s\",\n"
                           "  t.tmplname AS \"%s\",\n"
                           "  t.tmplinit::pg_catalog.regproc AS \"%s\",\n"
                           "  t.tmpllexize::pg_catalog.regproc AS \"%s\",\n"
                           "  pg_catalog.obj_description(t.oid, 'pg_ts_template') AS \"%s\"\n",
                           gettext_noop("Schema"),
                           gettext_noop("Name"),
                           gettext_noop("Init"),
                           gettext_noop("Lexize"),
                           gettext_noop("Description"));
     else
         printfPQExpBuffer(&buf,
                           "SELECT\n"
                           "  n.nspname AS \"%s\",\n"
                           "  t.tmplname AS \"%s\",\n"
                           "  pg_catalog.obj_description(t.oid, 'pg_ts_template') AS \"%s\"\n",
                           gettext_noop("Schema"),
                           gettext_noop("Name"),
                           gettext_noop("Description"));
  
     appendPQExpBufferStr(&buf, "FROM pg_catalog.pg_ts_template t\n"
                          "LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.tmplnamespace\n");
  
     if (!validateSQLNamePattern(&buf, pattern, false, false,
                                 "n.nspname", "t.tmplname", NULL,
                                 "pg_catalog.pg_ts_template_is_visible(t.oid)",
                                 NULL, 3))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of text search templates");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), _psqlSettings::logfile, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ listUserMappings()

bool listUserMappings	(	const char *	pattern,
		bool	verbose
	)

Definition at line 5927 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
  
     initPQExpBuffer(&buf);
     printfPQExpBuffer(&buf,
                       "SELECT um.srvname AS \"%s\",\n"
                       "  um.usename AS \"%s\"",
                       gettext_noop("Server"),
                       gettext_noop("User name"));
  
     if (verbose)
         appendPQExpBuffer(&buf,
                           ",\n CASE WHEN umoptions 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(umoptions)),  ', ') || ')' "
                           "  END AS \"%s\"",
                           gettext_noop("FDW options"));
  
     appendPQExpBufferStr(&buf, "\nFROM pg_catalog.pg_user_mappings um\n");
  
     if (!validateSQLNamePattern(&buf, pattern, false, false,
                                 NULL, "um.srvname", "um.usename", NULL,
                                 NULL, 1))
     {
         termPQExpBuffer(&buf);
         return false;
     }
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("List of user mappings");
     myopt.translate_header = true;
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), _psqlSettings::logfile, _psqlSettings::popt, PQclear(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_header, validateSQLNamePattern(), and verbose.

Referenced by exec_command_d().

◆ objectDescription()

bool objectDescription	(	const char *	pattern,
		bool	showSystem
	)

Definition at line 1252 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     static const bool translate_columns[] = {false, false, true, false};
  
     initPQExpBuffer(&buf);
  
     appendPQExpBuffer(&buf,
                       "SELECT DISTINCT tt.nspname AS \"%s\", tt.name AS \"%s\", tt.object AS \"%s\", d.description AS \"%s\"\n"
                       "FROM (\n",
                       gettext_noop("Schema"),
                       gettext_noop("Name"),
                       gettext_noop("Object"),
                       gettext_noop("Description"));
  
     /* Table constraint descriptions */
     appendPQExpBuffer(&buf,
                       "  SELECT pgc.oid as oid, pgc.tableoid AS tableoid,\n"
                       "  n.nspname as nspname,\n"
                       "  CAST(pgc.conname AS pg_catalog.text) as name,"
                       "  CAST('%s' AS pg_catalog.text) as object\n"
                       "  FROM pg_catalog.pg_constraint pgc\n"
                       "    JOIN pg_catalog.pg_class c "
                       "ON c.oid = pgc.conrelid\n"
                       "    LEFT JOIN pg_catalog.pg_namespace n "
                       "    ON n.oid = c.relnamespace\n",
                       gettext_noop("table constraint"));
  
     if (!showSystem && !pattern)
         appendPQExpBufferStr(&buf, "WHERE n.nspname <> 'pg_catalog'\n"
                              "      AND n.nspname <> 'information_schema'\n");
  
     if (!validateSQLNamePattern(&buf, pattern, !showSystem && !pattern,
                                 false, "n.nspname", "pgc.conname", NULL,
                                 "pg_catalog.pg_table_is_visible(c.oid)",
                                 NULL, 3))
         goto error_return;
  
     /* Domain constraint descriptions */
     appendPQExpBuffer(&buf,
                       "UNION ALL\n"
                       "  SELECT pgc.oid as oid, pgc.tableoid AS tableoid,\n"
                       "  n.nspname as nspname,\n"
                       "  CAST(pgc.conname AS pg_catalog.text) as name,"
                       "  CAST('%s' AS pg_catalog.text) as object\n"
                       "  FROM pg_catalog.pg_constraint pgc\n"
                       "    JOIN pg_catalog.pg_type t "
                       "ON t.oid = pgc.contypid\n"
                       "    LEFT JOIN pg_catalog.pg_namespace n "
                       "    ON n.oid = t.typnamespace\n",
                       gettext_noop("domain constraint"));
  
     if (!showSystem && !pattern)
         appendPQExpBufferStr(&buf, "WHERE n.nspname <> 'pg_catalog'\n"
                              "      AND n.nspname <> 'information_schema'\n");
  
     if (!validateSQLNamePattern(&buf, pattern, !showSystem && !pattern,
                                 false, "n.nspname", "pgc.conname", NULL,
                                 "pg_catalog.pg_type_is_visible(t.oid)",
                                 NULL, 3))
         goto error_return;
  
     /* Operator class descriptions */
     appendPQExpBuffer(&buf,
                       "UNION ALL\n"
                       "  SELECT o.oid as oid, o.tableoid as tableoid,\n"
                       "  n.nspname as nspname,\n"
                       "  CAST(o.opcname AS pg_catalog.text) as name,\n"
                       "  CAST('%s' AS pg_catalog.text) as object\n"
                       "  FROM pg_catalog.pg_opclass o\n"
                       "    JOIN pg_catalog.pg_am am ON "
                       "o.opcmethod = am.oid\n"
                       "    JOIN pg_catalog.pg_namespace n ON "
                       "n.oid = o.opcnamespace\n",
                       gettext_noop("operator class"));
  
     if (!showSystem && !pattern)
         appendPQExpBufferStr(&buf, "      AND n.nspname <> 'pg_catalog'\n"
                              "      AND n.nspname <> 'information_schema'\n");
  
     if (!validateSQLNamePattern(&buf, pattern, true, false,
                                 "n.nspname", "o.opcname", NULL,
                                 "pg_catalog.pg_opclass_is_visible(o.oid)",
                                 NULL, 3))
         goto error_return;
  
     /* Operator family descriptions */
     appendPQExpBuffer(&buf,
                       "UNION ALL\n"
                       "  SELECT opf.oid as oid, opf.tableoid as tableoid,\n"
                       "  n.nspname as nspname,\n"
                       "  CAST(opf.opfname AS pg_catalog.text) AS name,\n"
                       "  CAST('%s' AS pg_catalog.text) as object\n"
                       "  FROM pg_catalog.pg_opfamily opf\n"
                       "    JOIN pg_catalog.pg_am am "
                       "ON opf.opfmethod = am.oid\n"
                       "    JOIN pg_catalog.pg_namespace n "
                       "ON opf.opfnamespace = n.oid\n",
                       gettext_noop("operator family"));
  
     if (!showSystem && !pattern)
         appendPQExpBufferStr(&buf, "      AND n.nspname <> 'pg_catalog'\n"
                              "      AND n.nspname <> 'information_schema'\n");
  
     if (!validateSQLNamePattern(&buf, pattern, true, false,
                                 "n.nspname", "opf.opfname", NULL,
                                 "pg_catalog.pg_opfamily_is_visible(opf.oid)",
                                 NULL, 3))
         goto error_return;
  
     /* Rule descriptions (ignore rules for views) */
     appendPQExpBuffer(&buf,
                       "UNION ALL\n"
                       "  SELECT r.oid as oid, r.tableoid as tableoid,\n"
                       "  n.nspname as nspname,\n"
                       "  CAST(r.rulename AS pg_catalog.text) as name,"
                       "  CAST('%s' AS pg_catalog.text) as object\n"
                       "  FROM pg_catalog.pg_rewrite r\n"
                       "       JOIN pg_catalog.pg_class c ON c.oid = r.ev_class\n"
                       "       LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n"
                       "  WHERE r.rulename != '_RETURN'\n",
                       gettext_noop("rule"));
  
     if (!showSystem && !pattern)
         appendPQExpBufferStr(&buf, "      AND n.nspname <> 'pg_catalog'\n"
                              "      AND n.nspname <> 'information_schema'\n");
  
     if (!validateSQLNamePattern(&buf, pattern, true, false,
                                 "n.nspname", "r.rulename", NULL,
                                 "pg_catalog.pg_table_is_visible(c.oid)",
                                 NULL, 3))
         goto error_return;
  
     /* Trigger descriptions */
     appendPQExpBuffer(&buf,
                       "UNION ALL\n"
                       "  SELECT t.oid as oid, t.tableoid as tableoid,\n"
                       "  n.nspname as nspname,\n"
                       "  CAST(t.tgname AS pg_catalog.text) as name,"
                       "  CAST('%s' AS pg_catalog.text) as object\n"
                       "  FROM pg_catalog.pg_trigger t\n"
                       "       JOIN pg_catalog.pg_class c ON c.oid = t.tgrelid\n"
                       "       LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n",
                       gettext_noop("trigger"));
  
     if (!showSystem && !pattern)
         appendPQExpBufferStr(&buf, "WHERE n.nspname <> 'pg_catalog'\n"
                              "      AND n.nspname <> 'information_schema'\n");
  
     if (!validateSQLNamePattern(&buf, pattern, !showSystem && !pattern, false,
                                 "n.nspname", "t.tgname", NULL,
                                 "pg_catalog.pg_table_is_visible(c.oid)",
                                 NULL, 3))
         goto error_return;
  
     appendPQExpBufferStr(&buf,
                          ") AS tt\n"
                          "  JOIN pg_catalog.pg_description d ON (tt.oid = d.objoid AND tt.tableoid = d.classoid AND d.objsubid = 0)\n");
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2, 3;");
  
     res = PSQLexec(buf.data);
     termPQExpBuffer(&buf);
     if (!res)
         return false;
  
     myopt.title = _("Object descriptions");
     myopt.translate_header = true;
     myopt.translate_columns = translate_columns;
     myopt.n_translate_columns = lengthof(translate_columns);
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     PQclear(res);
     return true;
  
 error_return:
     termPQExpBuffer(&buf);
     return false;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, gettext_noop, initPQExpBuffer(), lengthof, _psqlSettings::logfile, printQueryOpt::n_translate_columns, _psqlSettings::popt, PQclear(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_columns, printQueryOpt::translate_header, and validateSQLNamePattern().

Referenced by exec_command_d().

◆ permissionsList()

bool permissionsList	(	const char *	pattern,
		bool	showSystem
	)

Definition at line 1011 of file describe.c.

 {
     PQExpBufferData buf;
     PGresult   *res;
     printQueryOpt myopt = pset.popt;
     static const bool translate_columns[] = {false, false, true, false, false, false};
  
     initPQExpBuffer(&buf);
  
     /*
      * we ignore indexes and toast tables since they have no meaningful rights
      */
     printfPQExpBuffer(&buf,
                       "SELECT n.nspname as \"%s\",\n"
                       "  c.relname as \"%s\",\n"
                       "  CASE c.relkind"
                       " WHEN " CppAsString2(RELKIND_RELATION) " THEN '%s'"
                       " WHEN " CppAsString2(RELKIND_VIEW) " THEN '%s'"
                       " WHEN " CppAsString2(RELKIND_MATVIEW) " THEN '%s'"
                       " WHEN " CppAsString2(RELKIND_SEQUENCE) " THEN '%s'"
                       " WHEN " CppAsString2(RELKIND_FOREIGN_TABLE) " THEN '%s'"
                       " WHEN " CppAsString2(RELKIND_PARTITIONED_TABLE) " THEN '%s'"
                       " END as \"%s\",\n"
                       "  ",
                       gettext_noop("Schema"),
                       gettext_noop("Name"),
                       gettext_noop("table"),
                       gettext_noop("view"),
                       gettext_noop("materialized view"),
                       gettext_noop("sequence"),
                       gettext_noop("foreign table"),
                       gettext_noop("partitioned table"),
                       gettext_noop("Type"));
  
     printACLColumn(&buf, "c.relacl");
  
     /*
      * The formatting of attacl should match printACLColumn().  However, we
      * need no special case for an empty attacl, because the backend always
      * optimizes that back to NULL.
      */
     appendPQExpBuffer(&buf,
                       ",\n  pg_catalog.array_to_string(ARRAY(\n"
                       "    SELECT attname || E':\\n  ' || pg_catalog.array_to_string(attacl, E'\\n  ')\n"
                       "    FROM pg_catalog.pg_attribute a\n"
                       "    WHERE attrelid = c.oid AND NOT attisdropped AND attacl IS NOT NULL\n"
                       "  ), E'\\n') AS \"%s\"",
                       gettext_noop("Column privileges"));
  
     if (pset.sversion >= 90500 && pset.sversion < 100000)
         appendPQExpBuffer(&buf,
                           ",\n  pg_catalog.array_to_string(ARRAY(\n"
                           "    SELECT polname\n"
                           "    || CASE WHEN polcmd != '*' THEN\n"
                           "           E' (' || polcmd::pg_catalog.text || E'):'\n"
                           "       ELSE E':'\n"
                           "       END\n"
                           "    || CASE WHEN polqual IS NOT NULL THEN\n"
                           "           E'\\n  (u): ' || pg_catalog.pg_get_expr(polqual, polrelid)\n"
                           "       ELSE E''\n"
                           "       END\n"
                           "    || CASE WHEN polwithcheck IS NOT NULL THEN\n"
                           "           E'\\n  (c): ' || pg_catalog.pg_get_expr(polwithcheck, polrelid)\n"
                           "       ELSE E''\n"
                           "       END"
                           "    || CASE WHEN polroles <> '{0}' THEN\n"
                           "           E'\\n  to: ' || pg_catalog.array_to_string(\n"
                           "               ARRAY(\n"
                           "                   SELECT rolname\n"
                           "                   FROM pg_catalog.pg_roles\n"
                           "                   WHERE oid = ANY (polroles)\n"
                           "                   ORDER BY 1\n"
                           "               ), E', ')\n"
                           "       ELSE E''\n"
                           "       END\n"
                           "    FROM pg_catalog.pg_policy pol\n"
                           "    WHERE polrelid = c.oid), E'\\n')\n"
                           "    AS \"%s\"",
                           gettext_noop("Policies"));
  
     if (pset.sversion >= 100000)
         appendPQExpBuffer(&buf,
                           ",\n  pg_catalog.array_to_string(ARRAY(\n"
                           "    SELECT polname\n"
                           "    || CASE WHEN NOT polpermissive THEN\n"
                           "       E' (RESTRICTIVE)'\n"
                           "       ELSE '' END\n"
                           "    || CASE WHEN polcmd != '*' THEN\n"
                           "           E' (' || polcmd::pg_catalog.text || E'):'\n"
                           "       ELSE E':'\n"
                           "       END\n"
                           "    || CASE WHEN polqual IS NOT NULL THEN\n"
                           "           E'\\n  (u): ' || pg_catalog.pg_get_expr(polqual, polrelid)\n"
                           "       ELSE E''\n"
                           "       END\n"
                           "    || CASE WHEN polwithcheck IS NOT NULL THEN\n"
                           "           E'\\n  (c): ' || pg_catalog.pg_get_expr(polwithcheck, polrelid)\n"
                           "       ELSE E''\n"
                           "       END"
                           "    || CASE WHEN polroles <> '{0}' THEN\n"
                           "           E'\\n  to: ' || pg_catalog.array_to_string(\n"
                           "               ARRAY(\n"
                           "                   SELECT rolname\n"
                           "                   FROM pg_catalog.pg_roles\n"
                           "                   WHERE oid = ANY (polroles)\n"
                           "                   ORDER BY 1\n"
                           "               ), E', ')\n"
                           "       ELSE E''\n"
                           "       END\n"
                           "    FROM pg_catalog.pg_policy pol\n"
                           "    WHERE polrelid = c.oid), E'\\n')\n"
                           "    AS \"%s\"",
                           gettext_noop("Policies"));
  
     appendPQExpBufferStr(&buf, "\nFROM pg_catalog.pg_class c\n"
                          "     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n"
                          "WHERE c.relkind IN ("
                          CppAsString2(RELKIND_RELATION) ","
                          CppAsString2(RELKIND_VIEW) ","
                          CppAsString2(RELKIND_MATVIEW) ","
                          CppAsString2(RELKIND_SEQUENCE) ","
                          CppAsString2(RELKIND_FOREIGN_TABLE) ","
                          CppAsString2(RELKIND_PARTITIONED_TABLE) ")\n");
  
     if (!showSystem && !pattern)
         appendPQExpBufferStr(&buf, "      AND n.nspname <> 'pg_catalog'\n"
                              "      AND n.nspname <> 'information_schema'\n");
  
     if (!validateSQLNamePattern(&buf, pattern, true, false,
                                 "n.nspname", "c.relname", NULL,
                                 "pg_catalog.pg_table_is_visible(c.oid)",
                                 NULL, 3))
         goto error_return;
  
     appendPQExpBufferStr(&buf, "ORDER BY 1, 2;");
  
     res = PSQLexec(buf.data);
     if (!res)
         goto error_return;
  
     printfPQExpBuffer(&buf, _("Access privileges"));
     myopt.title = buf.data;
     myopt.translate_header = true;
     myopt.translate_columns = translate_columns;
     myopt.n_translate_columns = lengthof(translate_columns);
  
     printQuery(res, &myopt, pset.queryFout, false, pset.logfile);
  
     termPQExpBuffer(&buf);
     PQclear(res);
     return true;
  
 error_return:
     termPQExpBuffer(&buf);
     return false;
 }

References _, appendPQExpBuffer(), appendPQExpBufferStr(), buf, CppAsString2, gettext_noop, initPQExpBuffer(), lengthof, _psqlSettings::logfile, printQueryOpt::n_translate_columns, _psqlSettings::popt, PQclear(), printACLColumn(), printfPQExpBuffer(), printQuery(), pset, PSQLexec(), _psqlSettings::queryFout, res, _psqlSettings::sversion, termPQExpBuffer(), printQueryOpt::title, printQueryOpt::translate_columns, printQueryOpt::translate_header, and validateSQLNamePattern().

Referenced by exec_command_d(), and exec_command_z().