Thread: exporting postgre data
is it posible to transfer data from postgres of one computer to the postgres in another computer. In SQL server this is easily done by the export utility of the sql server.
Never miss a thing. Make Yahoo your homepage.
Never miss a thing. Make Yahoo your homepage.
Check out the docs for pg_dump utility.
is it posible to transfer data from postgres of one computer to the postgres in another computer. In SQL server this is easily done by the export utility of the sql server.
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of User Map
Sent: Friday, January 25, 2008 10:18 AM
To: pgsql
Subject: [GENERAL] exporting postgre data
Never miss a thing. Make Yahoo your homepage.
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: pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org] 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. In SQL server this is easily done by the > export utility of the sql server. > > > > _____ > > Never miss a thing. Make Yahoo > <http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs> your > homepage. But how do you backup only a single table or transfer only a signle table. -- John Fabiani
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 Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!
> > From: pgsql-general-owner@postgresql.org > > [mailto:pgsql-general-owner@postgresql.org] 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. In SQL server this is easily done by the > > export utility of the sql server. > > > > But how do you backup only a single table or transfer only a signle table. MSSQL has a fancy GUI "wizard". It basically does all the stuff pg_dump does, but just using a GUI interface to manage all the options. I guess it has the addition of managing the interaction between pg_dump on one server an pg_restore on another as well. Doesn't really have any more features that I'm aware of, just has a nice "one stop" interface. -- Bill Moran http://www.potentialtech.com
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 basically does all the stuff pg_dump does, but just using a GUI > interface to manage all the options. I guess it has the addition > of managing the interaction between pg_dump on one server an pg_restore > on another as well. > > Doesn't really have any more features that I'm aware of, just has a > nice "one stop" interface. > > -- > Bill Moran > http://www.potentialtech.com > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!
On Fri, 25 Jan 2008 10:02:41 -0500 Bill Moran <wmoran@potentialtech.com> wrote: > > > From: pgsql-general-owner@postgresql.org > > > [mailto:pgsql-general-owner@postgresql.org] 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. In SQL server this is easily > > > done by the export utility of the sql server. > > > > > > > But how do you backup only a single table or transfer only a > > signle table. > > MSSQL has a fancy GUI "wizard". bcp does not provide the full set of goodiness but it works on the command line. I don't think it is suited for backup... just for exporting. It doesn't make too much sense working on the command line on Windows (unless you work with monad and such... but still) since the shell is quite limited up to my knowledge. But *nix guys may feel more comfortable with bcp. -- Ivan Sergio Borgonovo http://www.webthatworks.it
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 backup. > > Best wishes, > > Harald > > > MSSQL has a fancy GUI "wizard". > > > > It basically does all the stuff pg_dump does, but just using a GUI > > interface to manage all the options. I guess it has the addition > > of managing the interaction between pg_dump on one server an pg_restore > > on another as well. > > > > Doesn't really have any more features that I'm aware of, just has a > > nice "one stop" interface. > > > > -- > > Bill Moran > > http://www.potentialtech.com > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 6: explain analyze is your friend 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. -- John Fabiani
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 - pg_dump exports the SQL to recreate the sequence, and a setval() to reset it to where it was. Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie ---------------------------------------------------------------