Hi,
I have tested with "pg_dump -u -p 5432 -d -f c:\test.sql mydatabase" but
the order of the INSERTS it is not the correct. What PG_DUMP does is to add
the CONSTRAINTS after doing the INSERTS. There is a way to have the correct
order of the INSERTS?
I have tested the COPY but does not insert no
Andre Lopes writes:
> I have generated the CREATE statements using a modeling tool, and I have
> created another database to test the changes. My problem is the order of the
> INSERT statements generated by PG_DUMP [-a -d], causing errors because of
> the order of the INSERTS.
If you are talking
Hi,
I'am having trouble using PG_DUMP. The problem is the following, I have made
some minor changes to my database, I have added one table.
I have generated the CREATE statements using a modeling tool, and I have
created another database to test the changes. My problem is the order of the
INSERT
I'd put them all into the same schema and dump that.
pg_dump -n schemaname
On Tue, Mar 3, 2009 at 8:30 AM, Roger Chen wrote:
> Thanks. If there are many tables owned by me and some other users, are
> there any easy ways to do that?
>
> On Mon, Mar 2, 2009 at 9:23 PM, Scott Marlowe wrote:
>> On
--- On Tue, 3/3/09, Roger Chen wrote:
> >> Hi,
> >> Can anyone tell me how to do that? I could find
> that in man page of
> >> pg_dump. Thanks.
> >
> > pg_dump -t table1 -t table2
> >
> Thanks. If there are many tables owned by me and some other
> users, are
> there any easy ways to do that?
>
Thanks. If there are many tables owned by me and some other users, are
there any easy ways to do that?
On Mon, Mar 2, 2009 at 9:23 PM, Scott Marlowe wrote:
> On Mon, Mar 2, 2009 at 5:31 PM, Roger Chen wrote:
>> Hi,
>> Can anyone tell me how to do that? I could find that in man page of
>> pg_dump
On Mon, Mar 2, 2009 at 5:31 PM, Roger Chen wrote:
> Hi,
> Can anyone tell me how to do that? I could find that in man page of
> pg_dump. Thanks.
pg_dump -t table1 -t table2
?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.
Hi,
Can anyone tell me how to do that? I could find that in man page of
pg_dump. Thanks.
Best,
Roger
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
am 31.03.2006, um 18:08:55 +0530 mailte deepak pal folgendes:
> hi
> i have to create a database script file using pg_dump ,but i do not
> understant how to run it under windows enviornment plz hep me and replay mee
> soon...
execute it via psql, start psql and then \i your_scri
hi i have to create a database script file using pg_dump ,but i do not understant how to run it under windows enviornment plz hep me and replay mee soon...
thanks.
- Original Message -
From: "Matt Van Mater" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, June 30, 2005 7:25 PM
Subject: Re: [GENERAL] how to use pg_dump and then restored onto development
server
On 6
On 6/29/05, Douglas McNaught <[EMAIL PROTECTED]> wrote:
> "Zlatko Matic" <[EMAIL PROTECTED]> writes:
>
> > OK..i get it. It works...
> > My additional question is: how to incorporate timestamp in dumped file
> > name ?
> > Let's say, if we have script: pg_dump -f D:\MYDB_BCP -Fc -c -x -h
> > local
"Zlatko Matic" <[EMAIL PROTECTED]> writes:
> OK..i get it. It works...
> My additional question is: how to incorporate timestamp in dumped file
> name ?
> Let's say, if we have script: pg_dump -f D:\MYDB_BCP -Fc -c -x -h
> localhost -U postgres MYDB,
> so that output file is named something like
sible?
Thanks.
- Original Message -
From: "Douglas McNaught" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc: "ketan shah" <[EMAIL PROTECTED]>;
Sent: Wednesday, June 29, 2005 5:29 PM
Subject: Re: [GENERAL] how to use pg_dump a
"Zlatko Matic" <[EMAIL PROTECTED]> writes:
> Concerning this question about pg_dump, I'm also confused and don't
> understand when to use pg_restore and when to use psql ?
> For example, how to restore in these two cases:
> A) pg_dump -f D:\MYDB_BCP -c -x -h localhost -U postgres MYDB
> B) pg_dump
ketan shah <[EMAIL PROTECTED]> writes:
> Hi,
>
> All ,
>
> I am newbie to postgres database. How to take pg_dump from production
> database and restore into development server using pg_restore..
>
> From documentation, I find that I have to use pg_dump for backup and
> pg_restore for restoratio
calhost -U
postgres MYDB
Thanks.
- Original Message -
From:
ketan shah
To: pgsql-general@postgresql.org
Sent: Wednesday, June 29, 2005 4:48
PM
Subject: [GENERAL] how to use pg_dump and
then restored onto development server
Hi,
All
,
I am
Hi,
All ,
I am newbie to postgres database. How to take pg_dump from production database and restore into development server using pg_restore..
From documentation, I find that I have to use pg_dump for backup and pg_restore for restoration.
My database name is otsdb..
For backup
I use comm
18 matches
Mail list logo