Обсуждение: create table like . . . constraint names

Поиск

Список

Период

Сортировка

create table like . . . constraint names

От

"Sahagian, David"

Дата:

24 августа 2012 г., 13:27:47

Is there any way for me to control the name of the (unique or primary) constraints that get created when doing a “create table like parent-table” statement ?

I use this statement to create the new table in a different schema than the one in which the parent-table lives, and I would like the constraint names to be the same as those of the parent-table.

thanks,

-dvs-

Re: create table like . . . constraint names

От

Vincent Veyron

Дата:

26 августа 2012 г., 04:11:32

Le vendredi 24 août 2012 à 09:27 -0400, Sahagian, David a écrit :
> Is there any way for me to control the name of the (unique or primary)
> constraints that get created when doing a “create table like
> parent-table” statement ?

I suppose that you use 'INCLUDING CONSTRAINTS' in your LIKE clause,
since constraints are copied?

You can drop the constraint and re-create it with the name you want :

http://www.postgresql.org/docs/9.1/static/sql-altertable.html


--
Vincent Veyron
http://vincentveyron.com/
Gestion informatique des sinistres d'assurances et des dossiers contentieux pour le service juridique

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: create table like . . . constraint names

create table like . . . constraint names

Re: create table like . . . constraint names