{"library":"pg-ts-gen","type":"library","category":null,"description":"Generate TypeScript interfaces and constants from a Postgres database schema by querying pg_catalog. Version 4.2.0 requires TypeScript >=4.1. A fork of schemats that drops MySQL support in favor of deeper Postgres integration, supports table/column comments as JSDoc, custom JSON types via `--jsonTypesFile`, date-as-string mode, and schema name prefixing. Ships with a CLI tool and outputs both select and input interfaces plus runtime table constants.","language":"javascript","status":"active","version":"4.2.0","tags":["javascript","postgres","schema","typescript","sql"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install pg-ts-gen","imports":["import { TableTypes } from './dbschema'","import { tables } from './dbschema'","import { Product } from './dbschema'"]},{"cmd":"yarn add pg-ts-gen","imports":[]},{"cmd":"pnpm add pg-ts-gen","imports":[]}],"homepage":"https://github.com/danvk/pg-to-ts#readme","github":"https://github.com/danvk/pg-to-ts","docs":null,"changelog":null,"pypi":null,"npm":"pg-ts-gen","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}