There are two metods in which you can create two databases. Method 1: Creating the database in the PSQL prompt, with createuser command. # CREATE DATABASE mydb WITH OWNER ramesh; CREATE DATABASE Method 2: Creating the database in the shell prompt, with createdb command. $ /usr/local/pgsql/bin/createdb mydb -O ramesh CREATE DATABASE * -O owner name is the option in the command line.
