× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Like  

System Catalogs

STL_DDLTEXT, STL_ERROR,  STL_EXPLAIN, STL_FILE_SCAN,  STL_LOAD_COMMITS, STL_QUERY,  STL_QUERYTEXT, STL_SESSIONS,  STL_SMFAULTS

pg_attribute, pg_namespace, pg_class,PG_UDF table

List the number of columns per PADB table

select nspname, relname, max(attnum) as num_cols

from pg_attribute a, pg_namespace n, pg_class c
where n.oid = c.relnamespace and a.attrelid = c.oid
and c.relname not like '%pkey'
and n.nspname not like 'pg%'
and n.nspname not like 'information%'
group by 1, 2
order by 1, 2;

List the schemas and tables in a database

select datname, nspname, relname, sum(rows) as rows

from pg_class, pg_namespace, pg_database, stv_tbl_perm
where pg_namespace.oid = relnamespace
and pg_class.oid = stv_tbl_perm.id
and pg_database.oid = stv_tbl_perm.db_id
and datname ='tickit'
group by datname, nspname, relname
order by datname, nspname, relname;
 
List table IDs, data types, column names, and table names

select distinct attrelid, rtrim(name), attname, typname

from pg_attribute a, pg_type t, stv_tbl_perm p
where t.oid=a.atttypid and a.attrelid=p.id
and a.attrelid between 100100 and 110000
and typname not in('oid','xid','tid','cid')
order by a.attrelid asc, typname, attname;

Count the number of data blocks for each column in a table

select col, count(*)

from stv_blocklist s, pg_class p
where s.tbl=p.oid and relname='sales'
group by col
order by col;
 

 

 

 
Last updated by tariqrahiman on Dec 13, 2011 1:25 AM
This list is empty.

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017