SELECT CAST(current_database()AS sql_identifier)AS constraint_catalog,

CAST(n.nspnameAS sql_identifier)AS constraint_schema,

CAST(n.oid||'_'||r.oid||'_'||a.attnum||'_not_null'AS sql_identifier)AS constraint_name,-- XXX

CAST(CAST(n.oidAStext)||'_'||CAST(r.oidAStext)||'_'||CAST(a.attnumAStext)||'_not_null'AS sql_identifier)AS constraint_name,-- XXX

CAST(a.attname||' IS NOT NULL'AS character_data)

AS check_clause

FROM pg_namespace n, pg_class r, pg_attribute a

SELECT CAST(current_database()AS sql_identifier)AS constraint_catalog,

CAST(nr.nspnameAS sql_identifier)AS constraint_schema,

CAST(nr.oid||'_'||r.oid||'_'||a.attnum||'_not_null'AS sql_identifier)AS constraint_name,-- XXX

CAST(CAST(nr.oidAStext)||'_'||CAST(r.oidAStext)||'_'||CAST(a.attnumAStext)||'_not_null'AS sql_identifier)AS constraint_name,-- XXX

CAST(current_database()AS sql_identifier)AS table_catalog,

CAST(nr.nspnameAS sql_identifier)AS table_schema,

CAST(r.relnameAS sql_identifier)AS table_name,

CAST('NONE'AS character_data)AS check_option,

CAST(

CASE WHEN EXISTS (SELECT1FROM pg_rewriteWHERE ev_class=c.oidAND ev_type=2AND is_instead)

AND EXISTS (SELECT1FROM pg_rewriteWHERE ev_class=c.oidAND ev_type=4AND is_instead)

CASE WHEN EXISTS (SELECT1FROM pg_rewriteWHERE ev_class=c.oidAND ev_type='2'AND is_instead)

AND EXISTS (SELECT1FROM pg_rewriteWHERE ev_class=c.oidAND ev_type='4'AND is_instead)

THEN'YES' ELSE'NO' END

AS character_data)AS is_updatable,

CAST(

CASE WHEN EXISTS (SELECT1FROM pg_rewriteWHERE ev_class=c.oidAND ev_type=3AND is_instead)

CASE WHEN EXISTS (SELECT1FROM pg_rewriteWHERE ev_class=c.oidAND ev_type='3'AND is_instead)

THEN'YES' ELSE'NO' END

AS character_data)AS is_insertable_into

CAST(nullAS sql_identifier)AS scope_name,

CAST(nullAS cardinal_number)AS maximum_cardinality,

CAST('a'||x.objdtdidAS sql_identifier)AS dtd_identifier

CAST('a'||CAST(x.objdtdidAStext)AS sql_identifier)AS dtd_identifier

FROM pg_namespace n, pg_type at, pg_namespace nbt, pg_type bt,

(

ANDat.typelem=bt.oid

ANDnbt.oid=bt.typnamespace

AND (n.nspname,x.objname,x.objtype,x.objdtdid)IN

AND (n.nspname,x.objname,x.objtype,CAST(x.objdtdidAS sql_identifier))IN

(SELECT object_schema, object_name, object_type, dtd_identifier

FROM data_type_privileges );