Toad Data Modeler 7.2 - User Guide

Attributes - Foreign Table

Resulting in:

CREATE FOREIGN TABLE "postgres"."T_CUSTOMER"(
"customer_id" Integer NOT NULL,
"name" Character varying(24) OPTIONS (columndelimiter ':'),
"address" Text
)

Data Type box - Smallserial and Json new data types.

Functions

Leakproof checkbox on tab General.

Generated SQL:

create function add4 (integer, integer) RETURNS integer
AS 'select $1 + $2;'
LANGUAGE SQL
LEAKPROOF
RETURNS NULL ON NULL INPUT;

Index

Index Access Method- new option spgist.

Buffering parameter option for gist index.

Table, Attribute - Check Constraint

No Inherit - Allows not inherited constraints for tables and attributes.

Generated SQL:

create table distributors2
(
did integer,
name varchar (40),
CONSTRAINT con1_noinh_table CHECK (did > 100 AND name <> '') NO INHERIT
)

User Data Type

General tab, Type box - New type Range Type.

See other objects in Model Explorer:

• Aggregates
• Collations
• Foreign Servers
• Tablespaces
• Sequences
• Rewrite Rules

Available Data Providers are:

• Connection via ODBC
• Native Connection

Connection via ODBC:

Native Connection: