create table liek view - Mailing list pgsql-general

From Filip Rembiałkowski
Subject create table liek view
Date
Msg-id 92869e660708070623q63786928vabce2e8143ceefca@mail.gmail.com
Whole thread Raw
Responses Re: create table liek view
List pgsql-general
filip@filip=# create view v as select 1::int;
CREATE VIEW
filip@filip=# select * from v;
 int4
------
    1
(1 row)
filip@filip=# create table t ( like v);
ERROR:  inherited relation "v" is not a table



Why? Is there any logical reason for this? View is just a table with
some rule ON SELECT...



--
Filip Rembiałkowski

pgsql-general by date:

Previous
From: "Rajaram J"
Date:
Subject: Having trouble building 64-bit pgsql 7.4.17 on HPUX ia64
Next
From: Ranieri Mazili
Date:
Subject: Restricting columns by users