Re: exporting postgre data - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: exporting postgre data
Date
Msg-id 479A4990.2040309@iol.ie
Whole thread Raw
In response to Re: exporting postgre data  (johnf <jfabiani@yolo.com>)
List pgsql-general
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
---------------------------------------------------------------

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Only a week left for PostgreSQL Conference talk submissions
Next
From: Raymond O'Donnell
Date:
Subject: Re: shouldn't all tables have Object Descriptions?