The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { safeSql } from '../pg-format'
export const PUBLICATIONS_SQL = /* SQL */ safeSql`
SELECT
p.oid :: int8 AS id,
p.pubname AS name,
p.pubowner::regrole::text AS owner,
p.pubinsert AS publish_insert,
p.pubupdate AS publish_update,
p.pubdelete AS publish_delete,
p.pubtruncate AS publish_truncate,
CASE
WHEN p.puballtables THEN NULL
ELSE pr.tables
END AS tables
FROM
pg_catalog.pg_publication AS p
LEFT JOIN LATERAL (
SELECT
COALESCE(
array_agg(
json_build_object(
'id',
c.oid :: int8,
'name',
c.relname,
'schema',
nc.nspname
)
),
'{}'
) AS tables
FROM
pg_catalog.pg_publication_rel AS pr
JOIN pg_class AS c ON pr.prrelid = c.oid
join pg_namespace as nc on c.relnamespace = nc.oid
WHERE
pr.prpubid = p.oid
) AS pr ON 1 = 1
`