CREATE DATABASE in PostgreSQL

Question

Why does the Owner show "postgres" after creating a new PostgreSQL database? How can I create a new database with my DB user as the owner? My DB user has the privilege to create a database.

postgresql.org/docs/current/sql-createdatabase.html

wildplasser
– wildplasser

2021-07-06 09:27:30 +00:00
Commented Jul 6, 2021 at 9:27 — wildplasser
– wildplasser, Commented Jul 6, 2021 at 9:27

user330315 · Accepted Answer · 2021-07-06 09:26:38Z

2

As documented in the manual you can specify the owner when creating the database

create database my_new_dabase
    OWNER = sunday_ezeilo;

This assumes that you already have a role/user named sunday_ezeilo

answered Jul 6, 2021 at 9:26

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

CREATE DATABASE in PostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related