Search Postgresql Archives

Re: exporting postgre data

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, 25 Jan 2008 10:02:41 -0500
Bill Moran <wmoran@xxxxxxxxxxxxxxxxx> wrote:

> > > From: pgsql-general-owner@xxxxxxxxxxxxxx
> > > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of User
> > > Map Sent: Friday, January 25, 2008 10:18 AM
> > > To: pgsql
> > > Subject:  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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux