Function buildSessionPgClassViewSQL

server/sessionmeta/sessionmeta.go:240–425

()

			numeric_scale INTEGER,
			PRIMARY KEY (table_schema, table_name, column_name)
		)
	`
}

func buildSessionPgDatabaseViewSQL(database string) string {
	lit := quoteSQLStringLiteral(database)
	return fmt.Sprintf(`
		CREATE OR REPLACE VIEW main.pg_database AS
		WITH base AS (
			SELECT * FROM (
				VALUES
					(1::INTEGER, 'postgres', 10::INTEGER, 6::INTEGER, 'c', false, true, -1::INTEGER, 0::INTEGER, 0::INTEGER, 1663::INTEGER, 'en_US.UTF-8', 'en_US.UTF-8', NULL, NULL, NULL, NULL),
					(2::INTEGER, 'template0', 10::INTEGER, 6::INTEGER, 'c', true, false, -1::INTEGER, 0::INTEGER, 0::INTEGER, 1663::INTEGER, 'en_US.UTF-8', 'en_US.UTF-8', NULL, NULL, NULL, NULL),
					(3::INTEGER, 'template1', 10::INTEGER, 6::INTEGER, 'c', true, true, -1::INTEGER, 0::INTEGER, 0::INTEGER, 1663::INTEGER, 'en_US.UTF-8', 'en_US.UTF-8', NULL, NULL, NULL, NULL)
			) AS rows(
				oid, datname, datdba, encoding, datlocprovider, datistemplate, datallowconn,
				datconnlimit, datfrozenxid, datminmxid, dattablespace, datcollate, datctype,
				daticulocale, daticurules, datcollversion, datacl
			)
		),
		requested AS (
			SELECT
				CASE
					WHEN %s = 'postgres' THEN 1
					WHEN %s = 'template0' THEN 2
					WHEN %s = 'template1' THEN 3
					ELSE 4
				END::INTEGER AS oid,
				%s AS datname,
				10::INTEGER AS datdba,
				6::INTEGER AS encoding,
				'c' AS datlocprovider,
				(%s IN ('template0', 'template1')) AS datistemplate,
				(%s != 'template0') AS datallowconn,
				-1::INTEGER AS datconnlimit,
				0::INTEGER AS datfrozenxid,
				0::INTEGER AS datminmxid,
				1663::INTEGER AS dattablespace,
				'en_US.UTF-8' AS datcollate,
				'en_US.UTF-8' AS datctype,
				NULL AS daticulocale,
				NULL AS daticurules,
				NULL AS datcollversion,
				NULL AS datacl
		)
		SELECT
			oid, datname, datdba, encoding, datlocprovider, datistemplate, datallowconn,
			datconnlimit, datfrozenxid, datminmxid, dattablespace, datcollate, datctype,
			daticulocale, daticurules, datcollversion, datacl
		FROM base
		WHERE datname <> %s
		UNION ALL
		SELECT
			oid, datname, datdba, encoding, datlocprovider, datistemplate, datallowconn,
			datconnlimit, datfrozenxid, datminmxid, dattablespace, datcollate, datctype,
			daticulocale, daticurules, datcollversion, datacl
		FROM requested
	`, lit, lit, lit, lit, lit, lit, lit)