I guess this is a feature request since I can't figure out a way to do it directly in postgresql (plus COPY/\copy isn't in SQL specs). Often when I import data I need to assign foreign key id's, timestamps, etc. How about a syntax something like:
\copy tablename (col1, col2, col3, fkid=8, ts1='2004-8-8') from 'data.csv' or maybe add a defaults clause after "with": \copy tablename (col1, col2, col3) from 'data.csv' with defaults (fkid=8,ts1='2004-8-8') Or if anybody knows of a better/existing way please feel free. :) CSN __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
