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
Indexes on Expressions
  • References/Database/PostgreSQL/Indexes

An index column need not be just a column of the underlying table, but can be a function or scalar expression computed from one or more columns of the table. This feature is

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
chkpass
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

This module implements a data type chkpass that is designed for storing encrypted passwords. Each password is automatically converted to encrypted

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