The pgdump utility is used to create backups of a PostgreSQL database. To back up a specific schema, including its structure and data, the -n or --schema option is used. Both options are equivalent; -n is the short form, and --schema is the long form for the same functionality. They instruct pgdump to dump only the schema(s) matching the provided pattern, along with all of their contained objects and data. Therefore, both pgdump -n edbuser and pgdump --schema edbuser will correctly back up only the edbuser schema.

A. -s edbuser: The -s option (or --schema-only) dumps only the object definitions (DDL) for the entire database, not the data. It does not select a specific schema by name.

1. PostgreSQL 16 Documentation, pgdump:

Section: Options, Dumping Options

Content: Describes the -n schema and --schema=schema options: "Dump only schemas matching schema; this selects both the schema itself, and all its contained objects." It also describes the -s or --schema-only option: "Dump only the object definitions (schema), not data." This confirms that -n and --schema are the correct options for the user's requirement and that -s is incorrect.

Reference: PostgreSQL Documentation. (2023). pgdump. Retrieved from https://www.postgresql.org/docs/current/app-pgdump.html

2. PostgreSQL 14 Documentation, pgdump:

Section: Reference, PostgreSQL Client Applications, pgdump

Content: The documentation for this earlier but still widely used version provides the same definitions for the options: -n, --schema=PATTERN to "dump only schemas matching PATTERN" and -s, --schema-only to "dump only the object definitions, not data." This demonstrates the long-standing consistency of these command-line options.

Reference: PostgreSQL Documentation. (2021). pgdump. Retrieved from https://www.postgresql.org/docs/14/app-pgdump.html

The psql interactive terminal uses meta-commands for administrative tasks. The command \list is used to display a list of all databases in the server cluster. \l is the officially documented shorter alias for \list. Both commands perform the identical function of querying the pgdatabase system catalog and presenting the results, which include the database name, owner, encoding, and access privileges. Therefore, both options A and B are correct.

A. This option is correct but incomplete because \l is also a valid and commonly used alias for the same command.

B. This option is correct but incomplete because \list is the full, unabbreviated form of the command.

C. \databases is not a recognized psql meta-command for listing databases.

1. PostgreSQL 16 Documentation. (2023). Chapter 35. psql, Section 35.5. Meta-Commands. The documentation table explicitly lists \l[+] [ pattern ] and \list[+] [ pattern ] together, indicating they are equivalent commands to "list databases". Available at: https://www.postgresql.org/docs/16/app-psql.html#PSQL-META-COMMANDS

2. Obe, R., & Hsu, L. (2021). PostgreSQL Up and Running: A Practical Guide to the Advanced Open Source Database (3rd ed.). O'Reilly Media. Chapter 2, "psql," details common meta-commands, noting that \l is the shortcut for \list.

3. University of California, Berkeley. (n.d.). CS 186: Introduction to Database Systems, Lab 1 - SQL. The course materials introduce students to PostgreSQL and psql, demonstrating the use of \l to list available databases as a fundamental administrative step.

The SHOW command is a PostgreSQL-specific SQL command used to display the current value of a run-time configuration parameter. To check the maximum number of concurrent connections allowed by the server, the command SHOW maxconnections; is used. This command directly queries the server's active configuration and returns the current setting for the specified parameter. It is the most direct and common method for this task within a psql session or any SQL interface connected to PostgreSQL.

A. SELECT maxconnections; is syntactically incorrect. The SELECT statement requires a FROM clause unless selecting constants or calling functions, and maxconnections is not a column in a default context.

C. GET maxconnections; is not a valid SQL command in PostgreSQL for retrieving configuration parameters. The GET command does not exist for this purpose.

D. DISPLAY maxconnections; is not a valid SQL command in PostgreSQL. While some other database systems might use similar syntax, it is not part of PostgreSQL's SQL dialect.

1. PostgreSQL 16 Documentation, SQL Commands, SHOW: "SHOW will display the current setting of run-time parameters. These variables can be set using the SET statement, by editing the postgresql.conf configuration file, through the PGOPTIONS environmental variable (when using libpq or a libpq-based application), or through flags on the command line when starting the postgres server."

Reference: PostgreSQL Documentation, SHOW command reference page.

2. PostgreSQL 16 Documentation, Chapter 20. Server Configuration, Section 20.1. Setting Parameters: "The SHOW command is used to view the current value of any of these parameters. For example, to see the current setting of the parameter DateStyle, use the command: SHOW DateStyle;"

