The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { ident, safeSql, type SafeSqlFragment } from '../../../pg-format'
import pgMetaExtensions from '../../../pg-meta-extensions'
export const getDatabaseExtensionsSQL = (): SafeSqlFragment =>
safeSql`
SELECT
e.name,
n.nspname AS schema,
e.default_version,
x.extversion AS installed_version,
e.comment,
ev.schema AS default_version_schema
FROM
pg_available_extensions e
LEFT JOIN pg_extension x ON e.name = x.extname
LEFT JOIN pg_namespace n ON x.extnamespace = n.oid
LEFT JOIN pg_available_extension_versions ev
ON ev.name = e.name AND ev.version = e.default_version;
`
export const getEnableDatabaseExtensionSQL = ({
schema,
name,
version,
cascade,
createSchema = false,
}: {
schema: string
name: string
version: string
cascade?: boolean
createSchema?: boolean
}): SafeSqlFragment => {
const { sql } = pgMetaExtensions.create({ schema, name, version, cascade })
return createSchema
? safeSql`CREATE SCHEMA IF NOT EXISTS ${ident(schema)};
${sql}`
: sql
}