Export PostgreSQL database table data to spreadsheet

Submitted by عمرو نصر on Fri, 11/09/2018 - 16:32

In this tutorial I’ll show you the easiest way to export PostgtreSQL table data to CSV format on an external file (The CSV format is potable and can be used across multiple applications especially spreadsheet applications like Excel, LibreOffice Calc) using PostgtreSQL SQL COPY command.

Steps followed by this tutorial are

Importing data from spreadsheet (Excel, LibreOffice Calc, CSV) file into PostgreSQL database table.

Submitted by عمرو نصر on Mon, 11/05/2018 - 11:21

In this tutorial we will import data from spreadsheet (Excel, LibreOffice Calc) file into PostgreSQL database table using PostgtreSQL SQL COPY command.

Steps followed by this tutorial are