Reference: PostgreSQL Documentation, Chapter 20, Section 20.1.

3. PostgreSQL 16 Documentation, System Views, pgsettings: "The view pgsettings provides access to run-time parameters of the server... SHOW parametername is a simpler alternative syntax for SELECT setting FROM pgsettings WHERE name = 'parametername';"

Reference: PostgreSQL Documentation, pgsettings view reference page.

The psql interactive terminal provides several meta-commands for database introspection. The command \dn is the specific meta-command used to list all schemas within the current database. The 'n' in \dn is a mnemonic for "namespaces," which is the internal term PostgreSQL uses for schemas. This command provides a quick and convenient way for users to view the schema structure without writing a full SQL query against the system catalogs.

A. \ds: This command is incorrect because \ds is used to list all sequences in the current database, not schemas.

C. \schemas: This is not a valid psql meta-command. While schemas is an SQL keyword, \schemas does not exist as a command in the psql client.

D. \ls: This is not a valid psql meta-command. It might be confused with the Unix/Linux ls command for listing files.

1. PostgreSQL 16 Documentation, psql, Informational Commands: The official documentation provides a table of psql meta-commands. It explicitly lists \dn[S+] [pattern] with the description "list schemas (namespaces)".

Source: PostgreSQL Documentation, Chapter: psql, Section: Meta-Commands. Available at: https://www.postgresql.org/docs/current/app-psql.html (Refer to the table under the "Informational Commands" heading).

2. University of California, Berkeley, EECS Department Courseware: Materials for database courses like CS 186 often include tutorials on using psql. These materials confirm that \dn is the standard command for listing schemas.

Source: UC Berkeley, CS 186: Introduction to Database Systems, Lab 0 - Getting Started with PostgreSQL. The guide lists common psql commands, including \dn for listing schemas.

3. PostgreSQL Tutorial from The PostgreSQL Global Development Group: This official tutorial site, maintained by the core development group, provides practical examples. The section on managing databases demonstrates the use of psql commands.

Source: PostgreSQL Tutorial, "PostgreSQL List Schemas". This resource explains how to use both the \dn meta-command and the informationschema.schemata view to list schemas. Available at: https://www.postgresqltutorial.com/postgresql-administration/postgresql-list-schemas/

The psql meta-command \d tablename is used to describe a relation (table, view, index, etc.). When used with a table name, it displays detailed information about the table's structure, including its columns with their data types, modifiers (like NOT NULL), default values, and any associated indexes, constraints (primary keys, foreign keys, check constraints), and triggers. This command provides a comprehensive overview of the table's definition directly within the psql interactive terminal.

A. \dt tablename: This command lists tables. If a tablename pattern is provided, it filters the list, but it does not describe the detailed structure of a specific table.

C. \describe tablename: \describe is not a valid psql meta-command. This might be confused with the DESCRIBE SQL command used in other database systems like MySQL.

D. \show tablename: The \show meta-command is used to display the current value of a PostgreSQL run-time parameter (e.g., \show serverversion), not to describe a database object.

1. PostgreSQL 16 Documentation: In the section on psql meta-commands, the \d command is explicitly defined for this purpose.

Source: PostgreSQL 16 Documentation, Chapter 2. psql, Section: "Meta-Commands", Subsection: "Informational".

Reference: The documentation states: \d[S+] [ pattern ] "For each relation (table, view, materialized view, index, sequence, or foreign table) ... show all columns, their types, the tablespace ... and any special attributes such as NOT NULL or defaults. Associated indexes, constraints, rules, and triggers are also shown."

2. University of California, Berkeley - Courseware: Course materials for database systems frequently cover psql basics, demonstrating the use of \d for schema inspection.

Source: UC Berkeley, EECS Department, CS 186: Introduction to Database Systems, Project 1: Buffer Manager.

Reference: In the "Getting Started with Postgres" section of the project setup guide, students are instructed to use \d tablename to "get information about a table’s schema."

3. PostgreSQL Tutorial Website (Official): The official tutorial provides practical examples of common commands.

Source: PostgreSQL Tutorial, "PostgreSQL psql Commands" section.

Reference: The tutorial lists \d tablename with the description: "Describe a table such as columns, types, and modifiers of columns." It contrasts this with \dt, which is described as "List all tables in the current database."