Re: Problems on "copy" statement

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