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?

Boarder

Best way is to post your code. And the resulting error message. #period – Garibull

Answer 1

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

Blameless

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 – Blameless

Do you have a reference for the hasura microservice command? I can't see it in the Hasura CLI docs – Anny

Answer 2

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:[email protected]: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.

Ocotillo

Answer 3

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.

Stomy