Problems on "copy" statement

Поиск
Список
Период
Сортировка
От Leung Wing Lap Ellery
Тема Problems on "copy" statement
Дата
Msg-id 425D2CB1.4050901@netvigator.com
обсуждение исходный текст
Ответы Re: Problems on "copy" statement  ("Keith Worthington" <keithw@narrowpathinc.com>)
Список pgsql-novice
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
Дата:
Сообщение: Update from a subquery using where to match entries between tables
Следующее
От: "Keith Worthington"
Дата:
Сообщение: Re: Problems on "copy" statement