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