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