Ok, now I understand
>CREATE TABLE "fooBARbaz" (foo TEXT);
CREATE TABLE
> \dt
...
---------+---------------+--------+----------
public | A weird" name | tabela | postgres
public | fooBARbaz | tabela | postgres
...
> \dt fooBARbaz
No relation found
> \dt foo"BAR"baz
...
---------+-----------+--------+----------
public | fooBARbaz | table | postgres
(1 row)
Thanks,
Halley
--- Tom Lane <tgl@sss.pgh.pa.us> escreveu:
> Halley Pacheco de Oliveira <halleypo@yahoo.com.br> writes:
> > 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.
>
> Please observe the context in which that statement appears: it is
> talking about backslash commands only.
>
> For the syntax of SQL commands see
> http://www.postgresql.org/docs/8.0/static/sql-syntax.html
>
> regards, tom lane
>
__________________________________________________
Converse com seus amigos em tempo real com o Yahoo! Messenger
http://br.download.yahoo.com/messenger/