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 [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to