Catalogue définition d'une table FIELD
select cl.table_catalog ,cl.table_name ,d.description ,cl.column_name ,e.description ,cl.ORDINAL_POSITION ,cl.DATA_TYPE ,coalesce(cl.CHARACTER_MAXIMUM_LENGTH,0) ,coalesce(cl.NUMERIC_PRECISION,0) ,coalesce(cl.NUMERIC_SCALE,0) from information_schema.columns cl , pg_catalog.pg_attribute a inner join pg_catalog.pg_class c on a.attrelid = c.oid, pg_catalog.pg_description d, pg_catalog.pg_description e where cl.table_catalog ='CGIFCH' and c.relname ='FTCPAY' and a.attnum > 0 and a.attisdropped is false and pg_catalog.pg_table_is_visible(c.oid) and cl.table_name = c.relname and cl.ORDINAL_POSITION = a.attnum and d.objoid = a.attrelid and d.objsubid = 0 and e.objoid = a.attrelid and e.objsubid = a.attnum order by a.attnum;


Catalogue définition Nombre de Field
select count(*) FROM information_schema.columns cl WHERE cl.table_catalog ='CGIFCH' and cl.table_name='FTCPAY';


Catalogue définition Nombre de key
select count(*) FROM information_schema.key_column_usage cl WHERE cl.table_catalog ='CGIFCH' and cl.table_name='FTCPAY';


Catalogue définition d'une table KEY
select cl.table_catalog ,tc.table_name ,kc.column_name ,e.description ,kc.ORDINAL_POSITION ,cl.DATA_TYPE ,coalesce(cl.CHARACTER_MAXIMUM_LENGTH,0) ,coalesce(cl.NUMERIC_PRECISION,0) ,coalesce(cl.NUMERIC_SCALE,0) from information_schema.table_constraints tc, information_schema.key_column_usage kc, information_schema.columns cl, pg_catalog.pg_attribute a inner join pg_catalog.pg_class c on a.attrelid = c.oid, pg_catalog.pg_description e where cl.table_catalog='CGIFCH' and kc.table_name ='FTCPAY' and kc.column_name = cl.column_name and tc.constraint_type = 'PRIMARY KEY' and kc.table_name = tc.table_name and kc.table_schema = tc.table_schema and kc.table_name = cl.table_name and kc.constraint_name = tc.constraint_name and a.attnum > 0 and a.attisdropped is false and pg_catalog.pg_table_is_visible(c.oid) and cl.table_name = c.relname and cl.ORDINAL_POSITION = a.attnum and e.objoid = a.attrelid and e.objsubid = a.attnum order by 5;


Catalogue définition d'une table Description
select cl.table_catalog ,cl.table_name ,d.description ,c.relnatts from information_schema.columns cl , pg_catalog.pg_attribute a inner join pg_catalog.pg_class c on a.attrelid = c.oid, pg_catalog.pg_description d where cl.table_catalog ='CGIFCH' and c.relname ='FTCPAY' and cl.table_name = c.relname and d.objoid = a.attrelid and d.objsubid = 0 and cl.ORDINAL_POSITION = 1 and cl.ORDINAL_POSITION = a.attnum;


Catalogue Table
select cl.table_catalog ,cl.table_name ,d.description ,c.relnatts from information_schema.columns cl , pg_catalog.pg_attribute a inner join pg_catalog.pg_class c on a.attrelid = c.oid, pg_catalog.pg_description d where cl.table_catalog ='CGIFCH' /* and c.relname ='FTCPAY' */ and cl.table_name = c.relname and d.objoid = a.attrelid and d.objsubid = 0 and cl.ORDINAL_POSITION = 1 and cl.ORDINAL_POSITION = a.attnum;

Return