adding a new data to existing psql table from comma del file

Поиск
Список
Период
Сортировка
От sloftus
Тема adding a new data to existing psql table from comma del file
Дата
Msg-id KOEHLEHMMHLJKGNNOCCKCEFICDAA.sgloftus@lbgeographic.com
обсуждение исходный текст
Ответы Re: adding a new data to existing psql table from comma del file  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-novice
Hi,

  can somebody help me, I am trying to update a psql table in my data base.
I created the table from a
comma deliminated file that has four col.

state, city, school, autoID.

the current table. RESCHOOL, has about 300 rows, and is ordered using a
autogenerated sequence which links this table to other tables in the DB.

I need to add some additional schools (about 100),from another cvs file into
the RESCHOOL.

do I use the copy comand that I used to originally used to create this file?
Wont that overwrite my existing table, and mess up my ID's from the
autogenerated number?

any suggestions appreciated.

sgloftus@lbgeographic




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

Предыдущее
От: Mark Edward Smith
Дата:
Сообщение: ERROR: relation "managers" does not exist
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: ERROR: relation "managers" does not exist