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 -
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
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: [GENE
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
> > 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
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
, 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.
>
>
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
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.
