use COPY TO on normalized database

Поиск
Список
Период
Сортировка
От Acm
Тема use COPY TO on normalized database
Дата
Msg-id 1189681003.041166.29420@22g2000hsm.googlegroups.com
обсуждение исходный текст
Ответы Re: use COPY TO on normalized database  (Sean Davis <sdavis2@mail.nih.gov>)
Список 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.


В списке pgsql-general по дате отправления:

Предыдущее
От: "shakahshakah@gmail.com"
Дата:
Сообщение: Re: Event-driven programming?
Следующее
От: wild_oscar
Дата:
Сообщение: GRANT on group does not give access to group members