Problems on "copy" statement

Поиск
Список
Период
Сортировка
Искать
От
Leung Wing Lap Ellery
Тема
Problems on "copy" statement
Дата
Msg-id
425D2CB1.4050901@netvigator.com
Список
Дерево обсуждения
Problems on "copy" statement Leung Wing Lap Ellery <lap01@netvigator.com>
Re: Problems on "copy" statement "Keith Worthington" <keithw@narrowpathinc.com>
Re: Problems on "copy" statement Michael Fuhr <mike@fuhr.org>
Re: Problems on "copy" statement "Keith Worthington" <keithw@narrowpathinc.com>
Re: Problems on "copy" statement Michael Fuhr <mike@fuhr.org>
Re: Problems on "copy" statement Andrew Hammond <ahammond@ca.afilias.info>
Re: Problems on "copy" statement Leung Wing Lap Ellery <lap01@netvigator.com>
Re: Problems on "copy" statement "Keith Worthington" <keithw@narrowpathinc.com>
Re: Problems on "copy" statement Michael Fuhr <mike@fuhr.org>
Re: Problems on "copy" statement Leung Wing Lap Ellery <lap01@netvigator.com>
Re: Problems on "copy" statement Michael Fuhr <mike@fuhr.org>
Re: Problems on "copy" statement Sean Davis <sdavis2@mail.nih.gov> 
Hi all!

When I want to use "copy" to move data in .csv, which has been formatted
to tab-formatted file, to my postgresql as follow (DB name: test,
tablename: hsi):

copy hsi from 'c:\java\hsi.txt'

it generated error:

ERROR:  relation "hsi" does not exist
copy hsi from 'c:\java\hsi.txt'


if I use double quoted:

copy hsi from "c:\java\hsi.txt"

it generated:

ERROR:  syntax error at or near ""c:\java\hsi.txt"" at character 15


Can anyone please tell me what's wrong with the above statements?

Thanks in advance for your kind help!
В списке pgsql-novice по дате отправления
Предыдущее
От: David Orme
Дата:
Следующее
От: Keith Worthington
Дата:
FAQ