Re: ERROR: relation "table" does not exist - HELP - Mailing list pgsql-general

From Ragnar Hafstað
Subject Re: ERROR: relation "table" does not exist - HELP
Date
Msg-id 1102800801.28021.6.camel@localhost.localdomain
Whole thread Raw
In response to ERROR: relation "table" does not exist - HELP  ("itamar" <itamar@ispbrasil.com.br>)
List pgsql-general
On Sat, 2004-12-11 at 01:54 -0200, itamar wrote:
> when I run
>
> select * from "table"
>
> I get this error.
>
> ERROR:  relation "table" does not exist

The table name is is folded to lowercase, unless it is in quotes.
so if the name of the table is TABLE, you need select * from "TABLE"

Is this your problem ?

gnari



pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Shared disk
Next
From: Ron Peterson
Date:
Subject: Re: trouble with on insert rule via libpg-perl