Re: How to dump data from database?

From: John DeSoi <desoi(at)pgedit(dot)com>
To: go <go(at)ugnn(dot)ru>
Cc: PGSQL mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to dump data from database?
Date: 2005-04-04 18:28:21
Message-ID: 53167BC9-A537-11D9-8FA8-000A95B03262@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Apr 4, 2005, at 5:11 AM, go wrote:

> And pls one small question - what query will return me a list
> of tables in database ( \l - works only in psql)?

Startup of psql with the -E option (or use \set ECHO_HIDDEN 1). Then
psql will show you the query it uses for \l or any other \ command.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2005-04-04 19:56:28 Re: [HACKERS] plPHP in core?
Previous Message Chandra Sekhar Surapaneni 2005-04-04 16:59:32 Regarding niladic functions