0

I want to load csv into Cloud SQL (Postgres) automatically from compute engine. i am able to connect cloud sql (postgres) from compute engine. But i want load csv generated from XML in compute engine into Cloud SQL (Postgres) .

James Z
  • 12,209
  • 10
  • 24
  • 44
user2233220
  • 21
  • 6
  • 2
    Does this answer your question? [How to import CSV file data into a PostgreSQL table?](https://stackoverflow.com/questions/2987433/how-to-import-csv-file-data-into-a-postgresql-table) – Nikos Hidalgo Feb 21 '20 at 15:52
  • No,it does n't. fyi, i am loading csv from google compute engine into google cloud SQL (PostgreSQL) – user2233220 Feb 21 '20 at 17:17
  • Edit your question to clearly state what you are asking. Are you looking for a tool (off-topic for Stack Overflow), which programming language (what have you tried, post your code), someone to write code for you (someone might be generous). There are over 100 questions about CSV and PostreSQL on Stack Overflow. None of them help you? – John Hanley Feb 21 '20 at 18:10

1 Answers1

0

Given that every GCE instance has gcloud SDK installed by default, you can follow this command instructions and write your own scipt to perform the import operation.

Then you can set a schedule for your bash operation to run on x interval of time

Chris32
  • 4,716
  • 2
  • 18
  • 30
manasouza
  • 1,189
  • 1
  • 14
  • 26