Re: Database connectivity using a unix shell

On Thu, 2006-06-29 at 11:08, Jasbinder Bali wrote:
>
> On 6/29/06, Scott Marlowe <smarlowe(at)g2switchworks(dot)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).

http://www.postgresql.org/docs/8.1/interactive/libpq-pgpass.html