Import Export data from PostgreSQL to excel CSV file | Pgadmin import export to excel CSV file | Export query results to excel CSV file Postgre SQL | PSQL COPY CSV file | Data in Excel to PostgreSQL

How to export the PostgreSQL data into excel? How to use pgadmin 3 and pgadmin 4 export query results to excel ?

Using PgAdmin console we can export data from postgresql to excel. In PgAdmin export option is available in file menu. This export option allows the user to export output from a query to excel. Execute the query, and then we can view the data in the Output pane.

In PgAdmin 4 simply press F8 button to export the data to excel CSV file or click on download button provided in application.

How to import from CSV in postgreSQL? | PgAdmin import from CSV | PSQL COPY CSV | How to import data from excel to postgreSQL

Here we will discuss various methods to import CSV / excel in postgresql. We can import the data into PostgreSQL using PgAdmin and PSQL. In PgAdmin we can import the data using option provided.

PgAdmin import from CSV file | Import data from excel to postgresql using PgAdmin 4

Using PgAdmin import CSV file into a new table or existing table as per our requirement. Here we will explain how to import csv into newly created table in a database using pgadmin4 import csv option. Create table using the below mentioned postgresql create table script.

CREATE TABLE noviceusers
(
	id       SERIAL,
	code     CHARACTER VARYING (25),
	name     CHARACTER VARYING (250),
	PRIMARY KEY (id)
);

Prepare a CSV data file using the excel with the following format to import from csv using PgAdmin 4.

Open the import option by right click on the table and select Import/Export.

Select option "Import", then select the CSV / excel file. The path of CSV file is located in the "C" drive. Use the browse button to select the CSV file to import. Then change the format type to CSV. If you are given the header in the CSV file, then select the header as "Yes".

In the Columns tab, we can see the columns of the table to import, remove the id column, because it is given is serial type and in the CSV file data for id column not given. Then click the OK button. Data will be imported to the PostgreSQL table.

Pgadmin Import from CSV data into a table using the PSQL command COPY statement

Another provision for importing CSV to the PostgreSQL table is PSQL command COPY Statement. To Import CSV data file into noviceusers table, use copy statement as follows

COPY noviceusers(code, name) FROM 'C:\noviceusers.csv' DELIMITER ',' CSV HEADER;

After successful import of data, psql console gives this message. It means 3 rows imported to the post gre sql noviceusers table.

COPY 3

How to use pgadmin 3 export query results to excel ?

Click on the menu FILE -> EXPORT from query window.

You can see the below displayed image. Give file name and path to save file. The data will be exported to desired path.

It is a simple method to export the data to excel using the GUI in PostgreSQL.

Please visit other related articles

PostgreSQL: How to Create PostgreSQL Index and Postgres Create Index examples

PostgreSQL: Postgres list tables using PSQL

PostgreSQL: How to convert PostgreSQL multiple rows to json

PostgreSQL: Script to drop foreign keys in a table
PostgreSQL: Script to List Functions in PostgreSQL DB

PostgreSQL: List table details using Alt+F1 in PostgreSQL
PostgreSQL: How to display full PostgreSQL function code

PostgreSQL: Add macros in PgAdminIII
PostgreSQL: Export PostgreSQL data in to excel file
PostgreSQL: How to restrict the user access to the databases in Postgresql based on the permission
PostgreSQL: List table details using Alt+F1 in PostgreSQL
PostgreSQL: How to get ROW_COUNT of last executed query in PostgreSQL like MS SQL @@ROWCOUNT ?