> 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 [EMAIL PROTECTED]: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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly