Toad Data Modeler 6.4 - User Guide

PostgreSQL 9.5

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:

Reverse Engineering

Available Data Providers are:

• Connection via ODBC
• Native Connection

Connection via ODBC:

Native Connection:

Script Generating

PostgreSQL 10

• Amazon® Aurora MySQL 5.6
• Amazon® Aurora PostgreSQL 9.5
• Amazon® Redshift 1.0
• IBM® DB2® z/OS® 10, 11
• IBM® DB2® LUW 9.5, 9.7, 10.1, 10.5, 11.1
• Greenplum Database® 4.1, 4.2
• Ingres 9.3, 10.0
• EDB Postgres Advanced Server 10
• Microsoft® Access® 2007-2010
• Microsoft® Azure® SQL Database V12
• Microsoft® SQL Server® 2005, 2008, 2012, 2014, 2016, 2017
• MySQL 5.0, 5.1. 5.5, 5.6, 5.7
• Oracle® 10g, 11g R1, 11g R2, 12c R1, 12c R2
• PostgreSQL 9.0, 9.1, 9.2, 9.3, 9.4, 9.5, 10
• SQLite 3.7
• SAP® SQL Anywhere 17
• SAP® ASE 16.0
• Sybase® ASE 15.7
• Sybase® IQ 15.2
• Sybase® SQL Anywhere 11
• Teradata 13
• Vertica Database 8.0
• Other (Universal Model)

Details of Database Support