create database - Docs search results , p.15
Documentation >> Postgres Pro Standard 9.6
F.18. file_fdw
CREATE FOREIGN TABLE pglog ( log_time timestamp(3) with time zone, user_name text, database
Documentation >> Postgres Pro Standard 9.6
CREATE POLICY
create or change policies for it. While policies will be applied for explicit queries against tables in the database
Documentation >> Postgres Pro Standard 9.6
11.9. 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 >> Postgres Pro Standard 9.6
D.2. Unsupported Features
database, Enhanced integrity management Multiple triggers for the same event are executed in the order in which they were created
Documentation >> Postgres Pro Standard 9.6
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 >> Postgres Pro Standard 9.6
ALTER TABLE
DATABASE or explicit ALTER TABLE invocations instead if desired. The information_schema relations are not considered part of the system catalogs and will be moved. See also CREATE
Documentation >> Postgres Pro Standard 9.6
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 >> Postgres Pro Standard 9.6
39.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. 39.3.3. Copying Types variable %TYPE %TYPE provides
Documentation >> Postgres Pro Standard 9.6
12.1. Introduction
databases for years. Postgres Pro 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 >> Postgres Pro Standard 9.6
PREPARE TRANSACTION
databases or other transactional resources. Unless you're writing a transaction manager, you probably shouldn't be using PREPARE TRANSACTION . This command must be used inside a transaction block. Use BEGIN to start
Documentation >> Postgres Pro Standard 9.6
18.4. Resource Consumption
CREATE INDEX , and ALTER TABLE ADD FOREIGN KEY . It defaults to 64 megabytes ( 64MB ). Since only one of these operations can be executed at a time by a database
Documentation >> Postgres Pro Standard 9.6
39.11. 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 >> Postgres Pro Standard 9.6
41.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 >> Postgres Pro Standard 9.6
F.23. intagg
database systems have the notion of a one to many table. Such a table usually sits between two indexed tables, for example: CREATE
Documentation >> Postgres Pro Standard 9.6
5.5. Modifying Tables
create it again. But this is not a convenient option if the table is already filled with data, or if the table is referenced by other database