Skip site navigation (1) Skip section navigation (2)

PostgreSQL 7.4 and 8.0 - psql reference

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 (view raw or flat)
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

Responses

pgsql-docs by date

Next:From: Halley Pacheco de OliveiraDate: 2005-06-12 11:07:33
Subject: Chapter 44. Native Language Support
Previous:From: Peter EisentrautDate: 2005-06-10 17:27:53
Subject: Re: Generate Windows MO files in Linux

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group