1 reply

How to alter database with drizzle (sql magic operator)?

Hi everyone,

I am trying to use the sql magic operator to alter a postgres database, but no luck yet.
Here's what I am trying to do:

await db.execute(
    sql`ALTER DATABASE ${databaseName} SET pg_trgm.similarity_threshold = 0.2;`
  );

await db.execute(
    sql`ALTER DATABASE ${databaseName} SET pg_trgm.similarity_threshold = 0.2;`
  );

However, I am getting

PostgresError: syntax error at or near "$1"

PostgresError: syntax error at or near "$1"

, looks like this operator does not support to use variables when using

ALTER DATABASE

ALTER DATABASE

.

Any solution on how to actually perform this operation? It is only running on script (CI/CD), it is not exposed to the public, so security here isn't a huge concern.

Thank you!

Drizzle Team•2y ago•

1 reply

Nelson Sousa

How to alter database with drizzle (sql magic operator)?

Hi everyone,

I am trying to use the sql magic operator to alter a postgres database, but no luck yet.
Here's what I am trying to do:

await db.execute(
    sql`ALTER DATABASE ${databaseName} SET pg_trgm.similarity_threshold = 0.2;`
  );

await db.execute(
    sql`ALTER DATABASE ${databaseName} SET pg_trgm.similarity_threshold = 0.2;`
  );

However, I am getting

PostgresError: syntax error at or near "$1"

PostgresError: syntax error at or near "$1"

, looks like this operator does not support to use variables when using

ALTER DATABASE

ALTER DATABASE

.

Any solution on how to actually perform this operation? It is only running on script (CI/CD), it is not exposed to the public, so security here isn't a huge concern.

Thank you!

How to alter database with drizzle (sql magic operator)?

Similar Threads

How to alter database with drizzle (sql magic operator)?

Similar Threads

Similar Threads

Similar Threads