Re: Reg: sql commands - Mailing list pgsql-admin

From Stef
Subject Re: Reg: sql commands
Date
Msg-id 20050922125427.1e60e1df@svb.ucs.co.za
Whole thread Raw
In response to Re: Reg: sql commands  ("sandhya" <sandhyar@amiindia.co.in>)
List pgsql-admin
sandhya mentioned :
=> No...What i need is...
=> I want to know the equivalent sql queries for \l and \dt commands in order
=> to list the databases and tables.
=> I want to do it through programming

From the psql man-page :
-E

--echo-hidden
       Echoes the actual queries generated by \d  and  other  backslash
       commands.  You can use this if you wish to include similar func-
       tionality into your own programs. This is equivalent to  setting
       the variable ECHO_HIDDEN from within psql.

If this is not _exactly_ what you need, then you're not exactly
explaining what you're trying to do :)

pgsql-admin by date:

Previous
From: "sandhya"
Date:
Subject: Re: Reg: sql commands
Next
From: Rajesh Kumar Mallah
Date:
Subject: Is pgdump_all == pg_dumpall -g + pg_dump of individual databases ?