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`;
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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
