PostgreSQL - create a new DB through pgAdmin UI

Question

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 1

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;

Answer 2

HI ... Verify that u have done above steps to install the postgresql properly ... and follow the below instructions to create a database in POSTGRESQL

INSTALL POSTGRESQL

1.Install latest PostgreSQL 9.1 in console:

sudo apt-get install postgresql libpq-dev

2.PostgreSQL has a super user is called postgres. Change user to the PostgreSQL user:

sudo su - postgres 

3.Change password of postgres user:

psql -d postgres -U postgres 

psql (9.1.3) Type "help" for help

    postgres=# alter user postgres with password 'YOUR_NEW_PASSWORD';     ALTER ROLE     postgres=# \q     #logout postgres user     logout 

4.Restart the PostgreSQL server:

sudo /etc/init.d/postgresql restart 

pgAdmin III: PostgreSQL administration and management tools

If pgAdminIII is not installed, the installation is easy:

sudo apt-get install pgadmin3 

ADD A SEVER

Open pgAdminIII and add new localhost server. Go to menu File > Add Server

Set up pgAdmin III server instrumentation:

When connecting to a PostgreSQL database using pgAdmin you may receive an error letting you know that the server instrumentation is not installed.

Install postgresql-contrib package:

sudo apt-get install postgresql-contrib 

Install adminpack extension:

sudo -u postgres psql postgres=# CREATE EXTENSION "adminpack"; postgres=# \q 

CREATE DATABASE

1.Double Click your database in Left pane on PGAdmin to select it

2.Now click the a Icon named "SQL" ,probably 6th icon, and type CREATE table query in resultant window

EXAMPLE:

3.Create table query

CREATE TABLE explore( SUBJECT  TEXT     NOT NULL, COMPANY  CHAR(50) NOT NULL, PNAME    TEXT     NOT NULL, PHONE    INT      NOT NULL, EMAIL    CHAR(50) NOT NULL, REMARKS  CHAR(200) NOT NULL );   

Post any queries below.............Have a error free day.