From: Rod Taylor <rbt@rbt.ca>
To: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Are we losing momentum?
Date: 23 Apr 2003 08:44:13 -0400
Message-ID: <1051101853.37927.8.camel@jester> (raw)
In-Reply-To: <200304231145.58929.shridhar_daithankar@nospam.persistent.co.in>
References: <Pine.LNX.4.33.0304221109360.9550-100000@css120.ihs.com>
<200304231145.58929.shridhar_daithankar@nospam.persistent.co.in>
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.ascAttachments:
signature.asc (application/pgp-signature, 186B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: rbt@rbt.ca, shridhar_daithankar@persistent.co.in
Subject: Re: Are we losing momentum?
In-Reply-To: <1051101853.37927.8.camel@jester>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox