Using PostgreSQL \COPY

Question

I'm using JMeter for insert summary data file to PostgreSQL.

I tried \copy instead of COPY but I'm getting error at \copy syntax.

I found out COPY is for only server-side, so I us \copy for client-side.

Here is my query

\copy Load(label,success,bytes,latency)
FROM '/Desktop/Summary/oca_sum.csv' DELIMITER ',' CSV HEADER;

Here is the error:

org.postgresql.util.PSQLException: ERROR: syntax error at or near "\" at position: 1

\copy is a psql meta-command, not a SQL command. So you can only use it in psql — user330315
– user330315, Commented Jun 22, 2020 at 8:42

pifor · Accepted Answer · 2020-06-22 08:42:38Z

0

\copy is not a SQL command but a psql command: you need to use psql.

answered Jun 22, 2020 at 8:42

pifor

7,9722 gold badges12 silver badges18 bronze badges

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

2 Comments

Hi @pifor any other query idea to insert csv file to PostgreSQL table using sql from JMeter

Sorry but I cannot help with JMeter.

Dmitri T · Accepted Answer · 2020-06-22 17:53:06Z

0

The options are in:

Use psql command line utility, you will need to install it on the machine where JMeter lives and call it using OS Process Sampler
Use CopyManager class from the JSR223 Sampler, you can find sample code i.e. here, in this case you will need to have Postgres JDBC driver under JMeter Classpath

answered Jun 22, 2020 at 17:53

Dmitri T

169k6 gold badges91 silver badges149 bronze badges

U mean i need to execute JSR223 Sampler code using OS Process Sampler.

These are 2 different approaches