is there any PostgreSQL loader like Oracle has?

Question

how to use copy statement in postgresql to load data from a text file where the file has an escape character as a delimiter into a postgresql table?

Is there any otherway of loading data from textfile into a PostgreSQL table?

Answer 1

pg loader emulates oracles sql loader:

http://pgfoundry.org/projects/pgloader/

pg bulkload is used to load lots of data in an otherwise offline db. Useful for large data warehouses, fast, and somewhat dangerous and quirky:

http://pgbulkload.projects.postgresql.org/

Answer 2

You should use COPY with the DELIMITER 'xx' option. You probably need to play around a little bit to get it right, but the docs give a pretty good information about what to do with each option available to the command.