restoring a backup and maintaining dependencies?

Поиск
Список
Период
Сортировка
От Robert Starr
Тема restoring a backup and maintaining dependencies?
Дата
Msg-id 46E8C2E6.204@surrenderdorothy.com.au
обсуждение исходный текст
Ответы Re: restoring a backup and maintaining dependencies?  ("Laurent Yaish" <laurenty@gmail.com>)
Список pgadmin-support
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"
PRIMARYKEY (id)
 
)
WITHOUT OIDS;
ALTER TABLE group_items OWNER TO postgres;


CREATE SEQUENCE group_items_id_seq INCREMENT 1 MINVALUE 1 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


В списке pgadmin-support по дате отправления:

Предыдущее
От: Robert Starr
Дата:
Сообщение: ERROR: duplicate key violates unique constraint "client_alerts_PK"
Следующее
От: "Laurent Yaish"
Дата:
Сообщение: Re: ERROR: duplicate key violates unique constraint "client_alerts_PK"