| From: | Halley Pacheco de Oliveira <halleypo(at)yahoo(dot)com(dot)br> |
|---|---|
| To: | pgsql-docs(at)postgresql(dot)org |
| Subject: | PostgreSQL 7.4 and 8.0 - psql reference |
| Date: | 2005-06-12 10:42:58 |
| Message-ID: | 20050612104259.58872.qmail@web52706.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
In Part II - PostgreSQL Client Applications, psql -- PostgreSQL interactive terminal
(psql-ref.sgml - http://www.postgresql.org/docs/8.0/interactive/app-psql.html) is written:
For example, FOO"BAR"BAZ is interpreted as fooBARbaz, and "A weird"" name" becomes A weird" name.
So using psql I tried:
CREATE TABLE FOO"BAR"BAZ (foo text);
and got:
ERROR: syntax error at or near ""BAR"" at character 17
AND
> CREATE TABLE "A weird"" name" (foo text);
CREATE TABLE
> \dt
...
---------+---------------+--------+----------
public | A weird" name | table | postgres
So what is happening with FOO"BAR"BAZ? What is really written in the documentation?
Thanks,
Halley
____________________________________________________
Yahoo! Mail, cada vez melhor: agora com 1GB de espaço grátis! http://mail.yahoo.com.br
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Halley Pacheco de Oliveira | 2005-06-12 11:07:33 | Chapter 44. Native Language Support |
| Previous Message | Peter Eisentraut | 2005-06-10 17:27:53 | Re: Generate Windows MO files in Linux |