Skip site navigation (1) Skip section navigation (2)

Re: restoring a backup and maintaining dependencies?

From: "Laurent Yaish" <laurenty(at)gmail(dot)com>
To: "Robert Starr" <rob(at)surrenderdorothy(dot)com(dot)au>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: restoring a backup and maintaining dependencies?
Date: 2007-09-13 05:51:37
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
There is no difference between running this script and using the
pgadmin gui. pgadmin is just a front end to the database, it generates
the same sql that you would write manually.

If your table is group_items, name your sequence group_items_seq


On 9/12/07, Robert Starr <rob(at)surrenderdorothy(dot)com(dot)au> wrote:
> Hi again :)
> I have saved out these commands:
> CREATE TABLE group_items
> (
>   id serial NOT NULL,
>   group_id integer,
>   group_type text,
>   item_id integer,
>   visible integer,
>   CONSTRAINT "group_items_PK" PRIMARY KEY (id)
> )
> ALTER TABLE group_items OWNER TO postgres;
> CREATE SEQUENCE group_items_id_seq
>   MAXVALUE 9223372036854775807
>   START 1
>   CACHE 1;
> ALTER TABLE group_items_id_seq OWNER TO postgres;
> If I restore them in pgadmin will they become dependent on each other in
> the same way as if I created the table in pgadmin?  Or will they just
> become separate entities without any form of link?  If that IS the case,
> how can I link them with SQL code, rather than pgadmin?
> Advice appreciated lots, I have a lot to learn here :|
> rob
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

In response to


pgadmin-support by date

Next:From: Robert StarrDate: 2007-09-13 06:01:09
Subject: Re: restoring a backup and maintaining dependencies?
Previous:From: Laurent YaishDate: 2007-09-13 05:48:23
Subject: Re: ERROR: duplicate key violates unique constraint "client_alerts_PK"

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group