Hi all, It seems that the only "quoted" types are :
SET any bit char interval numeric time timestamp trigger unknown varchar that makes any sense for anyone ? Other types, like int2, int4, date, text, etc don't get quotes. Diego. El jue, 09-09-2004 a las 17:29, RaphaÃl Enrici escribiÃ: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
