Search PostgreSQL documentation

ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the user mapping does not exist. A notice is issued in this case. user_name User name of the mapping. CURRENT_ROLE, CURRENT_USER, and USER match…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the view does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of the view to remove. CASCADE Automatical…Parameters ParametersManual ChaptersPG18Parameters WORKTRANSACTION Optional key words. They have no effect. AND CHAIN If AND CHAIN is specified, a new transaction is immediately started with the same transaction characteristics (s…Parameters ParametersManual ChaptersPG18Parameters name The name of the prepared statement to execute. parameter The actual value of a parameter to the prepared statement. This must be an expression yielding a value that is compat…Parameters ParametersManual ChaptersPG18Parameters ANALYZE Carry out the command and show actual run times and other statistics. This parameter defaults to FALSE. VERBOSE Display additional information regarding the plan. Specific…Parameters ParametersManual ChaptersPG18Parameters direction direction defines the fetch direction and number of rows to fetch. It can be one of the following: NEXT Fetch the next row. This is the default if direction is omitted. …Parameters ParametersManual ChaptersPG18Parameters remote_schema The remote schema to import from. The specific meaning of a remote schema depends on the foreign data wrapper in use. LIMIT TO ( table_name [, ...] ) Import only for…Parameters ParametersManual ChaptersPG18ParametersParameters ParametersManual ChaptersPG18Parameters channel Name of a notification channel (any identifier).Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of an existing table to lock. If ONLY is specified before the table name, only that table is locked. If ONLY is not specified, the tabl…Parameters ParametersManual ChaptersPG18Parameters with_query The WITH clause allows you to specify one or more subqueries that can be referenced by name in the MERGE query. See Section 7.8 and SELECT for details. Note that WITH R…Parameters ParametersManual ChaptersPG18Parameters channel Name of the notification channel to be signaled (any identifier). payload The “payload” string to be communicated along with the notification. This must be specified as a …Parameters ParametersManual ChaptersPG18Parameters transaction_id An arbitrary identifier that later identifies this transaction for COMMIT PREPARED or ROLLBACK PREPARED. The identifier must be written as a string literal, and mus…Parameters ParametersManual ChaptersPG18Parameters name An arbitrary name given to this particular prepared statement. It must be unique within a single session and is subsequently used to execute or deallocate a previously prepar…Parameters ParametersManual ChaptersPG18Parameters old_role The name of a role. The ownership of all the objects within the current database, and of all shared objects (databases, tablespaces), owned by this role will be reassigne…Parameters ParametersManual ChaptersPG18Parameters CONCURRENTLY Refresh the materialized view without locking out concurrent selects on the materialized view. Without this option a refresh which affects a lot of rows will tend to …Parameters ParametersManual ChaptersPG18Parameters INDEX Recreate the specified index. This form of REINDEX cannot be executed inside a transaction block when used with a partitioned index. TABLE Recreate all indexes of the specif…Parameters ParametersManual ChaptersPG18Parameters savepoint_name The name of the savepoint to release.Parameters ParametersManual ChaptersPG18Parameters configuration_parameter Name of a settable run-time parameter. Available parameters are documented in Chapter 19 and on the SET reference page. ALL Resets all settable run-time pa…Parameters ParametersManual ChaptersPG18Parameters transaction_id The transaction identifier of the transaction that is to be rolled back.Parameters ParametersManual ChaptersPG18Parameters savepoint_name The savepoint to roll back to.Parameters ParametersManual ChaptersPG18Parameters WORKTRANSACTION # Optional key words. They have no effect. AND CHAIN # If AND CHAIN is specified, a new (not aborted) transaction is immediately started with the same transaction …Parameters ParametersManual ChaptersPG18Parameters savepoint_name The name to give to the new savepoint. If savepoints with the same name already exist, they will be inaccessible until newer identically-named savepoints are releas…Parameters ParametersManual ChaptersPG18Parameters object_nametable_name.column_nameaggregate_namefunction_nameprocedure_nameroutine_name The name of the object to be labeled. Names of objects that reside in schemas (tables, funct…Parameters ParametersManual ChaptersPG18ParametersParameters ParametersManual ChaptersPG18Parameters TEMPORARY or TEMP If specified, the table is created as a temporary table. Refer to CREATE TABLE for details. UNLOGGED If specified, the table is created as an unlogged table. Ref…Parameters ParametersManual ChaptersPG18Parameters SESSION Specifies that the command takes effect for the current session. (This is the default if neither SESSION nor LOCAL appears.) LOCAL Specifies that the command takes effect …Parameters ParametersManual ChaptersPG18Parameters name The name of a run-time parameter. Available parameters are documented in Chapter 19 and on the SET reference page. In addition, there are a few parameters that can be shown b…Parameters ParametersManual ChaptersPG18Parameters Refer to SET TRANSACTION for information on the meaning of the parameters to this statement.Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of a table to truncate. If ONLY is specified before the table name, only that table is truncated. If ONLY is not specified, the table a…Parameters ParametersManual ChaptersPG18Parameters channel Name of a notification channel (any identifier). * All current listen registrations for this session are cleared.Parameters ParametersManual ChaptersPG18Parameters with_query The WITH clause allows you to specify one or more subqueries that can be referenced by name in the UPDATE query. See Section 7.8 and SELECT for details. table_name The …Parameters ParametersManual ChaptersPG18Parameters FULL Selects “full” vacuum, which can reclaim more space, but takes much longer and exclusively locks the table. This method also requires extra disk space, since it writes a new …Parameters ParametersManual ChaptersPG18Parameters expression A constant or expression to compute and insert at the indicated place in the resulting table (set of rows). In a VALUES list appearing at the top level of an INSERT, an…Parameters ParserManual ChaptersPG1851.3.1. Parser The parser has to check the query string (which arrives as plain text) for valid syntax. If the syntax is correct a parse tree is built up and handed back; otherwise an error …Parser Parser TestingManual ChaptersPG1812.8.2. Parser Testing The following functions allow direct testing of a text search parser. ts_parse(parser_name text, document text, OUT tokid integer, OUT token text) returns setof record…Parser Testing ParsersManual ChaptersPG1812.5. Parsers Text search parsers are responsible for splitting raw document text into tokens and identifying each token's type, where the set of possible types is defined by the parser itse…Parsers Parsing DocumentsManual ChaptersPG1812.3.1. Parsing Documents PostgreSQL provides the function to_tsvector for converting a document to the tsvector data type. to_tsvector([ config regconfig, ] document text) returns tsvector …Parsing Documents Parsing QueriesManual ChaptersPG1812.3.2. Parsing Queries PostgreSQL provides the functions to_tsquery, plainto_tsquery, phraseto_tsquery and websearch_to_tsquery for converting a query to the tsquery data type. to_tsquery o…Parsing Queries Partial AggregationManual ChaptersPG1836.12.4. Partial Aggregation Optionally, an aggregate function can support partial aggregation. The idea of partial aggregation is to run the aggregate's state transition function over diffe…Partial Aggregation