Available Data Providers are:
- Connection via ODBC
- Native Connection
Connection via ODBC:
Available Data Providers are:
Connection via ODBC:
Storage Parameters - Log Min Duration for Autovacuum and TOAST Autovacuum
Check constraint generation and inheritance is now allowed for foreign tables.
CREATE TABLE users (id SERIAL PRIMARY KEY, username TEXT NOT NULL);
CREATE FOREIGN TABLE users_shard_5 (CONSTRAINT us5 CHECK (id <> 0 AND username <> ''))
INHERITS (users) server myserver options ( table_name 'users' );
CREATE FOREIGN TABLE users_shard_5a (CHECK (id <> 0 AND username <> ''))
INHERITS (users) server myserver options ( table_name 'users' );
Index Access Method - brin
Index properties - Pages Per Range, Gin Pending List Limit
Storage Parameters - Log Min Duration for Autovacuum and TOAST Autovacuum
Role Options - BYPASSRLS, NOBYPASSRLS
CREATE ROLE tangerine3 BYPASSRLS;
CREATE ROLE tangerine5 WITH LOGIN PASSWORD 'jw8s0F4' VALID UNTIL '2005-01-01' BYPASSRLS;
DDL | New Syntax |
---|---|
CREATE SEQUENCE | IF NOT EXISTS |
CREATE MATERIALIZED VIEW |
IF NOT EXISTS Support for SET and RESET of storage parameters log_autovacuum_min_duration, toast.log_autovacuum_min_duration (integer) |
CREATE TABLE |
Support for SET and RESET of storage parameters log_autovacuum_min_duration, toast.log_autovacuum_min_duration (integer) |
CREATE INDEX |
IF NOT EXISTS BRIN method Support for SET and RESET of pages_per_range parameter in WITH section Support for SET and RESET of new GIN method parameter gin_pending_list_limit in WITH section |
CREATE FOREIGN TABLE | INHERITS |
Available Data Providers are:
Connection via ODBC:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center