Re: How to run queries without double quotes on tables and columns

If your object (table, column, view etc) have mixed-case names (e.g.
My_Table instead of my_table), you need to quote them. If you have a table
called My_Table but use [SELECT * FROM My_Table;] it won't match as it is
treated as if it is all lower-case unless you quote it. In that case, you'd
have to use [SELECT * FROM "My_Table";]. The same applies to any database
object.
Regards

Thom

2009/10/11 Susan M Farley <sfarley1(at)gmu(dot)edu>

> Sorry, I'm really new to PostgreSQL and am used to Oracle. In function and
> in regular queries, I usually have to have double quotes (") around the
> names of columns and table names. Otherwise, I get an error that the schema,
> table, or column doesn't exist. I don't always have to though. Sometimes the
> function works just fine without them even though I am working with the same
> table and schema. What am I doing wrong?
>
> Thank you,
> Susan
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>