CSV-Import in postgres
To move data from one dbs to another would be done via a sqldump, but if you are moving to another dbms you will need a csv file, because the sql syntax varies from system to system. So if you need to move from a MS Access database to a postgres database you can use the export function for your MS db and put it into your postgres database via the copy command. you can issue it with psql or any other tool you use to manage your postgres instance (e.g. pgadmin).
the command is like that:
COPY FROM ‘filename on the system where the csv-file is’ (coloumn names in the order in which they appear in the csv-file, ..) WITH DELIMITER ‘e.g. ;’;
You can use the csv option as well for the definition of strings in your csv data. If you are getting problems with the encoding of your text file, you can easily convert it on a linux system with iconv.
# iconv -f -t -o
There is no need for a filename, if the text file comes from stdin. To find out what type of encoding your file already has you can use the command file.
It gives you a hint how the text file is encoded.