Skip to main content

Raw SQL

Migrations​

You can execute DDLX statement using raw SQL.

Make sure you connect via the migrations proxy. For example, using PSQL:

$ psql "postgresql://postgres:$PG_PROXY_PASSWORD@localhost:$PG_PROXY_PORT/mydb"

Then execute the statement directly:

ALTER TABLE items
  ENABLE ELECTRIC;

Event sourcing​

There are many ways to consume data changes from Postgres using raw SQL. See Integrations -> Event sourcing -> Change events for more information.