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.
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 Access Method- new option spgist.
Buffering parameter option for gist index.
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
)
General tab, Type box - New type Range Type.
See other objects in Model Explorer:
Available Data Providers are:
Connection via ODBC:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center