create database - Docs search results , p.16
Documentation >> PostgreSQL 16
20.4. Resource Consumption
database session. These are session-local buffers used only for access to temporary tables. If this value is specified without units, it is taken as blocks, that is BLCKSZ bytes, typically 8kB. The default
Documentation >> PostgreSQL 16
35.1. Introduction
created, modified, and deleted using a read/write API that is similar to standard operations on files. PostgreSQL also supports a storage system called “ TOAST ” , which automatically stores values larger than a single database
Documentation >> PostgreSQL 16
38.7. Function Volatility Categories
CREATE FUNCTION command does not specify a category. The volatility category is a promise to the optimizer about the behavior of the function: A VOLATILE function can do anything, including modifying the database
Documentation >> PostgreSQL 16
DROP EXTENSION
database, for example if any tables have columns of the hstore type. Add the CASCADE option to forcibly remove those dependent objects as well. Compatibility DROP EXTENSION is a PostgreSQL extension. See Also CREATE
Documentation >> PostgreSQL 16
53.56. pg_tablespace
database. Table 53.56. pg_tablespace Columns Column Type Description oid oid Row identifier spcname name Tablespace name spcowner oid (references pg_authid . oid ) Owner of the tablespace, usually the user who created
Documentation >> PostgreSQL 16
14.1. Using EXPLAIN
creates for any query. Plan-reading is an art that requires some experience to master, but this section attempts to cover the basics. Examples in this section are drawn from the regression test database
Documentation >> PostgreSQL 16
34.1. Database Connection Control Functions
database connection. (Caution: do not assume that the socket remains the same across PQconnectPoll calls.) Loop thus: If PQconnectPoll(conn) last returned PGRES_POLLING_READING , wait until the socket is ready to read (as indicated
Documentation >> PostgreSQL 16
37.29. foreign_servers
database) foreign_data_wrapper_name sql_identifier Name of the foreign-data wrapper used by the foreign server foreign_server_type character_data Foreign server type information, if specified upon creation
Documentation >> PostgreSQL 16
9.16. JSON Functions and Operators
creating JSON data the SQL/JSON path language To provide native support for JSON data types within the SQL environment, PostgreSQL implements the SQL/JSON data model . This model comprises sequences of items. Each item can hold
Documentation >> PostgreSQL 16
3.2. Views
CREATE VIEW myview AS SELECT name, temp_lo, temp_hi, prcp, date, location FROM weather, cities WHERE city = name; SELECT * FROM myview; Making liberal use of views is a key aspect of good SQL database
Documentation >> PostgreSQL 16
15.2. When Can Parallel Query Be Used?
database rows. If a query contains a data-modifying operation either at the top level or within a CTE, no parallel plans for that query will be generated. As an exception, the following commands, which
Documentation >> PostgreSQL 16
ALTER TEXT SEARCH DICTIONARY
database sessions to re-read the configuration files, which otherwise they would never do if they had read them earlier. Compatibility There is no ALTER TEXT SEARCH DICTIONARY statement in the SQL standard. See Also
Documentation >> PostgreSQL 16
Chapter 75. System Catalog Declarations and Initial Contents
Creation of Array Types 75.2.5. Recipes for Editing Data Files 75.3. BKI File Format 75.4. BKI Commands 75.5. Structure of the Bootstrap BKI File 75.6. BKI Example PostgreSQL uses many different system catalogs to keep
Documentation >> PostgreSQL 16
Chapter 58. Writing a Procedural Language Handler
CREATE FUNCTION . Typical checks then include verifying that the function's argument and result types are supported by the language, and that the function's body is syntactically correct in the language. If the validator
Documentation >> PostgreSQL 16
53.28. pg_init_privs
database which has a non-default (non-NULL) initial set of privileges. Objects can have initial privileges either by having those privileges set when the system is initialized (by initdb ) or when the object