Re: ERROR: relation "table" does not exist - HELP

From: Ragnar Hafstað <gnari(at)simnet(dot)is>
To: itamar <itamar(at)ispbrasil(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: relation "table" does not exist - HELP
Date: 2004-12-11 21:33:21
Message-ID: 1102800801.28021.6.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pablo Santiago Blum de Aguiar 2004-12-11 22:20:06 Re: How to get rid of notices for create table?
Previous Message Ron Peterson 2004-12-11 21:32:36 Re: trouble with on insert rule via libpg-perl