Portal Home > Knowledgebase > Server Administration > Postgresql


Postgresql




Postgresql

Alter schema:

psql
alter role dbusername createdb;
create database dbusername_dbname;
alter role dbusername nocreatedb;

Check connected to user:

c - postgres

In postgres mode:

Check list of databases

l


Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read
Check Open Ports (Views: 1324)
Linux Bash Commands (Views: 1877)
Repair MySQL Database (Views: 1315)