Re: postgres bash prompt error while user creation

> 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

You should probably start by reading about the basics of
shell programming. Apart from the obvious documentation
the man pages for "su" may help you to create something that
looks like a shell script.

You might consider the use of "here documents" as described
in the "bash" man page.

Yours,
Laurenz Albe