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