On Aug 8, 2007, at 13:13 , Gauthier, Dave wrote:
If I have a DB called "foo"
psql --dbname "foo"
...and...
I want to run "select name from table_a where name like 'john%'"
psql --dbname "foo" -c "select name from table_a where name like 'john
%'"
...and...
I want no table header "NAME" in the output
psql --dbname "foo" -c "select name from table_a where name like 'john
%'" -t
...and...
I want to do this as a one-liner from the linux command line
check.
...and...
I don't want to have to deal with intermediate files or home-grown
programs...
Does that work?
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
