diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2011-06-28 16:07:23 +0300 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2011-06-28 16:08:52 +0300 |
| commit | 5594d14696f916e4aad14a3a12a4c15d2e7123bc (patch) | |
| tree | d5f8e36649af15bcb26c632de424391976743d02 /src | |
| parent | c533c1477f6beede766034c1226a20ac08320b05 (diff) | |
| download | postgresql-5594d14696f916e4aad14a3a12a4c15d2e7123bc.tar.gz postgresql-5594d14696f916e4aad14a3a12a4c15d2e7123bc.zip | |
Add composite-type attributes to information_schema.element_types view
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/catalog/information_schema.sql | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/src/backend/catalog/information_schema.sql b/src/backend/catalog/information_schema.sql index 9334c7654d1..c7ccea33310 100644 --- a/src/backend/catalog/information_schema.sql +++ b/src/backend/catalog/information_schema.sql @@ -2467,12 +2467,13 @@ CREATE VIEW element_types AS FROM pg_namespace n, pg_type at, pg_namespace nbt, pg_type bt, ( - /* columns */ + /* columns, attributes */ SELECT c.relnamespace, CAST(c.relname AS sql_identifier), - 'TABLE'::text, a.attnum, a.atttypid + CASE WHEN c.relkind = 'c' THEN 'USER-DEFINED TYPE'::text ELSE 'TABLE'::text END, + a.attnum, a.atttypid FROM pg_class c, pg_attribute a WHERE c.oid = a.attrelid - AND c.relkind IN ('r', 'v', 'f') + AND c.relkind IN ('r', 'v', 'f', 'c') AND attnum > 0 AND NOT attisdropped UNION ALL |