public inbox for [email protected]  

help / color / mirror / Atom feed

From: Halley Pacheco de Oliveira <[email protected]>
To: [email protected]
Subject: PostgreSQL 7.4 and 8.0 - psql reference
Date: Sun, 12 Jun 2005 07:42:58 -0300 (ART)
Message-ID: <[email protected]> (raw)

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

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: PostgreSQL 7.4 and 8.0 - psql reference
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox