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: [GENERAL] exporting postgre data
> > >
> > >
> > > is it posible
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 computer to the
> > postgres in another computer. I
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
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
>
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