SEO

#1 (**permalink**) 04-17-2008, 08:05 PM

Hello,

I am using postgres installed in two different computers, in one I
have to do the queries using quotation marks (select * from "Table")
and in the other I can do select * from Table.
What can I do to disable the use of quotation marks?

Thanks
Daniel Gomes Mendes

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

#2 (**permalink**) 04-17-2008, 08:05 PM

Hi Daniel!

On Aug 9, 1:01 pm, danielgomesmen...@gmail.com ("Daniel Mendes")
wrote:
(...)
> I am using postgres installed in two different computers, in one I
> have to do the queries using quotation marks (select * from "Table")
> and in the other I can do select * from Table.
> What can I do to disable the use of quotation marks?

Without double-quotes identifiers are always cast to lower case before
execution. You might want to read this chapter of the docs on
identifiers and keywords:
http://www.postgresql.org/docs/8.2/s...AX-IDENTIFIERS

Also, you'd better not use reserved words as identifiers. If you do,
you have to double-quote those every time.
http://www.postgresql.org/docs/8.2/s...-appendix.html

In any case, this is probably not the right list for your questions.
Try <pgsql.general> or <pgsql.novice>.

Regards
Erwin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Using Quotation marks.