I was having a bunch of trouble today importing my old MySQL amarok database into the new nightly version of amarok I installed. The Amarok Wiki had a great section on how to convert a MySQL Amarok collection into an SQLlite one. This was the key to importing my old 1.4 collection into the new 2.2 nightly version of Amarok.
Postgres has the same type of ability MySQL has to read in files, yet much nicer syntax.
LOAD DATA INFILE from MySQL is just
COPY in postgres. I decided to try having it read from a named pipe today, and it worked out nicely.