Re: Problems on "copy" statement

Поиск
Список
Период
Сортировка
Искать
От
Keith Worthington
Тема
Re: Problems on "copy" statement
Дата
Msg-id
20050413143437.M36677@narrowpathinc.com
Ответ на
Problems on "copy" statement (Leung Wing Lap Ellery)
Список
Дерево обсуждения
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> 
On Wed, 13 Apr 2005 22:29:05 +0800, Leung Wing Lap Ellery wrote
> 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'

It seems to me that it cannot find the table.  Try schema qualifying the
tablename.

COPY myschema.hsi FROM 'c:\java\hsi.txt';

http://www.postgresql.org/docs/8.0/interactive/sql-copy.html

Kind Regards,
Keith
В списке pgsql-novice по дате отправления
Предыдущее
От: Leung Wing Lap Ellery
Дата:
Сообщение: Problems on "copy" statement
Следующее
От: sqlpython
Дата:
Сообщение:
FAQ