How do I import a .csv file into my Hasura PostgreSQL database?

Question

I have data in a .csv file that I want to import into my Hasura cluster's PostgreSQL database instance. What's the best way to do this?

Best way is to post your code. And the resulting error message. #period — wildplasser, Nov 19 '17 at 23:47

Shahidh · Answer 1 · 2020-04-21T06:33:04.003

6

Create table_name with the appropriate schema to absorb your CSV data; use psql to stream data on to postgres. Execute this command:

$ psql <postgres-url> -d <database-name> -U <user-name> -c \
  "copy table_name from STDIN with delimiter as ',';" \
  < /path/to/file.csv

You will have the data from CSV file inside table table_name

edited Apr 21 '20 at 06:33

answered Nov 20 '17 at 06:34

Shahidh

2,472
1
18
18

1

If you don't have psql installed locally, you can also use ms cp and ms exec commands: `$ hasura ms cp /path/to/file.csv hasura/postgres:/data.csv` and `$ hasura ms exec postgres -n hasura -- psql -U admin -d hasuradb -c "copy table_name from STDIN with delimiter as ',';" < /data.csv` – Shahidh Jan 17 '18 at 10:02
Do you have a reference for the `hasura microservice` command? I can't see it in the [Hasura CLI docs](https://docs.hasura.io/1.0/graphql/manual/hasura-cli/index.html) – Robin Métral Feb 16 '20 at 17:13

score 0 · Answer 2 · answered Apr 10 '20 at 16:08

Adding my answer here for reference. When deploying Hasura in Heroku we can get temporary credentials for the Postgres database by accessing the Postgres add-on from the Heroku resources dashboard. Then you can access the database directly using the url provided on the settings tab.

psql 'postgres://UUUUUU:PPPPP@ec2-54-247-72-30.eu-west-1.compute.amazonaws.com:5432/DBNAME'

Then in the Postgres console you can do something like:

\copy countryinfo from 'countryinfo.csv' with delimiter as E'\t';

The above for a tab delimited file downloaded from Geonames.org. Note: I deleted the comment lines before input.

score 0 · Answer 3 · answered Jul 28 '23 at 14:26

You can use pgAdmin to simplify the task. Connect to your postgres instance, then go to Import/Export Data under Tools menu after selecting the desired table from the left sidebar.

Select the .csv file and click on "Ok"

You should now have all your data imported successfully.

How do I import a .csv file into my Hasura PostgreSQL database?

3 Answers3