Jump to Navigation

postgres

How to import and export csv files with Postgresql

Importing and exporting data and csv files from a database are two fundamental tasks that developers and database administrators need to performed on a regular basis. The PGAdmin tool that is used to graphically administer postgresql databases does not have this functionality build in. Postgresql, however does make provision for this. There are two ways to copy csv files to and from postgresql databases. You can use the SQL "copy" statement or you can use the psql "\copy" command.

Open Source: 

Database Support - MySQL, Postgres Open Office Base

Databases are the mainstay of any business critical system today. They enable the central storage and retrieval of transactional information for many business processes and allow for the advanced reporting of management information. Key to any business system then is the database platform used and the database design for your applications.

Open Source: 
Subscribe to RSS - postgres


by Dr. Radut.