11 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:FILESTestData.csv’ DELIMITER ‘,’ CSV HEADER;

PostgreSQL Tutorials: https://www.youtube.com/playlist?list=PL_YF–8vjjEX4I9L_GM3EZ7Ti4LtRv6-y

Import CSV File To PostgreSQL
How do I import a CSV file into PostgreSQL?
How do I import a CSV file into PgAdmin?

Happy Learning.

If you have any questions or suggestions please comment on the video or write to me at “[email protected]”