all columns but one - Mailing list pgsql-admin

From Vladimir V. Zolotych
Subject all columns but one
Date
Msg-id 3A4F0712.EA1D88B8@eurocom.od.ua
Whole thread Raw
List pgsql-admin
  Hello all,
Happy New Year!

Does anybody know is it possible to tell
"all columns but one" in sentences like the following:

insert into bar (b,c,d,e,f,g,h) select (b, c,d,e,f,g,h) from foo;

where foo, bar contains the same set of columns just as mentioned
above plus column a, e.g. the full set of columns is: a,b,c,d,e,f,g,h

Thanks!

--
Vladimir Zolotych                         gsmith@eurocom.od.ua

Attachment

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error opening pgaccess
Next
From: Lockhurst
Date:
Subject: Re: Redundant databases/real-time backup-Revisited