It would be very helpful if the COPY command could be expanded
in order to provide positional parameters.
I noticed that it didn't a while back and it can really hurt
someone when they happen to try to use pg_dump to move data
from one database to another database and they happened to
create the feilds in the tables in different orders.
Basically:
COPY "webmaster" FROM stdin;
could become:
COPY "webmaster" FIELDS "id", "name", "ssn" FROM stdin;
this way when sourcing it would know where to place the
feilds.
--
-Alfred Perlstein - [alfred(at)freebsd(dot)org]
Daemon News Magazine in your snail-mail! http://magazine.daemonnews.org/