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
>
>