create database - Docs search results , p.16
Documentation >> PostgreSQL 12
Chapter 70. System Catalog Declarations and Initial Contents
Creation of Array Types 70.2.5. Recipes for Editing Data Files 70.3. BKI File Format 70.4. BKI Commands 70.5. Structure of the Bootstrap BKI File 70.6. BKI Example PostgreSQL uses many different system catalogs to keep
Documentation >> PostgreSQL 12
Chapter 55. 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 12
51.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
Documentation >> PostgreSQL 12
3.3. Foreign Keys
database systems this would be implemented (if at all) by first looking at the cities table to check if a matching record exists, and then inserting or rejecting the new weather records. This approach
Documentation >> PostgreSQL 12
19.17. Developer Options
database. As such, they have been excluded from the sample postgresql.conf file. Note that many of these parameters require special source compilation flags to work at all. allow_in_place_tablespaces ( boolean ) Allows tablespaces
Documentation >> PostgreSQL 12
30.1. Publication
database. Publications are different from schemas and do not affect how the table is accessed. Each table can be added to multiple publications if needed. Publications may currently only contain tables. Objects must be added
Documentation >> PostgreSQL 12
29.4. WAL Configuration
database low level modification (for example, row insertion) at a time when an exclusive lock is held on affected data pages, so the operation needs to be as fast as possible. What is worse, writing
Documentation >> PostgreSQL 12
F.20. lo
database represent large objects that you are managing with the trigger. It is also rumored that the ODBC driver gets confused if you don't use lo for BLOB columns. F.20.2
Documentation >> PostgreSQL 12
4.2. Value Expressions
CREATE FUNCTION dept(text) RETURNS dept AS $$ SELECT * FROM dept WHERE name = $1 $$ LANGUAGE SQL; Here the $1 references the value of the first function argument whenever the function is invoked. 4.2.3. Subscripts
Documentation >> PostgreSQL 12
8.21. Pseudo-Types
database system, and not by direct invocation in an SQL query. If a function has at least one internal -type argument then it cannot be called from SQL . To preserve the type safety of this
Documentation >> PostgreSQL 12
Chapter 6. Data Manipulation
create tables and other structures to hold your data. Now it is time to fill the tables with data. This chapter covers how to insert, update, and delete table data. The chapter after this will
Documentation >> PostgreSQL 12
18.9. Secure TCP/IP Connections with SSL
Creating Certificates PostgreSQL has native support for using SSL connections to encrypt client/server communications for increased security. This requires that OpenSSL is installed on both client and server systems and that support in PostgreSQL
Documentation >> PostgreSQL 12
34.5. Example Program
database as large object "lobjOid" * */ static Oid importFile(PGconn *conn, char *filename) { Oid lobjId; int lobj_fd; char buf[BUFSIZE]; int nbytes, tmp; int fd; /* * open the file to be read in */ fd = open(filename
Documentation >> PostgreSQL 12
9.4. String Functions and Operators
CREATE CONVERSION . Also there are some predefined conversions. See Table 9.11 for available conversions. convert('text_in_utf8', 'UTF8', 'LATIN1') text_in_utf8 represented in Latin-1 encoding (ISO 8859-1) convert_from( string bytea
Documentation >> PostgreSQL 12
DROP SCHEMA
database, along with everything it contains: DROP SCHEMA mystuff CASCADE; Compatibility DROP SCHEMA is fully conforming with the SQL standard, except that the standard only allows one schema to be dropped per command, and apart