auto_explain
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The auto_explain module provides a means for logging execution plans of slow statements automatically, without having to run

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

The catalog pg_largeobject holds the data making up "large objects". A large object is identified by an OID assigned

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

NameCREATE COLLATION -- define a new collation Synopsis

2025-01-10 15:47:30
CREATE TABLE AS
  • References/Database/PostgreSQL/Commands

NameCREATE TABLE AS -- define a new table from the results of a query Synopsis

2025-01-10 15:47:30
System Columns
  • References/Database/PostgreSQL/Data Definition

Every table has several system columns that are implicitly defined by the system. Therefore, these names cannot be used as names of user-defined columns

2025-01-10 15:47:30
createlang
  • References/Database/PostgreSQL/Applications

Namecreatelang -- install a PostgreSQL procedural language

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

As with any server daemon that is accessible to the outside world, it is advisable to run PostgreSQL under a separate user account. This user

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

NameEND -- commit the current transaction Synopsis

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
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