On Thu, 2006-06-29 at 10:24, Jasbinder Bali wrote:
> 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`;
do a psql --help to get a list of options for psql. -t means print only
the rows, no headers, and -q means to only display query output, no
messages or warnings.
In response to
pgsql-general by date
|Next:||From: Greg Stark||Date: 2006-06-29 15:54:43|
|Subject: Re: [GENERAL] UUID's as primary keys|
|Previous:||From: Richard Broersma Jr||Date: 2006-06-29 15:32:24|
|Subject: Re: Database connectivity using a unix shell|