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)
)

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.

[aqilahmed]

Good to know that this is the first video on the channel to reach 100 k views.

[Buffnerd_i]

thank god for creating indian tutors - you guys are always awesome.
ty!

[debabratasamal]

very helpful for beginners who find it overwhelming to get started with PG Admin

[gkepmqr]

hello, your birds are singing so beautifully outside the window)

[ramasubrahmanyam]

Its really useful and worked till the copy command.where as i am getting the error message with the HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql's \copy.
SQL state: 42501

[whiteboyfrik]

Great video, had to transfr the csv to c disk in order for the copy to work, have a great day

[TranTran-plsq]

Thank you so much, have to sign in to comment ^^, only your method worked for me!

[princejain]

For me below error is coming
"ERROR: could not open file for reading: Permission denied
HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql's \copy.
SQL state: 42501"

[hahatechnologies]

Permission denied
HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql's \copy.
SQL state: 42501

[annguyenthibinh]

many thanks, it worked version pgAdmin4, postgres 9.6

[samdy]

Thank you so much for the video..helped me for basic understanding. Worked

[danagrant]

Thank you so much for this video it really help me. I hope you make more videos like this.

[hybridmd]

Very nicely done.
I was having problems with granting permission, and needed to download a text reader because the it wasn't finding the file location, but overall very nice tutorial.
Thank you

[GuptaTreePoint]

Thank you so much, You explained very easily

[bombaster]

If you see "Permission denied" on Windows - edit properties of your csv-file, move to "Security" and on "Groups and users" click "edit" and add "All" in list with permissions

Just edit csv-file permissions, sorry for my eng

[hamalishah]

Thank you for the tutorial, But after this it shows error
ERROR: could not open file for reading: Permission denied" Can you please figure out the issue? Thank you in advance!

[CosmicSpaceAdventure]

Hey all. If you're getting "permission denied" errors when you try to run the copy command, try this in the command line:
chmod a+rX /Users/yourusername/ /Users/yourusername/Desktop
I'm on a mac osx 64bit machine
The error happens because the software doesn't have write privileges. If you run that command, it gives pgAdmin privileges, and will work. Change the paths to match your machine and csv file path.
best of luck.

[himanisakhare]

why cant we import data without creating table unlike we directly we load/import data inmysql

[laxcel]

hlo sir could you please help me to import csv file
I did all same procedure as you all do but my pgsql show 'Process failed' at last every time so please!!!

[scispacefacts]

how to give access to read CSV file its showing error