Re: Dynamic constraint names in ALTER TABLE

2011/9/19 Ondrej Ivanič <ondrej(dot)ivanic(at)gmail(dot)com>:
> Hi,
>
> On 20 September 2011 13:09, patrick keshishian <pkeshish(at)gmail(dot)com> wrote:
>> e.g., ALTER TABLE sales DROP CONSTRAINT (SELECT conname FROM
>> pg_constraint JOIN pg_class ON (conrelid=pg_class.oid) WHERE
>> pg_class.relname='sales' AND conkey[1] = 1 AND contype='f') ;
>
> You have to build query in different way:
>
> psql ... -A -t -c "SELECT 'ALTER TABLE sales DROP CONSTRAINT ' ||
> conname || ';' FROM pg_constraint JOIN pg_class ON
> (conrelid=pg_class.oid) WHERE pg_class.relname='sales' AND conkey[1] =
> 1 AND contype='f'"
>
> Finally, you can save it in to file or pipe it to another psql:
> psql ... -A -t -c '....' | psql ...

this is no different than my save to a file (\o) and read it back (\i) way.

--patrick