On Tuesday 22 April 2003 22:47, scott.marlowe wrote:
> To the Windows guys, how do I tell them to just create a view
> encapsulating:
>
> SELECT c.relname as "Name",
> CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'i' THEN
> 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' END as "Type",
> u.usename as "Owner"
> FROM pg_class c LEFT JOIN pg_user u ON c.relowner = u.usesysid
> WHERE c.relkind IN ('r','v','S','')
> AND c.relname !~ '^pg_'
> ORDER BY 1;
>
> if they want a list of the tables, sequences, views and indexes in
> postgresql.
Have you used TORA any times? It does support postgresql and it does it pretty
well..
Shridhar