Re: Problems on "copy" statement

How about

COPY "HSI" from 'c:\java\hsi.txt'

You need the double quote to get the capitalization. I generally use
all lower-case so I don't have to think about it.

Sean

On Apr 13, 2005, at 12:24 PM, Leung Wing Lap Ellery wrote:

> 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%';
>>
>>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org