SELECT database() as DATABASE_NAME, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'public' AND TABLE_NAME = SELECT c.COLUMN_NAME as name, CASE WHEN i.PRIMARY_KEY = 'true' THEN 'true' ELSE 'false' END as primaryKey, 'false' as identity, CASE WHEN c.NULLABLE = 1 THEN 'true' ELSE 'false' END as nullable, c.TYPE_NAME as dbDataType, CASE WHEN c.CHARACTER_MAXIMUM_LENGTH IS NULL THEN 0 ELSE c.CHARACTER_MAXIMUM_LENGTH END as length, c.COLUMN_DEFAULT as default FROM information_schema.COLUMNS as c left join information_schema.indexes as i on(c.Table_name=i.table_name and c.column_name=i.column_name) WHERE c.TABLE_SCHEMA = 'public' AND c.TABLE_NAME = ORDER BY c.ORDINAL_POSITION