Authentication Problems
  • References/Database/PostgreSQL/Client Authentication

Authentication failures and related problems generally manifest themselves through error messages like the following:

2025-01-10 15:47:30
Catalogs: pg_description
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_description stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the

2025-01-10 15:47:30
XML Functions
  • References/Database/PostgreSQL/Functions/XML

The functions and function-like expressions described in this section operate on values of type xml. Check

2025-01-10 15:47:30
9.
  • References/Database/PostgreSQL/Tutorial/The SQL Language

Rows can be removed from a table using the DELETE command. Suppose you are no longer interested in the weather of Hayward. Then you can do the

2025-01-10 15:47:30
4.
  • References/Database/PostgreSQL/Tutorial/Getting Started

Once you have created a database, you can access it by: Running the PostgreSQL

2025-01-10 15:47:30
Catalogs: pg_seclabels
  • References/Database/PostgreSQL/Internals: Catalogs

The view pg_seclabels provides information about security labels. It as an easier-to-query version of the

2025-01-10 15:47:30
Function and Trigger Security
  • References/Database/PostgreSQL/Database Roles

Functions and triggers allow users to insert code into the backend server that other users might execute unintentionally. Hence, both mechanisms permit users to "Trojan

2025-01-10 15:47:30
UUID Type
  • References/Database/PostgreSQL/Data Types

The data type uuid stores Universally Unique Identifiers (UUID) as defined by RFC 4122, ISO/IEC 9834-8:2005, and related standards. (Some systems

2025-01-10 15:47:30
Catalogs: pg_foreign_table
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_foreign_table contains auxiliary information about foreign tables. A foreign table is primarily represented by a

2025-01-10 15:47:30
Enum Functions
  • References/Database/PostgreSQL/Functions and Operators

For enum types (described in Section 8.7), there are several functions that allow cleaner programming

2025-01-10 15:47:30