The psql utility will do that for you. You can specify the field and record separator on the command line.
You can prefix your data with the COPY command and it will get slurped right into the database. Note that the default value for null columns is \N, but you can specify a different value as part of the COPY command. See this for more details: http://www.postgresql.org/docs/8.1/static/sql-copy.html Don On Jun 13, 2006, at 11:44 AM, keukaman wrote: > > I'd like to import several thousand records, in CSV format, into an > existing postgres table. Does anyone know a utility that would > allow me > to do this? > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---
