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

create foreign key without checking

From: "Ewald Geschwinde" <egeschwinde(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: create foreign key without checking
Date: 2007-10-25 11:15:43
Message-ID: cf42ed390710250415x7983bbceg79b5ea7df9f31c99@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Is there a way to make inserts int the systemtables to create a foreign key
without checks

I have archive tables to put in the database - and then data will be
inserted afterwards to that table
I want to switch off foreign keys for the import and activate them after the
import but without checking

The data matches the foreign keys which I import

Is this possible?


-- 
Ewald Geschwinde

pgsql-admin by date

Next:From: Adam RadlowskiDate: 2007-10-25 12:09:28
Subject: sending data with COPY SQL command, libpq and structure of SELECT resulting buffer
Previous:From: Vishal AroraDate: 2007-10-25 07:37:12
Subject: Postgres SQL Client for Suse Linux

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