How to setup CSV file in the db/migration folder?

Question

In usual migration I am using SQL usual COPY CSV command, but now all the SpringBoot project must be into a git and generic path for clone (and do it in a protected server):

where the best place or "standard Spring folder" to CSV files used by main/resources/db/migration?
how to use the COPY (SQL) with a relative path?

Relative path by shell is:

psql -h localhost -U postgres gcp -c    "\
  CREATE TABLE question_import (question text, weight integer); \
  COPY question_import FROM STDIN WITH CSV HEADER delimiter as ',' \
"    < _docs/data/csc-questoes.csv

but PostgreSQL not supports internal relative path.

@TommasoDiBucchianico Hum... Ideal is to use "only db/migration", independent of other server-side intalls — Peter Krauss
– Peter Krauss, Commented Jan 24, 2017 at 10:51

gtonic · Accepted Answer · 2017-01-24 10:22:04Z

1

Once you're using SpringBoot, why not incorporating the benefits of Liquibase (section 75.5.2)?

Apart from the ability to define/version your database schema, there are also methods for loading data, e.g. CSV in your case:

<changeSet author="liquibase-docs" id="loadUpdateData-example">
<loadUpdateData catalogName="cat"
        encoding="UTF-8"
        file="com/example/users.csv"
        primaryKey="pk_id"
        quotchar="A String"
        schemaName="public"
        separator="A String"
        tableName="person">
    <column name="address" type="varchar(255)"/>
</loadUpdateData>

The Spring-Boot-Liquibase Sample project should give you a quickstart.

answered Jan 24, 2017 at 10:22

gtonic

2,3431 gold badge25 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to setup CSV file in the db/migration folder?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related