Hi!
Tell me please is there any way to dump data from current session
(instead of using pg_dump) ?
igor mailto:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an
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 MyDataBasearchiv.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 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
On Mon, Apr 04, 2005 at 01:11:20PM +0400, go wrote:
I would like to pg_dump -Fc MyDataBasearchiv.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
[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 MyDataBasearchiv.dat ( maybe there is
any SQL command or something else) .
in case with COPY command I have
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