How to add a CSV file to the PostgreSQL column using pgAdmin? With our PostgreSQL Support Services, Bobcares offers a solution to this question for you.

How to add a CSV file to the PostgreSQL column using pgAdmin?

Before using PgAdmin to import the CSV file into PostgreSQL, there are two approaches to converting it into a format that is compatible with PostgreSQL databases. Let’s look into the approaches in detail.

1. By generating a pgAdmin table compatible with the CSV file

We’ve to run the below steps to import CSV using this PgAdmin Import CSV method:

1. At the top of the PgAdmin home page, click the Tools tab.

2. From the drop-down menu that opens, choose Query Tool.

3. The CSV file’s title and columns should be entered as a SQL Query. Let’s look into an example.

The CSV file with the filename ‘ employees.csv’ looks like this:

First Name, Last Name, id

1, George, Sullivan, 123

2, Clara, Johns, 435

3, Paul, Thomas, 251

The SQL Query for the PgAdmin table will look like this: CREATE TABLE employees (serial_no serial, first_name George, last_name Sullivan, id 123 );

4. After the import process, the CSV file will appear as a table in the PgAdmin table list. Hit on the File tab at the top of the page to find the table.

2. By writing an SQL Query pointing to the CSV reference path

We’ve to run the below steps to import CSV using this method:

1. The ‘Tools’ tab at the top of your screen can be clicked to access the Internal Query tool.

2. Create the SQL query. The SQL Query would look like this for the CSV file “employee.csv”:

COPY employeesprocess of PgAdmin Import CSV into PostgreSQL, you must first convert the file into a compatible format for PostgreSQL databases. There are two ways to convert the CSV file into a compatible format for PostgreSQL databases before importing FROM ‘C: aemployees.csv

DELIMITER ‘,’

CSV Header;

In the above query, the ‘employees’ entry after copy refers to the CSV filename. The entry written after FROM is the CSV file path.  The comma that divides the fields in the CSV file is referred to as DELIMITER. When importing the CSV file, the CSV Header directs the query to ignore the header.

3. At the top of the page, select the Query Editor tab. We’ll see the newly produced SQL Query.

4. To see your results, tap Messages next.

5. Now, we’ll see the below message as the sample CSV file we used has 3 columns.

COPY 3

Finally, we need to verify that the query was successful after using the selected method to import the CSV file. We must use the Query tool to input the following query to accomplish this:

SELECT * FROM students

Click the Query Editor tab to confirm this PgAdmin Import CSV technique. Tap Data Output in the Query Editor. If the CSV file appears in a tabular format, the query was successful. This is how you can insert data by providing a file path using the PgAdmin Import CSV option.

[Need help with another issue? We’re available 24/7.]

Conclusion

To sum up, our Tech team provides two methods to add a CSV file to the PostgreSQL column using pgAdmin in this article.