create table liek view

From: Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: create table liek view
Date: 2007-08-07 13:23:47
Message-ID: 92869e660708070623q63786928vabce2e8143ceefca@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

filip(at)filip=# create view v as select 1::int;
CREATE VIEW
filip(at)filip=# select * from v;
int4
------
1
(1 row)
filip(at)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ranieri Mazili 2007-08-07 13:41:03 Restricting columns by users
Previous Message Rajaram J 2007-08-07 13:20:14 Having trouble building 64-bit pgsql 7.4.17 on HPUX ia64