Search PostgreSQL documentation

ParametersManual ChaptersPG18Parameters IF NOT EXISTS Do not throw an error if a collation with the same name already exists. A notice is issued in this case. Note that there is no guarantee that the existing collation …Parameters ParametersManual ChaptersPG18Parameters DEFAULT The DEFAULT clause indicates that this conversion is the default for this particular source to destination encoding. There should be only one default encoding in a schema …Parameters ParametersManual ChaptersPG18Parameters name The name of a database to create. user_name The role name of the user who will own the new database, or DEFAULT to use the default (namely, the user executing the command). T…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of a domain to be created. data_type The underlying data type of the domain. This can include array specifiers. collation An optional c…Parameters ParametersManual ChaptersPG18Parameters name The name to give the new trigger. This name must be unique within the database. event The name of the event that triggers a call to the given function. See Section 38.1 for m…Parameters ParametersManual ChaptersPG18Parameters IF NOT EXISTS Do not throw an error if an extension with the same name already exists. A notice is issued in this case. Note that there is no guarantee that the existing extension…Parameters ParametersManual ChaptersPG18Parameters name The name of the foreign-data wrapper to be created. HANDLER handler_function handler_function is the name of a previously registered function that will be called to retrieve …Parameters ParametersManual ChaptersPG18Parameters IF NOT EXISTS Do not throw an error if a relation with the same name already exists. A notice is issued in this case. Note that there is no guarantee that the existing relation is…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of the function to create. argmode The mode of an argument: IN, OUT, INOUT, or VARIADIC. If omitted, the default is IN. Only OUT argume…Parameters ParametersManual ChaptersPG18Parameters UNIQUE Causes the system to check for duplicate values in the table when the index is created (if data already exist) and each time data is added. Attempts to insert or update dat…Parameters ParametersManual ChaptersPG18Parameters TRUSTED TRUSTED specifies that the language does not grant access to data that the user would not otherwise have. If this key word is omitted when registering the language, only u…Parameters ParametersManual ChaptersPG18Parameters IF NOT EXISTS Do not throw an error if a materialized view with the same name already exists. A notice is issued in this case. Note that there is no guarantee that the existing ma…Parameters ParametersManual ChaptersPG18Parameters name The name of the operator class to be created. The name can be schema-qualified. DEFAULT If present, the operator class will become the default operator class for its data typ…Parameters ParametersManual ChaptersPG18Parameters name The name of the operator to be defined. See above for allowable characters. The name can be schema-qualified, for example CREATE OPERATOR myschema.+ (...). If not, then the o…Parameters ParametersManual ChaptersPG18Parameters name The name of the operator family to be created. The name can be schema-qualified. index_method The name of the index method this operator family is for.Parameters ParametersManual ChaptersPG18Parameters name The name of the policy to be created. This must be distinct from the name of any other policy for the table. table_name The name (optionally schema-qualified) of the table th…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of the procedure to create. argmode The mode of an argument: IN, OUT, INOUT, or VARIADIC. If omitted, the default is IN. argname The na…Parameters ParametersManual ChaptersPG18Parameters name The name of the new publication. FOR TABLE Specifies a list of tables to add to the publication. If ONLY is specified before the table name, only that table is added to the p…Parameters ParametersManual ChaptersPG18Parameters name The name of the new role. SUPERUSERNOSUPERUSER These clauses determine whether the new role is a “superuser”, who can override all access restrictions within the database. Su…Parameters ParametersManual ChaptersPG18Parameters name The name of a rule to create. This must be distinct from the name of any other rule for the same table. Multiple rules on the same table and same event type are applied in al…Parameters ParametersManual ChaptersPG18Parameters schema_name The name of a schema to be created. If this is omitted, the user_name is used as the schema name. The name cannot begin with pg_, as such names are reserved for system…Parameters ParametersManual ChaptersPG18Parameters TEMPORARY or TEMP If specified, the sequence object is created only for this session, and is automatically dropped on session exit. Existing permanent sequences with the same name…Parameters ParametersManual ChaptersPG18Parameters IF NOT EXISTS Do not throw an error if a server with the same name already exists. A notice is issued in this case. Note that there is no guarantee that the existing server is any…Parameters ParametersManual ChaptersPG18Parameters IF NOT EXISTS Do not throw an error if a statistics object with the same name already exists. A notice is issued in this case. Note that only the name of the statistics object is …Parameters ParametersManual ChaptersPG18Parameters subscription_name The name of the new subscription. CONNECTION 'conninfo' The libpq connection string defining how to connect to the publisher database. For details see Section 32…Parameters ParametersManual ChaptersPG18Parameters TEMPORARY or TEMP If specified, the table is created as a temporary table. Temporary tables are automatically dropped at the end of a session, or optionally at the end of the curr…Parameters ParametersManual ChaptersPG18Parameters GLOBAL or LOCAL Ignored for compatibility. Use of these keywords is deprecated; refer to CREATE TABLE for details. TEMPORARY or TEMP If specified, the table is created as a tempor…Parameters ParametersManual ChaptersPG18Parameters tablespace_name The name of a tablespace to be created. The name cannot begin with pg_, as such names are reserved for system tablespaces. user_name The name of the user who will …Parameters ParametersManual ChaptersPG18Parameters type_name The name of the data type of the transform. lang_name The name of the language of the transform. from_sql_function_name[(argument_type [, ...])] The name of the function…Parameters ParametersManual ChaptersPG18Parameters name The name to give the new trigger. This must be distinct from the name of any other trigger for the same table. The name cannot be schema-qualified — the trigger inherits the …Parameters ParametersManual ChaptersPG18Parameters name The name of the text search configuration to be created. The name can be schema-qualified. parser_name The name of the text search parser to use for this configuration. sourc…Parameters ParametersManual ChaptersPG18Parameters name The name of the text search dictionary to be created. The name can be schema-qualified. template The name of the text search template that will define the basic behavior of t…Parameters ParametersManual ChaptersPG18Parameters name The name of the text search parser to be created. The name can be schema-qualified. start_function The name of the start function for the parser. gettoken_function The name o…Parameters ParametersManual ChaptersPG18Parameters name The name of the text search template to be created. The name can be schema-qualified. init_function The name of the init function for the template. lexize_function The name o…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of a type to be created. attribute_name The name of an attribute (column) for the composite type. data_type The name of an existing dat…Parameters ParametersManual ChaptersPG18Parameters IF NOT EXISTS Do not throw an error if a mapping of the given user to the given foreign server already exists. A notice is issued in this case. Note that there is no guarantee tha…Parameters ParametersManual ChaptersPG18Parameters TEMPORARY or TEMP If specified, the view is created as a temporary view. Temporary views are automatically dropped at the end of the current session. Existing permanent relations …Parameters ParametersManual ChaptersPG18Parameters PREPARE This key word is ignored. name The name of the prepared statement to deallocate. ALL Deallocate all prepared statements.Parameters ParametersManual ChaptersPG18Parameters name The name of the cursor to be created. This must be different from any other active cursor name in the session. BINARY Causes the cursor to return data in binary rather than i…Parameters ParametersManual ChaptersPG18Parameters with_query The WITH clause allows you to specify one or more subqueries that can be referenced by name in the DELETE query. See Section 7.8 and SELECT for details. table_name The …Parameters