[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [HACKERS] Are we losing momentum?
From:       Rod Taylor <rbt () rbt ! ca>
Date:       2003-04-23 12:44:13
[Download RAW message or body]


On Wed, 2003-04-23 at 02:15, Shridhar Daithankar wrote:
> 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..

http://techdocs.postgresql.org/guides/GUITools

A rather handy list of GUITools available for PostgreSQL.

-- 
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

["signature.asc" (application/pgp-signature)]

[prev in list] [next in list] [prev in thread] [next in thread]