Re: Are we losing momentum?

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