Re: " keywords... Is it normal ?

Raphaël Enrici wrote:
> Raphaël Enrici wrote:
>
>> Hi,
>>
>> just noticed something I was not used to see. Is it normal that some
>> postgre keywords are quoted ?
>> http://www.enrici.com/pgadmin/SCREENSHOTS/Scr-1.1.0.20040908.png
>>
>
> Note that it gives me a sql source which is unusable in the query
> window... Example:
Sorry to insist... but I was not clear enough.

Here is my original sql source:

-- Table: pages

DROP TABLE pages;

CREATE TABLE pages
(
page varchar(50) NOT NULL DEFAULT '',
content bytea NOT NULL,
changetime timestamp NOT NULL
)
WITH OIDS;
GRANT ALL ON TABLE pages TO ralph WITH GRANT OPTION;
GRANT ALL ON TABLE pages TO GROUP "www-data";

I run it in the query window and then look at it in the schema browser
and re-open it in the query window... it gives the following source
which is unusable:
-- Table: pages

-- DROP TABLE pages;

CREATE TABLE pages
(
page "varchar"(50) NOT NULL DEFAULT ''::character varying,
content bytea NOT NULL,
changetime "timestamp" NOT NULL
)
WITH OIDS;
GRANT ALL ON TABLE pages TO ralph WITH GRANT OPTION;
GRANT ALL ON TABLE pages TO GROUP "\""www-data\""";

Known one ?

Regards,
Raphaël