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` — , Jun 22 '20 at 08:42

score 0 · Accepted Answer · answered Jun 22 '20 at 08:42

0

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

answered Jun 22 '20 at 08:42

pifor

Hi @pifor any other query idea to insert csv file to PostgreSQL table using sql from JMeter – pengu1nnn Jun 22 '20 at 09:00
Sorry but I cannot help with JMeter. – pifor Jun 22 '20 at 09:03

score 0 · Answer 2 · answered Jun 22 '20 at 17:53

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 '20 at 17:53

Dmitri T

U mean i need to execute JSR223 Sampler code using OS Process Sampler. – pengu1nnn Jun 23 '20 at 02:45
These are 2 different approaches – Dmitri T Jun 23 '20 at 05:22

2 Answers2