public inbox for [email protected]  

help / color / mirror / Atom feed

PostgreSQL 7.4 and 8.0 - psql reference
3+ messages / 2 participants
[nested] [flat]

* PostgreSQL 7.4 and 8.0 - psql reference
@ 2005-06-12 10:42  Halley Pacheco de Oliveira <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Halley Pacheco de Oliveira @ 2005-06-12 10:42 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: PostgreSQL 7.4 and 8.0 - psql reference
@ 2005-06-12 15:10  Tom Lane <[email protected]>
  parent: Halley Pacheco de Oliveira <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2005-06-12 15:10 UTC (permalink / raw)
  To: Halley Pacheco de Oliveira <[email protected]>; +Cc: pgsql-docs

Halley Pacheco de Oliveira <[email protected]> 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: PostgreSQL 7.4 and 8.0 - psql reference
@ 2005-06-12 15:50  Halley Pacheco de Oliveira <[email protected]>
  parent: Tom Lane <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Halley Pacheco de Oliveira @ 2005-06-12 15:50 UTC (permalink / raw)
  To: Tom Lane <[email protected]>; +Cc: pgsql-docs

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 <[email protected]> escreveu:

> Halley Pacheco de Oliveira <[email protected]> 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/ 




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2005-06-12 15:50 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-06-12 10:42 PostgreSQL 7.4 and 8.0 - psql reference Halley Pacheco de Oliveira <[email protected]>
2005-06-12 15:10 ` Tom Lane <[email protected]>
2005-06-12 15:50   ` Halley Pacheco de Oliveira <[email protected]>

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