DatabaseSchema: pgsql.php
[ ]
[ ]
[ ]
[ ]
[ ]
Procedural File: pgsql.php
File containing the ezcDbSchemaHandlerPgsql class.
Classes
EZC_DBSCHEMA_FETCH_INDEX_COL_NAMES_QUERY [line 43]
EZC_DBSCHEMA_FETCH_INDEX_COL_NAMES_QUERY = <<<END
SELECTSELECT a.attnum, a.attname
FROM pg_catalog.pg_attribute a
WHERE a.attrelid = '<<indexrelid>>' AND a.attnum IN (<<attids>>) AND NOT a.attisdropped
ORDER BY a.attnum
END
|
|
EZC_DBSCHEMA_FETCH_INDEX_DEF_QUERY [line 36]
EZC_DBSCHEMA_FETCH_INDEX_DEF_QUERY = <<<END
SELECTSELECT c.relname, i.*
FROM pg_catalog.pg_index i, pg_catalog.pg_class c
WHERE indrelid = '<<oid>>'
AND i.indexrelid = c.oid
END
|
|
EZC_DBSCHEMA_FETCH_TABLE_DEF_QUERY [line 25]
EZC_DBSCHEMA_FETCH_TABLE_DEF_QUERY = <<<END
SELECTSELECT a.attname,
pg_catalog.format_type(a.atttypid, a.atttypmod),
(SELECT substring(d.adsrc for 128) FROM pg_catalog.pg_attrdef d
WHERE d.adrelid = a.attrelid AND d.adnum = a.attnum AND a.atthasdef) as default,
a.attnotnull, a.attnum
FROM pg_catalog.pg_attribute a
WHERE a.attrelid = '<<oid>>' AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
END
|
|
EZC_DBSCHEMA_FETCH_TABLE_OID_QUERY [line 14]
EZC_DBSCHEMA_FETCH_TABLE_OID_QUERY = <<<END
SELECTSELECT c.oid,
n.nspname,
c.relname
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE pg_catalog.pg_table_is_visible(c.oid)
AND c.relname ~ '^<<tablename>>$'
ORDER BY 2, 3;
END
|
|
Define EZC_DBSCHEMA_FETCH_TABLE_OID_QUERY
Last updated: Wed, 28 Nov 2007
