On Thu, 2006-06-29 at 11:08, Jasbinder Bali wrote: > > On 6/29/06, Scott Marlowe < smarlowe@g2switchworks.com> wrote: > On Thu, 2006-06-29 at 10:24, Jasbinder Bali wrote: > > > Hi > > > I need to connect to the postgres database using my unix shell. > > > How should i go about it? > > > Is libpq going to be helpful here? > > > There is a shell interface for postgresql called psql. > > > If you have postgresql installed on a box, then the psql interface > > should be there. > > > If you need to access postgresql from within a bash script, you can > > do So with a construct kinda like this: > > > query="select * from sometable"; > > a=`echo $query|psql -tq dbname`;
> in my bash script where and how do i specify the database connection > parameters
In psql you can use -U to specify your username. for password info, you need to use a .pgpass file (i.e. no passwords on the command line).