pg_catalog_namespace.slt

# Copyright Materialize, Inc. and contributors. All rights reserved.
#
# Use of this software is governed by the Business Source License
# included in the LICENSE file at the root of this repository.
#
# As of the Change Date specified in that file, in accordance with
# the Business Source License, use of this software will be governed
# by the Apache License, Version 2.0.

mode cockroach

statement ok
CREATE SCHEMA other;

statement ok
CREATE DATABASE other

query TTT rowsort
SELECT nspname, nspowner, nspacl FROM pg_catalog.pg_namespace
----
information_schema NULL NULL
mz_catalog   NULL NULL
mz_internal  NULL  NULL
other   NULL  NULL
pg_catalog   NULL  NULL
public   NULL  NULL

statement ok
SET database = other;

query TTT rowsort
SELECT nspname, nspowner, nspacl FROM pg_catalog.pg_namespace
----
information_schema NULL NULL
mz_catalog   NULL NULL
mz_internal  NULL  NULL
pg_catalog   NULL  NULL
public   NULL  NULL