Re: [GENERAL] exporting postgre data

2008-01-25 Thread Raymond O'Donnell
On 25/01/2008 16:51, johnf wrote: The issue I have with pgAdmin3 and backing up a table is with the restore. The associated sequences are not restored. Granted that might be a different problem. But from a users perspective I see it as a major problem. Oh? Works fine for me, on PG 8.2.5 -

Re: [GENERAL] exporting postgre data

2008-01-25 Thread johnf
On Friday 25 January 2008 07:21:34 am Harald Armin Massa wrote: > Bill, > > pgadmin3 provides the same: just dig down to the table, use the backup > link and give the options. It also calls pg_dump just with the right > parameters, you can copy that command for a .cmd for professional > automatic b

Re: [GENERAL] exporting postgre data

2008-01-25 Thread Ivan Sergio Borgonovo
On Fri, 25 Jan 2008 10:02:41 -0500 Bill Moran <[EMAIL PROTECTED]> wrote: > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] On Behalf Of User > > > Map Sent: Friday, January 25, 2008 10:18 AM > > > To: pgsql > > > Subject: [GENERAL] exporting postgre data > > > > > > > > > is it posible

Re: [GENERAL] exporting postgre data

2008-01-25 Thread Harald Armin Massa
Bill, pgadmin3 provides the same: just dig down to the table, use the backup link and give the options. It also calls pg_dump just with the right parameters, you can copy that command for a .cmd for professional automatic backup. Best wishes, Harald > MSSQL has a fancy GUI "wizard". > > It basi

Re: [GENERAL] exporting postgre data

2008-01-25 Thread Bill Moran
> > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of User Map > > Sent: Friday, January 25, 2008 10:18 AM > > To: pgsql > > Subject: [GENERAL] exporting postgre data > > > > > > is it posible to transfer data from postgres of one computer to the > > postgres in another computer. I

Re: [GENERAL] exporting postgre data

2008-01-25 Thread Harald Armin Massa
JohnF, > But how do you backup only a single table or transfer only a signle table. please use pg_dump. You can find excellent documentation at http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html please pay special attention to the --table option. Best wishes, Harald -- GHUM Har

Re: [GENERAL] exporting postgre data

2008-01-25 Thread johnf
On Friday 25 January 2008 02:56:12 am Gevik Babakhani wrote: > Check out the docs for pg_dump utility. > http://www.postgresql.org/docs/8.3/static/app-pgdump.html > > > _ > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of User Map > Sent: Friday, January 25, 2008 10:18 AM >

Re: [GENERAL] exporting postgre data

2008-01-25 Thread Gevik Babakhani
Check out the docs for pg_dump utility. http://www.postgresql.org/docs/8.3/static/app-pgdump.html _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of User Map Sent: Friday, January 25, 2008 10:18 AM To: pgsql Subject: [GENERAL] exporting postgre data is it posible to trans