On 01/07/2011 08:26 AM, gvim wrote:
On 07/01/2011 15:58, Adrian Klaver wrote:
Details below. When you dump a specific table using -t it will not
automatically dump dependent objects. -t can be used to dump a
sequence because
they are just a special type of table.
From:
http://www.postgresql.or
On January 7, 2011, gvim wrote:
> PostgreSQL 9.0.1/pgAdminIII 1.12.1
>
> I want to copy selected tables from one database to another and maintain
> the sequences which I originally setup with:
>
> CREATE SEQUENCE venues_id_seq START WITH 1122;
> ALTER TABLE venues ALTER COLUMN id SET DEFAULT nex
On Friday 07 January 2011 7:46:31 am gvim wrote:
> PostgreSQL 9.0.1/pgAdminIII 1.12.1
>
> I want to copy selected tables from one database to another and maintain
> the sequences which I originally setup with:
>
> CREATE SEQUENCE venues_id_seq START WITH 1122;
> ALTER TABLE venues ALTER COLUMN id S
PostgreSQL 9.0.1/pgAdminIII 1.12.1
I want to copy selected tables from one database to another and maintain the
sequences which I originally setup with:
CREATE SEQUENCE venues_id_seq START WITH 1122;
ALTER TABLE venues ALTER COLUMN id SET DEFAULT nextval('venues_id_seq');
... along with their
