Postgres Pro
Downloads
Home   >   mailing lists

use COPY TO on normalized database - Mailing list pgsql-general

From Acm
Subject use COPY TO on normalized database
Date
Msg-id 1189681003.041166.29420@22g2000hsm.googlegroups.com
Whole thread Raw
Responses Re: use COPY TO on normalized database  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: "shakahshakah@gmail.com"
Date:
Subject: Re: Event-driven programming?
Next
From: wild_oscar
Date:
Subject: GRANT on group does not give access to group members