Received: from ns.infoset.cz (ns.infoset.cz [194.213.32.210]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA02251; Sun, 17 Oct 1999 15:59:31 -0400 (EDT) (envelope-from dpeder@infoset.cz) Received: from WinProxy.anywhere ([62.168.15.178]) by ns.infoset.cz (8.8.7/8.8.7) with SMTP id WAA10314; Sun, 17 Oct 1999 22:02:00 +0200 Received: from 192.168.1.1 by 192.168.1.3 (WinProxy); Sun, 17 Oct 1999 22:00:56 +0100 Received: by Dan with Microsoft Mail id <01BF18EA.81DB25A0@Dan>; Sun, 17 Oct 1999 21:56:46 +0100 Message-ID: <01BF18EA.81DB25A0@Dan> From: =?iso-8859-2?Q?Daniel_P=E9der?= To: "'pgsql-hackers@postgresql.org'" , "'pgsql-sql@postgresql.org'" Subject: insertable views - not copy-able ? Date: Sun, 17 Oct 1999 21:56:45 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id QAB02577 what about this: ( it would be nice to have it working, specially for copying values from files into table with default fields, having the default fields doing their job or initialising tables using reduced set of columns ) mydb=> create sequence MYSEQ; CREATE mydb=> create table MYTAB ( ID int4 default nextval('MYSEQ'), NAME text ); CREATE mydb=> create view MYVIEW as select name from MYTAB; CREATE mydb=> copy MYVIEW from stdin; Enter info followed by a newline End with a backslash and a period on a line by itself. >> jim >> john >> jack >> \. mydb=> select MYVIEW.*; name ---- (0 rows) -- dan peder dpeder@infoset.cz