Re: Problems on "copy" statement

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/