postgres bash prompt error while user creation

From: Pingale(dot)amol(at)gmail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: postgres bash prompt error while user creation
Date: 2007-10-25 07:26:27
Message-ID: 1193297187.956038.141910@e9g2000prf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hello group
i want to create a shell script in that i want to create postgresql
user and database.both this task are created properly and executed
properly but after user and DB creation i am there on ( -bash-3.00$ )
and i wanna come back to [root(at)localhost:localdomain ~]# and my
script is
#!/bin/bash
su -l postgres;
psql -U postgres -c "CREATE USER admin27 WITH PASSWORD 'admin27'
CREATEDB;" template1
psql -U admin27 -c "CREATE DATABASE emcc27;" template1 \q exit;
plzz help me to back to root from postgres bash prompt

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tfinneid 2007-10-25 08:00:40 select count() out of memory
Previous Message Harald Armin Massa 2007-10-25 06:28:19 Re: Using Postgres as a "embedded" / SQL Lite database on Windows