Search PostgreSQL documentation

createuser --no-bypassrlsCommand-line ToolsPG18--no-bypassrls The new user will not bypass row-level security (RLS) policies. This is the default.createuser › Options createuser --no-createdbCommand-line ToolsPG18-D--no-createdb The new user will not be allowed to create databases. This is the default.createuser › Options createuser --no-createroleCommand-line ToolsPG18-R--no-createrole The new user will not be allowed to create new roles. This is the default.createuser › Options createuser --no-inheritCommand-line ToolsPG18-I--no-inherit The new role will not automatically inherit privileges of roles it is a member of.createuser › Options createuser --no-loginCommand-line ToolsPG18-L--no-login The new user will not be allowed to log in. (A role without login privilege is still useful as a means of managing database permissions.)createuser › Options createuser --no-passwordCommand-line ToolsPG18-w--no-password Never issue a password prompt. If the server requires password authentication and a password is not available by other means such as a .pgpass file, the connection attempt wi…createuser › Options createuser --no-replicationCommand-line ToolsPG18--no-replication The new user will not have the REPLICATION privilege, which is described more fully in the documentation for CREATE ROLE. This is the default.createuser › Options createuser --no-superuserCommand-line ToolsPG18-S--no-superuser The new user will not be a superuser. This is the default.createuser › Options createuser --passwordCommand-line ToolsPG18-W--password Force createuser to prompt for a password (for connecting to the server, not for the password of the new user). This option is never essential, since createuser will automatical…createuser › Options createuser --port=portCommand-line ToolsPG18-p port--port=port Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections.createuser › Options createuser --pwpromptCommand-line ToolsPG18-P--pwprompt If given, createuser will issue a prompt for the password of the new user. This is not necessary if you do not plan on using password authentication.createuser › Options createuser --replicationCommand-line ToolsPG18--replication The new user will have the REPLICATION privilege, which is described more fully in the documentation for CREATE ROLE.createuser › Options createuser --role=roleCommand-line ToolsPG18-g role--member-of=role--role=role (deprecated) Specifies the new role should be automatically added as a member of the specified existing role. Multiple existing roles can be specified by w…createuser › Options createuser --superuserCommand-line ToolsPG18-s--superuser The new user will be a superuser.createuser › Options createuser --username=usernameCommand-line ToolsPG18-U username--username=username User name to connect as (not the user name to create).createuser › Options createuser --valid-until=timestampCommand-line ToolsPG18-v timestamp--valid-until=timestamp Set a date and time after which the role's password is no longer valid. The default is to set no password expiry date.createuser › Options createuser --versionCommand-line ToolsPG18-V--version Print the createuser version and exit.createuser › Options createuser --with-admin=roleCommand-line ToolsPG18-a role--with-admin=role Specifies an existing role that will be automatically added as a member of the new role with admin option, giving it the right to grant membership in the new role to…createuser › Options createuser --with-member=roleCommand-line ToolsPG18-m role--with-member=role Specifies an existing role that will be automatically added as a member of the new role. Multiple existing roles can be specified by writing multiple -m switches.createuser › Options Creating a DatabaseManual ChaptersPG1822.2. Creating a Database In order to create a database, the PostgreSQL server must be up and running (see Section 18.3). Databases are created with the SQL command CREATE DATABASE: CREATE D…Creating a Database Creating a DatabaseManual ChaptersPG181.3. Creating a Database The first test to see whether you can access the database server is to try to create a database. A running PostgreSQL server can manage many databases. Typically, a …Creating a Database Creating a Database ClusterManual ChaptersPG1818.2. Creating a Database Cluster Before you can do anything, you must initialize a database storage area on disk. We call this a database cluster. (The SQL standard uses the term catalog cl…Creating a Database Cluster Creating a Large ObjectManual ChaptersPG1833.3.1. Creating a Large Object The function Oid lo_create(PGconn *conn, Oid lobjId); creates a new large object. The OID to be assigned can be specified by lobjId; if so, failure occurs if …Creating a Large Object Creating a New TableManual ChaptersPG182.3. Creating a New Table You can create a new table by specifying the table name, along with all column names and their types: CREATE TABLE weather ( city varchar(80), temp_lo int, -- low t…Creating a New Table Creating a SchemaManual ChaptersPG185.10.1. Creating a Schema To create a schema, use the CREATE SCHEMA command. Give the schema a name of your choice. For example: CREATE SCHEMA myschema; To create or access objects in a sche…Creating a Schema Creating and Maintaining Message CatalogsManual ChaptersPG1856.1.3. Creating and Maintaining Message Catalogs OK, so how does one create a “blank” message catalog? First, go into the directory that contains the program whose messages you want to tran…Creating and Maintaining Message Catalogs Creating CertificatesManual ChaptersPG1818.9.5. Creating Certificates To create a simple self-signed certificate for the server, valid for 365 days, use the following OpenSSL command, replacing dbhost.yourdomain.com with the serve…Creating Certificates Creating Custom Scan PathsManual ChaptersPG1860.1. Creating Custom Scan Paths A custom scan provider will typically add paths for a base relation by setting the following hook, which is called after the core code has generated all the …Creating Custom Scan Paths Creating Custom Scan PlansManual ChaptersPG1860.2. Creating Custom Scan Plans A custom scan is represented in a finished plan tree using the following structure: typedef struct CustomScan { Scan scan; uint32 flags; List *custom_plans; …Creating Custom Scan Plans Creating Event TriggersManual ChaptersPG1838.1.7. Creating Event Triggers Event triggers are created using the command CREATE EVENT TRIGGER. In order to create an event trigger, you must first create a function with the special retu…Creating Event Triggers Creating IndexesManual ChaptersPG1812.2.2. Creating Indexes We can create a GIN index (Section 12.9) to speed up text searches: CREATE INDEX pgweb_idx ON pgweb USING GIN (to_tsvector('english', body)); Notice that the 2-argum…Creating Indexes Creating New Collation ObjectsManual ChaptersPG1823.2.2.3. Creating New Collation Objects If the standard and predefined collations are not sufficient, users can create their own collation objects using the SQL command CREATE COLLATION. Th…Creating New Collation Objects Creating XML ValuesManual ChaptersPG188.13.1. Creating XML Values To produce a value of type xml from character data, use the function xmlparse: XMLPARSE ( { DOCUMENT | CONTENT } value) Examples: XMLPARSE (DOCUMENT '<?xml versio…Creating XML Values credcheckExtensionsExtensionscredcheck - postgresql plain text credential checker credcheck SecuritySecurity · Extensions CreditsManual ChaptersPG18F.10.6. Credits Original author: Gene Selkov, Jr. <selkovjr@mcs.anl.gov>, Mathematics and Computer Science Division, Argonne National Laboratory. My thanks are primarily to Prof. Joe Hellers…Credits CreditsManual ChaptersPG18F.39.6. Credits Original author: Gene Selkov, Jr. <selkovjr@mcs.anl.gov>, Mathematics and Computer Science Division, Argonne National Laboratory. My thanks are primarily to Prof. Joe Hellers…Credits crockfordExtensionsExtensionsCrockford Base32 encoded unsigned integer data types base32 data-type unsigned-integer pgcrockford Data typesData types · Extensions cron_utilsExtensionsExtensionsParse cron expressions and compute previous or next trigger times cron schedule cron_utils Time seriesTime series · Extensions Cross-Version CompatibilityManual ChaptersPG18F.38.7. Cross-Version Compatibility postgres_fdw can be used with remote servers dating back to PostgreSQL 8.3. Read-only capability is available back to 8.1. A limitation however is that po…Cross-Version Compatibility crosstabFunctionsPG18crosstab ( sql text ) → setof record Produces a “pivot table” containing row names plus N value columns, where N is determined by the row type specified in the calling query.tablefunc — functions that return tables (crosstab and others) › Functions Provided