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%';
>
>
>