@ovotech/prettier-plugin-pgsql

Postgres sql prettier plugin

Plugin for formatting postgres SQL

Installation

yarn add --dev @ovotech/prettier-plugin-pgsql

Which should allow you to format sql files

prettier --write **/*.sql

SQL Template String

Since potygen is built to work with sql template strings, as they are much more ergonomic in typescript, the native prettier plugins are still not enough. Prettier itself does not support custom sql template strings, outside its predifined ones - this issue is tracked here: https://github.com/prettier/prettier/issues/4424

To get around this I've created a very simple patch to prettier code and will publish a patched version at @potygen/prettier for the time being, until a proper solution is found.

To set it up you need to force yarn (or npm) to load "prettier" from another repo. The code is the same, just adds "sql" as an additional template string that is then able to be extended by the plugin.

{
  "devDependencies": {
    "prettier": "npm:@potygen/prettier@^2.8.1"
  }
}