'how to fix query-tool: Query failed ERROR: syntax error at or near while inserting data

I have this command to populate created tables with geographic data

COPY public.adonis_schema (id, name, batch, migration_time) FROM stdin;
1   database/migrations/1607548129188_users 1   2021-04-02 14:14:27.470863+00
2   database/migrations/1607548416832_conversations 1   2021-04-02 14:14:28.070888+00
3   database/migrations/1607548444586_participations    1   2021-04-02 14:14:28.480253+00
4   database/migrations/1607548494088_messages  1   2021-04-02 14:14:29.050234+00
5   database/migrations/1609020554140_vcard_shares  1   2021-04-02 14:14:29.520909+00
6   database/migrations/1609024583459_add_conversation_names    1   2021-04-02 14:14:29.905367+00
7   database/migrations/1609467289494_meetings  1   2021-04-02 14:14:30.300248+00
8   database/migrations/1609467351706_notes 1   2021-04-02 14:14:30.960852+00
9   database/migrations/1609976010374_meetings_lengths  1   2021-04-02 14:14:31.640233+00
10  database/migrations/1610498049695_conversations_event_ids   1   2021-04-02 14:14:32.020247+00
11  database/migrations/1611099138751_cache_users   1   2021-04-02 14:14:32.405294+00
12  database/migrations/1616628109445_conversations_ownerships  1   2021-04-02 14:14:32.800258+00
13  database/migrations/1617362496376_conversations_types   1   2021-04-02 14:14:33.185207+00
14  database/migrations/1617805023298_conversations_timestamps  2   2021-04-07 14:18:42.957427+00
47  database/migrations/1622085675952_user_is_busies    3   2021-05-27 03:22:31.964783+00
\.

I have as indicated put the entire code in a sql file and executed it with psql but I have an error:

ERROR: ERREUR:  erreur de syntaxe sur ou près de « 1 »
LINE 2: 1 database/migrations/1607548129188_users 1 2021-04-02 14:14...
        ^
SQL state: 42601
Character: 73

Do you have an idea please?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source