Grant "create schema" ON database to a user?

postgresql postgresql-9.1 role
matheusvmbruno picture matheusvmbruno · Jun 1, 2012 · Viewed 24.5k times · Source

I'm using PostgreSQL 9.1 and have to to grant "create schema" ON database to a user.

How can I do that?

Answer

matheusvmbruno picture matheusvmbruno · Jun 1, 2012

It's more simple than I thought.

GRANT CREATE ON DATABASE db TO user;

Related questions

How to exit from PostgreSQL command line utility: psql

What command or short key can I use to exit the PostgreSQL command line utility psql?

Read More
I forgot the password I entered during postgres installation

I either forgot or mistyped (during the installation) the password to the default user of Postgres. I can't seem to be able to run it and I get the following error: psql: FATAL: password authentication failed for user "hisham" hisham-agil: …

Read More
"use database_name" command in PostgreSQL

I am beginner to PostgreSQL. I want to connect to another database from the query editor of Postgres - like the USE command of MySQL or MS SQL Server. I found \c databasename by searching the Internet, but its runs …

Read More