Re: Problems on "copy" statement

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Keith Worthington <keithw(at)narrowpathinc(dot)com>
Cc: lap01(at)netvigator(dot)com, pgsql-novice(at)postgresql(dot)org
Subject: Re: Problems on "copy" statement
Date: 2005-04-13 15:34:42
Message-ID: 20050413153442.GA91370@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2005-04-13 15:50:01 Re: [despammed] Serial data type
Previous Message Walker, Jed S 2005-04-13 15:30:09 Serial data type