X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DD8B2D1B45E for ; Thu, 18 Dec 2003 21:22:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 84490-08 for ; Thu, 18 Dec 2003 17:21:43 -0400 (AST) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id DBD2DD1B45D for ; Thu, 18 Dec 2003 17:21:40 -0400 (AST) Received: (qmail 30215 invoked by uid 500); 18 Dec 2003 21:21:33 -0000 Date: Thu, 18 Dec 2003 15:21:33 -0600 From: Bruno Wolff III To: Terry Hampton Cc: pgsql-admin@postgresql.org Subject: Re: [Fwd: Quick Question Please] Message-ID: <20031218212133.GA28777@wolff.to> Mail-Followup-To: Terry Hampton , pgsql-admin@postgresql.org References: <3FE2128E.8050808@limacorp.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3FE2128E.8050808@limacorp.com> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/266 X-Sequence-Number: 11772 On Thu, Dec 18, 2003 at 15:48:14 -0500, Terry Hampton wrote: > > > OOPS! This group is quick and sharp. > I was not specific enough with my need. > Sorry to clog your email. > > Was is the SQL syntax to > return table names programatically ? > > thanks again for a quick hand, > Terry If you run psql with the -E option and then do a \d tablename, the sql used to calculate the response will be displayed. That sql would be the right way to do what you want.