create database - Docs search results , p.12
Documentation >> PostgreSQL 13
42.1. Overview
database system. The design goals of PL/pgSQL were to create a loadable procedural language that
Documentation >> PostgreSQL 13
CREATE ACCESS METHOD
creates a new access method. The access method name must be unique within the database
Documentation >> PostgreSQL 13
5.13. Other Database Objects
database. Many other kinds of objects can be created to make the use and management
Documentation >> PostgreSQL 13
5.11. Table Partitioning
CREATE FOREIGN TABLE for more information. 5.11.2.1. Example Suppose we are constructing a database for a large
Documentation >> PostgreSQL 13
ALTER TABLE
CREATE TABLE PARTITION OF will use that tablespace, unless overridden by a TABLESPACE clause. All tables in the current database
Documentation >> PostgreSQL 13
6.1. Inserting Data
created, it contains no data. The first thing to do before a database can be of much
Documentation >> PostgreSQL 13
Appendix L. Acronyms
Database Management System DDL Data Definition Language , SQL commands such as CREATE TABLE , ALTER USER
Documentation >> PostgreSQL 13
Part II. The SQL Language
create the structures to hold data, how to populate the database, and how to query
Documentation >> PostgreSQL 13
37.9. Internal Functions
database cluster (see Section 18.2 ), but a user could use CREATE FUNCTION to create additional
Documentation >> PostgreSQL 13
11.2. Index Types
database does not use the C locale you will need to create the index with
Documentation >> PostgreSQL 13
45.7. Database Access
created by plpy.cursor with DB-API cursors as defined by the Python Database API specification
Documentation >> PostgreSQL 13
40.4. Rules on INSERT, UPDATE, and DELETE
database. To make it a little harder for PostgreSQL , we don't delete it directly. Instead we create
Documentation >> PostgreSQL 13
CREATE FUNCTION
CREATE TRANSFORM . Procedural language implementations usually have hardcoded knowledge of the built-in types, so those don't need to be listed here. If a procedural language implementation does not know how to handle
Documentation >> PostgreSQL 13
11.3. Multicolumn Indexes
CREATE TABLE test2 ( major int, minor int, name varchar ); (say, you keep your /dev directory in a database
Documentation >> PostgreSQL 13
E.4. Release 13.12
DATABASE . Ensure that partitioned indexes are correctly marked as valid or not at creation (Michael