| 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: | 2007-08-15 02:58:49 |
| Message-ID: | 1187146729.697583.148770@q3g2000prf.googlegroups.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Derrick Betts | 2007-08-15 15:13:18 | Login Error Beta 3 |
| Previous Message | Stephen Denne | 2007-08-14 22:20:56 | Re: pgAdmin III v1.8.0 Beta 3 released |