Acm wrote:
I am working with PostgreSQL 8.2.4.
I need to use the SQL COPY (COPY table FROM file) statement to
populate my database.
I have created a normalized data model (up to 3NF). Is it possible to
use COPY TO on a particular table (that is linked to other tables
using foreign keys) whilst keeping the foreign keys and other tables
updated?
(Also, will de-normalizing the model to 2NF or 1NF help?)
Thank you.
Use copy...from to load your data into a temp table. Then, do your data
manipulation in the database using insert into .... or other statements
to get data into the "real" 3NF tables. If you do all of this within a
transaction, if anything breaks, you can rollback and have no problems
with data integrity.
Sean
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
