Re: exporting postgre data

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
---------------------------------------------------------------