How to dump data from database?

On Mon, Apr 04, 2005 at 11:18:08AM +0400, go wrote:

Tell me please is there any way to dump data from current session
(instead of using pg_dump) ?

What exactly are you trying to do? Will COPY (or psql's \copy) do
what you want?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

I would like to "pg_dump -Fc MyDataBase>archiv.dat" ( maybe there is
any SQL command or something else) .
in case with COPY command I have to copy each table one by one.

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

Thanks!

MF> On Mon, Apr 04, 2005 at 11:18:08AM +0400, go wrote:

Tell me please is there any way to dump data from current session
(instead of using pg_dump) ?

MF> What exactly are you trying to do? Will COPY (or psql's \copy) do
MF> what you want?

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

On Mon, Apr 04, 2005 at 01:11:20PM +0400, go wrote:

I would like to "pg_dump -Fc MyDataBase>archiv.dat" ( maybe there is
any SQL command or something else) .
in case with COPY command I have to copy each table one by one.

I suppose you could write a function in a procedural language like
PL/Perl, PL/Python, or PL/Tcl that runs pg_dump, but why do you
need to do this from SQL? Why can't you just run pg_dump from
outside the database?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

[Please copy the mailing list on replies.]

On Tue, Apr 05, 2005 at 08:07:47AM +0400, go wrote:

MF> On Mon, Apr 04, 2005 at 01:11:20PM +0400, go wrote:

I would like to "pg_dump -Fc MyDataBase>archiv.dat" ( maybe there is
any SQL command or something else) .
in case with COPY command I have to copy each table one by one.

MF> I suppose you could write a function in a procedural language like
MF> PL/Perl, PL/Python, or PL/Tcl that runs pg_dump, but why do you
MF> need to do this from SQL? Why can't you just run pg_dump from
MF> outside the database?

Pls, write a small sample of the function .

Could you tell us why you want to run pg_dump from SQL? What problem
are you trying to solve?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

Hi, Michael.

I would like to add the possibility of archiving database from
application. I cannt add archiving in schedule - because
there is no server running all day round . And in the end of day
any user can dump database when neccesary.
(there is some problems with running script which can pg_dump
database . the problem is : windows applications , such as
pg_dump.exe make all messages in wrong encoding in russian and i
cannt explane dummy users what to do)

Thanks for replay!

MF> Could you tell us why you want to run pg_dump from SQL? What problem
MF> are you trying to solve?

--

go mailto:go@ugnn.ru