Server Configuration: Short Options
  • References/Database/PostgreSQL/Server Configuration

For convenience there are also single letter command-line option switches available for some parameters. They are described in Table 19-2. Some of these options exist for historical

2025-01-10 15:47:30
Default Roles
  • References/Database/PostgreSQL/Database Roles

PostgreSQL provides a set of default roles which provide access to certain, commonly needed, privileged capabilities and information. Administrators

2025-01-10 15:47:30
Table Expressions
  • References/Database/PostgreSQL/Queries

A table expression computes a table. The table expression contains a FROM clause that is optionally followed by

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

The catalog pg_amproc stores information about support procedures associated with access method operator families. There is one row for each

2025-01-10 15:47:30
NOTIFY
  • References/Database/PostgreSQL/Commands

NameNOTIFY -- generate a notification Synopsis

2025-01-10 15:47:30
Starting the Database Server
  • References/Database/PostgreSQL/Server Setup and Operation

Before anyone can access the database, you must start the database server. The database server program is called postgres. The

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

See Section 8.17 for an overview of range types. Table 9-49 shows

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

The view pg_rules provides access to useful information about query rewrite rules. Table

2025-01-10 15:47:30
Network Address Types
  • References/Database/PostgreSQL/Data Types

PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses, as shown in Table 8-21. It is better to use these types instead of plain

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

The view pg_group exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before

2025-01-10 15:47:30