Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

is there any PostgreSQL loader like Oracle has?

Tags:

postgresql

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?

like image 988
vchitta Avatar asked Aug 08 '11 15:08

vchitta


People also ask

Can PostgreSQL replace Oracle?

PostgreSQL is by no means a drop-in replacement for Oracle's database, but a developer or DBA that is familiar with Oracle will find PostgreSQL similar.

Is PostgreSQL as good as Oracle?

Overall, PostgreSQL and Oracle are evenly matched in their capabilities, performance, and compatibility. Oracle takes the lead on security, replication, and availability, while PostgreSQL has stronger API compatibility, cheaper support and more robust scalability.

Is PostgreSQL faster than Oracle?

Functionality – Oracle wins It not only provides more transactions per second than PostgreSQL, but also arguably provides higher levels of security.

Is PostgreSQL syntax similar to Oracle?

PostgreSQL's PL/pgSQL language is similar to Oracle's PL/SQL language in many aspects.


2 Answers

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/

like image 63
Scott Marlowe Avatar answered Nov 15 '22 07:11

Scott Marlowe


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.

like image 22
DrColossos Avatar answered Nov 15 '22 09:11

DrColossos