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 - [[EMAIL PROTECTED]]
Daemon News Magazine in your snail-mail! http://magazine.daemonnews.org/
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly