Re: Desc Commnad in pgsql? - Mailing list pgsql-sql

From Alvaro Herrera
Subject Re: Desc Commnad in pgsql?
Date
Msg-id 20080421133626.GD6520@alvh.no-ip.org
Whole thread Raw
In response to Re: Desc Commnad in pgsql?  (TJ O'Donnell <tjo@acm.org>)
List pgsql-sql
TJ O'Donnell wrote:
> I like the table and other info from psql
> and find I sometimes need that info in my client programs.
> Are there any SQL/plpgsql functions that are analogous
> to the psql \dt, \ds, etc. commands?

If you start psql with the -E option it will show you the queries it
used to build the response tables.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-sql by date:

Previous
From: Theerasak Maneeneim
Date:
Subject: Error: could not find pathkey item to sort
Next
From: Thomas Kellerer
Date:
Subject: Having a mental block with (self) outer joins