Is there a reason for the following behavior? nconway=# create table a (col1 int); CREATE TABLE nconway=# insert into a default values; INSERT 1883513 1 nconway=# copy a to '/tmp/output'; COPY nconway=# create view myview as select * from a; CREATE VIEW nconway=# copy myview to '/tmp/output'; ERROR: You cannot copy view myview
I can understand not allowing COPY FROM to target a view (or at least, a view without an insertion rule defined) -- but is there a similar reason for disallowing copying data out of a view? Cheers, Neil -- Neil Conway <[EMAIL PROTECTED]> PGP Key ID: DB3C29FC ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
