Unable to create postgres schema.

[mrVin99]

Unable to create postgres schema.

[mfridman]

What error are you receiving?

Not sure if it is a copying error, but you need to break up your statements, otherwise it's considered one long comment. I tried the following:

-- +goose Up

CREATE SCHEMA IF NOT EXISTS test_schema;

And it applied the migration, goose_db_version:

id	version_id	is_applied	tstamp
1	0	t	2024-01-29 14:28:23.765292
2	1	t	2024-01-29 14:28:23.782379

And created the "test_schema":

SELECT
	*
FROM
	pg_catalog.pg_namespace;

Returns:

oid	nspname	nspowner	nspacl
99	pg_toast	10
11	pg_catalog	10	{postgres=UC/postgres,=U/postgres}
2200	public	10	{postgres=UC/postgres,=UC/postgres}
13403	information_schema	10	{postgres=UC/postgres,=U/postgres}
16393	test_schema	10

[mrVin99]

Indeed, you're right. My apologies. The issue lies with IntelliJ IDEA in this case. I'm using their database console to view my tables, etc., and it's not displaying them when I create the schema via Goose. However, it shows up when I create it manually. Thank you for the response, and I apologize for the seemingly simple question.