Re: Re: Rép. : [GENERAL] double quotes around table and - Mailing list pgsql-general

From scott.marlowe
Subject Re: Re: Rép. : [GENERAL] double quotes around table and
Date
Msg-id Pine.LNX.4.33.0211211539240.23898-100000@css120.ihs.com
Whole thread Raw
In response to Re: Rép. : [GENERAL] double quotes around table and column names  ("Gregory Wood" <gregw@com-stock.com>)
List pgsql-general
On Thu, 21 Nov 2002, Gregory Wood wrote:

> > The standard is that an identifier (table name, field name, ...) must be
> > double quoted if it contains any non (letter, digits, underscore)
> > character or if it is case sensitive
>
> Is that the SQL standard you are referring to? Because I use underscores
> extensively without double-quotes with no problems.

I think he's saying if you use something OTHER than a letter, digit or
underscore you have to quote it, like

create table crazyname&*$#% ...

would fail, but

create table "crazyname&*$#%" ...

would work.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL compilation with custom table name length
Next
From: MT
Date:
Subject: sequenc_name.currval not defined