04 Import CSV File To PostgreSQL

CREATE TABLE public."MyData"
(
id integer,
firstname character varying(100),
lastname character varying(100),
gender character varying(50),
companyname character varying(100)
)

COPY public."MyData" FROM 'C:\FILES\TestData.csv' DELIMITER ',' CSV HEADER;

In this video (Import CSV File To PostgreSQL) we are going to learn how to create a new PostgreSQL table and then how to import a CSV file into PostgreSQL database table using the PGAAdmin tool. We will write query to import the CSV file into PostgreSQL database table.

This is our another tutorial video on PostgreSQL topic. In coming days you will see more videos from our side on MSBI stack and on SQL Server.

Happy Learning.

If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com”

Видео 04 Import CSV File To PostgreSQL канала Learn SSIS