The words Under construction in black text on a yellow background with diagonal black stipes surrounding it
I'm in the process of moving my site. It's still a work in progress. Please excuse the mess and broken links.

Create A Schema In Postgres

TODO: Pull subtitle into page object

Basic schema creation for a role that has the permissions.

code_start_default_section code_end_default_section

Full details are in the docs if you need them.

Debugging Stuff

I'm moving stuff around right now. All this below is helping me figure out where to put stuff

        -- title

Create A Schema In Postgres

-- p

Basic schema creation for a role that has the permissions.

-- code/
-- sql

CREATE SCHEMA IF NOT EXISTS new_schema_name;

-- /code

-- p

To set the owner of a new schema to another role, use:

-- code/
-- sql

CREATE SCHEMA IF NOT EXISTS new_schema_name AUTHORIZATION role_name;

-- /code

-- p

Full details are in <<link|the docs|https://www.postgresql.org/docs/current/sql-createschema.html>> if you need them.


-- categories
-- Postgres

-- metadata
-- date: 2021-11-26 12:35:25
-- id: 21sx7yrx
-- status: published
-- type: post
-- SCRUBBED_NEO: false
-- site: aws