create database - Docs search results , p.14
Documentation >> PostgreSQL 16
75.2. System Catalog Initial Data
created while running the information_schema.sql script, will not be pinned, while all objects known to genbki.pl will be. OIDs assigned during normal database
Documentation >> PostgreSQL 16
F.16. file_fdw — access data files in the server's file system
CREATE FOREIGN TABLE pglog ( log_time timestamp(3) with time zone, user_name text, database
Documentation >> PostgreSQL 16
CREATE POLICY
create or change policies for it. While policies will be applied for explicit queries against tables in the database
Documentation >> PostgreSQL 16
11.10. Operator Classes and Operator Families
database does not use the standard “ C ” locale. As an example, you might index a varchar column like this: CREATE
Documentation >> PostgreSQL 16
REASSIGN OWNED
database objects owned by one or more roles. The REASSIGN OWNED command does not affect any privileges granted to the old_roles on objects that are not owned by them. Likewise, it does not affect
Documentation >> PostgreSQL 16
21.5. Password Authentication
database user is stored in the pg_authid system catalog. Passwords can be managed with the SQL commands CREATE
Documentation >> PostgreSQL 16
dblink_connect
database session is ended. The connection string may also be the name of an existing foreign server. It is recommended to use the foreign-data wrapper dblink_fdw when defining the foreign server
Documentation >> PostgreSQL 16
43.3. Declarations
creates two different ways to name the same object, unrestricted use can be confusing. It's best to use it only for the purpose of overriding predetermined names. 43.3.3. Copying Types # variable %TYPE %TYPE provides
Documentation >> PostgreSQL 16
53.11. pg_class
database's default tablespace is implied. Not meaningful if the relation has no on-disk file, except for partitioned tables, where this is the tablespace in which partitions will be created
Documentation >> PostgreSQL 16
12.1. Introduction
databases for years. PostgreSQL has ~ , ~* , LIKE , and ILIKE operators for textual data types, but they lack many essential properties required by modern information systems: There is no linguistic support, even for English. Regular expressions
Documentation >> PostgreSQL 16
LOAD
database administrator's responsibility to ensure that only “ safe ” libraries are installed there.) Compatibility LOAD is a PostgreSQL extension. See Also CREATE
Documentation >> PostgreSQL 16
53.44. pg_replication_origin
created. For more on replication origins see Chapter 50 . Unlike most system catalogs, pg_replication_origin is shared across all databases
Documentation >> PostgreSQL 16
43.12. Tips for Developing in PL/pgSQL
CREATE OR REPLACE FUNCTION testfunc(integer) RETURNS integer AS $$ .... $$ LANGUAGE plpgsql; While running psql , you can load or reload such a function definition file with: \i filename.sql and then immediately issue SQL commands
Documentation >> PostgreSQL 16
45.1. PL/Perl Functions and Arguments
CREATE FUNCTION perl_max (integer, integer) RETURNS integer AS $$ if ($_[0] > $_[1]) { return $_[0]; } return $_[1]; $$ LANGUAGE plperl; Note Arguments will be converted from the database
Documentation >> PostgreSQL 16
5.5. System Columns
creates a new row version for the same logical row.) cmin # The command identifier (starting at zero) within the inserting transaction. xmax # The identity (transaction ID) of the deleting transaction, or zero for an undeleted