X-Original-To: pgsql-hackers@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 92AA5475F1B for ; Wed, 23 Apr 2003 08:44:16 -0400 (EDT) Received: from nat.inquent.com (CPE00508b028d7d-CM00803785c5e0.cpe.net.cable.rogers.com [24.103.22.28]) by postgresql.org (Postfix) with ESMTP id 643D4475ADE for ; Wed, 23 Apr 2003 08:44:15 -0400 (EDT) Received: from [127.0.0.1] (localhost [127.0.0.1]) by nat.inquent.com (8.12.8p1/8.12.8) with ESMTP id h3NCiDFc038219; Wed, 23 Apr 2003 08:44:14 -0400 (EDT) (envelope-from rbt@rbt.ca) Subject: Re: Are we losing momentum? From: Rod Taylor To: Shridhar Daithankar Cc: PostgreSQL Hackers In-Reply-To: <200304231145.58929.shridhar_daithankar@nospam.persistent.co.in> References: <200304231145.58929.shridhar_daithankar@nospam.persistent.co.in> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-+RtVB66RVcJehWHanMsN" Organization: Message-Id: <1051101853.37927.8.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 23 Apr 2003 08:44:13 -0400 X-Spam-Status: No, hits=-45.1 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,PGP_SIGNATURE_2, QUOTED_EMAIL_TEXT,REFERENCES,REPLY_WITH_QUOTES, USER_AGENT_XIMIAN autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/810 X-Sequence-Number: 38300 --=-+RtVB66RVcJehWHanMsN Content-Type: text/plain Content-Transfer-Encoding: quoted-printable 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' TH= EN > > '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 =3D 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. >=20 > Have you used TORA any times? It does support postgresql and it does it p= retty=20 > well.. http://techdocs.postgresql.org/guides/GUITools A rather handy list of GUITools available for PostgreSQL. --=20 Rod Taylor PGP Key: http://www.rbt.ca/rbtpub.asc --=-+RtVB66RVcJehWHanMsN Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (FreeBSD) iD8DBQA+poqc6DETLow6vwwRAjfFAJ4hSea0Ekv/XMhDyqv3YRaDalsDLQCaAoOF cMIF2iftTPAerSXsf+Ifxi0= =gHdQ -----END PGP SIGNATURE----- --=-+RtVB66RVcJehWHanMsN--