Re: Problems on "copy" statement

Thanks for your reply.

Run the sql:

SELECT schemaname, tablename
FROM pg_tables
WHERE tablename ILIKE '%hsi%';


get:

schemaname     tablename

public



HSI


when run the sql:

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


error:

ERROR:  relation "public.hsi" does not exist



er...did I do something silly? What is the problem?

Thanks in advance.

Ellery Leung


Michael Fuhr wrote:

>On Wed, Apr 13, 2005 at 10:38:02AM -0400, Keith Worthington wrote:
>
>
>>On Wed, 13 Apr 2005 22:29:05 +0800, Leung Wing Lap Ellery wrote
>>
>>
>>>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.
>>
>>
>
>Another possibility is that the table name is mixed-case -- if so,
>then it'll have to be quoted.
>
>http://www.postgresql.org/docs/8.0/interactive/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
>
>What's the result of the following query?
>
>SELECT schemaname, tablename
>FROM pg_tables
>WHERE tablename ILIKE '%hsi%';
>
>
>