PostgreSQL - create a new DB through pgAdmin UI

Yatendra picture Yatendra · Nov 20, 2011 · Viewed 85.6k times · Source

I have installed PostgreSQL DB server on my Ubuntu machine. Now I want to create a new Database through some GUI application. I tried pgAdmin but didn't find any option to create a new DB. But I could add existing db servers.

Is there any way to create a DB and then tables through pgAdmin or some other app.

Basically I am looking for an application for PostgreSQL like SQLYog for MySQL.

Answer

Frank Heikens picture Frank Heikens · Nov 20, 2011
  1. Open pgAdmin
  2. Connect to database server
  3. Edit => New Object => New database
  4. done

Or use plain SQL when connection to any database: CREATE DATABASE my_database;