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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
