X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9AABC52839 for ; Sun, 12 Jun 2005 12:50:34 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 00934-07 for ; Sun, 12 Jun 2005 15:50:25 +0000 (GMT) Received: from web52710.mail.yahoo.com (web52710.mail.yahoo.com [206.190.39.161]) by svr1.postgresql.org (Postfix) with SMTP id DE90E5280B for ; Sun, 12 Jun 2005 12:50:24 -0300 (ADT) Received: (qmail 2983 invoked by uid 60001); 12 Jun 2005 15:50:23 -0000 Message-ID: <20050612155023.2981.qmail@web52710.mail.yahoo.com> Received: from [201.8.95.86] by web52710.mail.yahoo.com via HTTP; Sun, 12 Jun 2005 12:50:22 ART Date: Sun, 12 Jun 2005 12:50:22 -0300 (ART) From: Halley Pacheco de Oliveira Subject: Re: PostgreSQL 7.4 and 8.0 - psql reference To: Tom Lane Cc: pgsql-docs@postgresql.org In-Reply-To: <23945.1118589038@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.608 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200506/21 X-Sequence-Number: 3114 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 escreveu: > Halley Pacheco de Oliveira 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/