Loading...

XML

Word

Printable

Steps to Reproduce:

Hide

Execute following queries

SELECT table_catalog, table_schema, table_name, table_type FROM information_schema.tables

SELECT table_catalog, table_schema, table_name, column_name, ordinal_position, column_default,
is_nullable, udt_name AS data_type, character_maximum_length, character_octet_length,
numeric_precision, numeric_precision_radix, numeric_scale, datetime_precision, character_set_catalog,
character_set_schema, character_set_name, collation_catalog
FROM information_schema.columns

SELECT table_catalog, table_schema, table_name, check_option, is_updatable FROM information_schema.views

Show
Execute following queries SELECT table_catalog, table_schema, table_name, table_type FROM information_schema.tables SELECT table_catalog, table_schema, table_name, column_name, ordinal_position, column_default, is_nullable, udt_name AS data_type, character_maximum_length, character_octet_length, numeric_precision, numeric_precision_radix, numeric_scale, datetime_precision, character_set_catalog, character_set_schema, character_set_name, collation_catalog FROM information_schema.columns SELECT table_catalog, table_schema, table_name, check_option, is_updatable FROM information_schema.views
Forum Reference:
https://developer.jboss.org/thread/276932

The npgsql provider uses the the infomation_schema namespace to query meta information for tables and views.

relates to

TEIID-5201 Update teiid pg_type schema to match PostgreSQL pg_type in support of NPGsql provider