On Thu, 14 Jun 2001 pgsql-bugs@postgresql.org wrote:
> Basil A. Evseenko (evseenko@msiu.ru) reports a bug with a severity of 3
> The lower the number the more severe it is.
>
> Short Description
> Strange CREATE VIEW behavior??
>
> Long Description
> createdb test
> psql test
>
> test=# create table zz(ss int, ff varchar);
> test=# create view ff2 as select ff as user, ss as num from zz;
> test=# create view ff3 as select ff as user1, ss as num from zz;
> test=# \d ff2
> View "ff2"
> Attribute | Type | Modifier
> -----------+-------------------+----------
> user | character varying |
> num | integer |
> View definition: SELECT zz.ff AS "user", zz.ss AS num FROM zz;
>
> test=# \d ff3
> View "ff3"
> Attribute | Type | Modifier
> -----------+-------------------+----------
> user1 | character varying |
> num | integer |
> View definition: SELECT zz.ff AS user1, zz.ss AS num FROM zz;
>
> Why in the first case column has name "user" (with '"') ?
Probably because user is sometimes reserved. For example:
create table foo(user int); -- fails
create table foo("user" int); -- succeeds