Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Using Quotation marks.


  • From: Erwin Brandstetter <brsaweda(at)gmail(dot)com>
  • To: pgadmin-support(at)postgresql(dot)org
  • Cc: danielgomesmendes(at)gmail(dot)com
  • Subject: Re: Using Quotation marks.
  • Date: Tue, 14 Aug 2007 19:58:49 -0700
  • Message-id: <1187146729(dot)697583(dot)148770(at)q3g2000prf(dot)googlegroups(dot)com>

Hi Daniel!

On Aug 9, 1:01 pm, danielgomesmen(dot)(dot)(dot)(at)gmail(dot)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/static/sql-syntax-lexical.html#SQL-SYNTAX-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/static/sql-keywords-appendix.html

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


Regards
Erwin




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group