| From: | Stef <svb(at)ucs(dot)co(dot)za> |
|---|---|
| To: | "sandhya" <sandhyar(at)amiindia(dot)co(dot)in> |
| Cc: | "postgre" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Reg: sql commands |
| Date: | 2005-09-22 10:54:27 |
| Message-ID: | 20050922125427.1e60e1df@svb.ucs.co.za |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 :)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar Mallah | 2005-09-22 12:26:01 | Is pgdump_all == pg_dumpall -g + pg_dump of individual databases ? |
| Previous Message | sandhya | 2005-09-22 10:51:03 | Re: Reg: sql commands |