konnosextensions.ts14 lines · main
| 1 | import { safeSql } from '../pg-format' |
| 2 | |
| 3 | export const EXTENSIONS_SQL = /* SQL */ safeSql` |
| 4 | SELECT |
| 5 | e.name, |
| 6 | n.nspname AS schema, |
| 7 | e.default_version, |
| 8 | x.extversion AS installed_version, |
| 9 | e.comment |
| 10 | FROM |
| 11 | pg_available_extensions() e(name, default_version, comment) |
| 12 | LEFT JOIN pg_extension x ON e.name = x.extname |
| 13 | LEFT JOIN pg_namespace n ON x.extnamespace = n.oid |
| 14 | ` |