Importing ASCII and Binary Data Using COPYAlthough 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:
|