{"library":"prettier-plugin-postgresql","type":"library","category":null,"description":"A Prettier plugin that uses the official libpg_query parser to format PostgreSQL SQL. Currently in beta (v0.2.3) with support for core DML and DDL constructs including SELECT, INSERT, UPDATE, DELETE, CTEs, window functions, CREATE TABLE, ALTER TABLE, indexes, views, functions, triggers, and more. Compared to generic SQL formatters, this plugin uses PostgreSQL's own parser for accurate syntax understanding and respects optional parentheses in WHERE clauses (default: minimal). Release cadence is monthly. Node >=20 and Prettier >=3 required. Ships TypeScript types.","language":"javascript","status":"active","version":"0.2.3","tags":["javascript","prettier","prettier-plugin","sql","postgresql","postgres","pgsql","formatter","typescript"],"last_verified":"Thu Jun 04","install":[{"cmd":"npm install prettier-plugin-postgresql","imports":["// In .prettierrc.yaml:\nplugins:\n  - prettier-plugin-postgresql","// .prettierrc\n{\n  \"plugins\": [\"prettier-plugin-postgresql\"],\n  \"pgFunctionNameCase\": \"lowercase\",\n  \"pgHavingClauseOnNewLine\": true\n}","// tsconfig.json or prettier.config.ts\nimport type { Config } from 'prettier';\nconst config: Config = {\n  plugins: ['prettier-plugin-postgresql']\n};\nexport default config;"]},{"cmd":"yarn add prettier-plugin-postgresql","imports":[]},{"cmd":"pnpm add prettier-plugin-postgresql","imports":[]}],"homepage":"https://github.com/schallm/prettier-sql/tree/main/packages/plugin-pgsql#readme","github":"https://github.com/schallm/prettier-sql","docs":null,"changelog":null,"pypi":null,"npm":"prettier-plugin-postgresql","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}