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;

PostgreSQL Tutorials:    • PostgreSQL Tutorials  

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]”