2011/9/19 Ondrej Ivanič <[email protected]>: > Hi, > > On 20 September 2011 13:09, patrick keshishian <[email protected]> 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 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
