Catriona: Created page with "{{#apGetSQL:select rec from ( select tablename, schema, format ('

%s

Schema

CREATE TABLE %s ( %s );',tablename, description, schema, ta..."

2014-02-25T03:30:55Z

Created page with "{{#apGetSQL:select rec from ( select tablename, schema, format ('<h3>%s</h3> <P>%s</p> <dt>Schema</dt><dd>%s</dd> CREATE TABLE %s ( %s );',tablename, description, schema, ta..."

Halaman baru

{{#apGetSQL:select rec from (
select tablename, schema, format ('<h3>%s</h3>
<P>%s</p>
<dt>Schema</dt><dd>%s</dd>
CREATE TABLE %s (
%s
);',tablename, description, schema, tablename, string_agg(fdef,',
')) as rec
from
(SELECT
descr.description as description,
n.nspname as schema,
c.relname as tablename,
format(' %s %s%s%s%s%s%s',
f.attname,
pg_catalog.format_type(f.atttypid,f.atttypmod),
CASE WHEN p.contype = 'p' THEN ' PRIMARY KEY' ELSE '' END,
CASE WHEN p.contype = 'u' THEN ' UNIQUE' ELSE '' END,
case when f.attnotnull then ' NOT NULL' ELSE '' END,
CASE WHEN f.atthasdef = 't' THEN format(' DEFAULT %s',d.adsrc) ELSE '' END,
CASE WHEN p.contype = 'f' THEN format(' REFERENCES %s', g.relname) END
) as fdef
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid
JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
LEFT OUTER JOIN pg_description descr on c.oid = descr.objoid
WHERE c.relkind = 'r'::char
AND not n.nspname in ('public', 'pg_catalog')
AND f.attnum > 0
ORDER BY c.relname, f.attnum) as foo
group by schema, tablename, description) as bar
order by tablename
;|}}

Database tables - Revision history

Catriona: Created page with "{{#apGetSQL:select rec from ( select tablename, schema, format ('

%s