COPY statement
im using this query:
COPY profiles FROM '${profilesWithAudience}
and im getting this:
{
"message": "Failed to upload audience: invalid SQL: unsupported statement [COPY] on strict_with_ddl level, see https://xata.io/sql-support for the support matrix",
"error": "Bad Request",
"statusCode": 400
}
my branch is in atached to a clusterConnect to Postgres
Learn how to connect to Postgres directly via the wire protocol
2 Replies
Hey @angelgce , it looks like you're using SQL over HTTP which does not support the
COPY statement as per https://xata.io/docs/postgres#supported-statementsConnect to Postgres
Learn how to connect to Postgres directly via the wire protocol
So i guess i have to connect to psql by url? and then it will work?
do you have any guide ?