Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
484 views
in Technique[技术] by (71.8m points)

pgadmin 4 - How to transfer data from csv file to PostgreSQL database?

I have a large amount of data in an excel sheet that I need to transfer into a PostgreSQL database. Using pgadmin 4, I followed the instructions given here, converting the excel sheet into a csv file with a comma delimiter:

Importing CSV file PostgreSQL using pgAdmin 4

However, the process fails with

[Errno 13] Permission denied: 'folder path'

Edit: I shifted the file to another folder as requested, and I managed to start a process, however it fails with error code 1. How do I resolve this issue?

How can I enter the necessary data?


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...