use COPY TO on normalized database

From: Acm <alextabone(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: use COPY TO on normalized database
Date: 2007-09-13 10:56:43
Message-ID: 1189681003.041166.29420@22g2000hsm.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kai Behncke 2007-09-13 11:06:11 Re: UPDATE pg_catalog.pg_class as NO Superuser??
Previous Message hubert depesz lubaczewski 2007-09-13 10:25:51 Re: UPDATE pg_catalog.pg_class as NO Superuser??