COPY FROM STDIN does not work in liquibase

I'm trying to upload a lot of data from a .sql file using the COPY command for Postgresql. I have those data in a file.sql in the following format :

COPY my_table(id, name, status)  FROM stdin; 
1   peter  active
1   steve  active
1   maria  active
\.

And my changeset like this:

<changeSet id="sqlFile-example" author="me" >
        <sqlFile encoding="UTF-8"
                 path="file.sql"
                 relativeToChangelogFile="true"
                 endDelimiter=";"
                 splitStatements="false"
        />
 </changeSet>

And get this error:

[ERROR] Failed to execute goal org.liquibase:liquibase-maven-plugin:3.6.3:update (default-cli) on project lincoln-soft: Error setting up or running Liquibase: Migration failed for change set src/main/resources/db/liquibase/db-changelog.xml::sqlFile-example::me

[ERROR] Reason: liquibase.exception.DatabaseException: ERROR: unexpected message type 0x50 during COPY from stdin

[ERROR] Where: COPY my_table, line 1 [Failed SQL: COPY my_table(id, name, status) FROM stdin;

[ERROR] 1 peter active

[ERROR] 1 steve active

[ERROR] 1 maria active

[ERROR] \.]

I there a way to upload those data by liquibase?

Solution

As Laurenz already mentioned: you can't use COPY FROM STDIN directly in JDBC (you can use the CopyManager API to implement that manually, but Liquibase doesn't support that and I also don't know of any plugin that would do that)

I would suggest you use Liquibase's built-in ability to load CSV (text) files. Put your input data in CSV file, e.g. my_table_data.txt with a header line for the columns:

id,name,status
1,peter,active
1,steve,active
1,maria,active

Then use <loadData> instead of running a SQL script:

<changeSet id="sqlFile-example" author="me" >
        <loadData tableName="my_table"
                  file="my_table_data.txt" 
                  separator=","
                  encoding="UTF-8">
</changeSet>