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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
