db-explorer.tcl

Location:
/packages/acs-subsite/www/admin/system/db-explorer.tcl
Author:
Guenter Ernst guenter.ernst@wu-wien.ac.at
Created:
26.11.2008

Related Files

[ hide source ] | [ make this the default ]

File Contents

ad_page_contract {
    @author Guenter Ernst guenter.ernst@wu-wien.ac.at
    @creation-date 26.11.2008
} 


# source table selector

db_multirow tables_and_views get_tables {select
            n.nspname as schema,
            c.relname,
            n.nspname || '.' || c.relname  as fq_table_name,
            relkind 
            from pg_catalog.pg_class c inner join pg_catalog.pg_namespace n ON n.oid = c.relnamespace 
            where relkind in ('r','v') 
            order by n.nspname,c.relname } 


ad_return_template