Importing ASCII and Binary Data Using COPY

Importing ASCII and Binary Data Using COPY

Although it is only covered in a few pages in most books, importing data in various formats into your database is an extremely difficult task for a database administrator, because the data in a database doesn't usually come from nowhere. The way data has to be inserted into your PostgreSQL server can differ , depending on the type and the amount of data you have to process.

The easiest case is to have a file that contains the output of a pg_dump command. Importing will be an easy task, because you only have to create a database and insert the data with a simple shell command:

This is only a preview

This is only a preview of the full book. From here, you may:

• Login.
• Try it FREE for 14 days.
• Subscribe.
• You can continue your free preview of this book or return to search results.