create database - Docs search results , p.16
Documentation >> Postgres Pro Standard 9.6
51.2. Foreign Data Wrapper Callback Routines
database object options. The FDW may ignore the local_schema field of the ImportForeignSchemaStmt , because the core server will automatically insert that name into the parsed CREATE
Documentation >> Postgres Pro Standard 9.6
12.7. Configuration Example
database management system, is now undergoing beta testing of the next version of our software. '); The next step is to set the session to use the new configuration, which was created
Documentation >> Postgres Pro Standard 9.6
11.5. Combining Multiple Indexes
database developer must make trade-offs to decide which indexes to provide. Sometimes multicolumn indexes are best, but sometimes it's better to create
Documentation >> Postgres Pro Standard 9.6
Chapter 7. Queries
create tables, how to fill them with data, and how to manipulate that data. Now we finally discuss how to retrieve the data from the database
Documentation >> Postgres Pro Standard 9.6
48.11. pg_class
database's default tablespace is implied. (Not meaningful if the relation has no on-disk file.) relpages int4 Size of the on-disk representation of this table in pages (of size BLCKSZ ). This is only
Documentation >> Postgres Pro Standard 9.6
F.51. sr_plan
CREATE EXTENSION sr_plan; and modify your postgresql.conf: shared_preload_libraries = 'sr_plan' It is essential that library is preloaded during server startup, because use of saved plans is enabled on per-database
Documentation >> Postgres Pro Standard 9.6
42.8. Explicit Subtransactions
database access as described in Section 42.7.2 can lead to an undesirable situation where some operations succeed before one of them fails, and after recovering from that error the data is left in an inconsistent
Documentation >> Postgres Pro Standard 9.6
32.4. Using Host Variables
database back to the program, the C variables that are intended to contain this data need to be declared in specially marked sections, so the embedded SQL preprocessor is made aware of them. This section
Documentation >> Postgres Pro Standard 9.6
15.4. Parallel Safety
CREATE AGGREGATE , the PARALLEL option can be specified with SAFE , RESTRICTED , or UNSAFE as the corresponding value. Functions and aggregates must be marked PARALLEL UNSAFE if they write to the database
Documentation >> Postgres Pro Standard 9.6
E.57. Release 9.6
created by initdb . Change a column name in the information_schema . routines view from result_cast_character_set_name to result_cast_char_set_name (Clément Prévost) The SQL:2011 standard specifies the longer name
Documentation >> Postgres Pro Standard 9.6
Chapter 2. The SQL Language
Creating a New Table 2.4. Populating a Table With Rows 2.5. Querying a Table 2.6. Joins Between Tables 2.7. Aggregate Functions 2.8. Updates 2.9. Deletions Prev Home Next 1.4. Accessing a Database
Documentation >> Postgres Pro Standard 9.6
F.48. seg
database. What do you get when you fetch it? Watch: test=> select 6.50 :: float8 as "pH"; pH --- 6.5 (1 row) In the world of measurements, 6.50 is not the same
Documentation >> Postgres Pro Standard 9.6
CREATE RULE
create a new rule, or replace an existing rule of the same name for the same table. The Postgres Pro rule system allows one to define an alternative action to be performed on insertions, updates
Documentation >> Postgres Pro Standard 9.6
34.6. 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 >> Postgres Pro Standard 9.6
31.1. Introduction
created, modified, and deleted using a read/write API that is similar to standard operations on files. Postgres Pro also supports a storage system called “ TOAST ” , which automatically stores values larger than a single database