| From: | "Vladimir V(dot) Zolotych" <gsmith(at)eurocom(dot)od(dot)ua> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | all columns but one |
| Date: | 2000-12-31 10:14:42 |
| Message-ID: | 3A4F0712.EA1D88B8@eurocom.od.ua |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)eurocom(dot)od(dot)ua
| Attachment | Content-Type | Size |
|---|---|---|
| gsmith.vcf | text/x-vcard | 167 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lockhurst | 2001-01-01 01:43:47 | Re: Redundant databases/real-time backup-Revisited |
| Previous Message | Tom Lane | 2000-12-30 04:31:36 | Re: Error opening pgaccess |