Toad Data Modeler 7.2 - User Guide

Available Data Providers are:

• Connection via ODBC
• Native Connection

Connection via ODBC:

Native Connection:

Tables

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' );

Indexes

Index Access Method - brin

Index properties - Pages Per Range, Gin Pending List Limit

Materialized Views

Storage Parameters - Log Min Duration for Autovacuum and TOAST Autovacuum

User Groups

Role Options - BYPASSRLS, NOBYPASSRLS

CREATE ROLE tangerine3 BYPASSRLS;

CREATE ROLE tangerine5 WITH LOGIN PASSWORD 'jw8s0F4' VALID UNTIL '2005-01-01' BYPASSRLS;

Change Script Generation

• Support of the following PostgreSQL 9.5 features:

Available Data Providers are:

• Connection via ODBC
• Native Connection

Connection via ODBC:

Native Connection: