Yes, that works. The actual sql executes a stored function that returns a set of records. Output to the CLI looks great !!! Thanks to all !!! -dave -----Original Message----- From: Michael Glaesemann [mailto:grzm@xxxxxxxxxxxxxxx] Sent: Wednesday, August 08, 2007 2:43 PM To: Gauthier, Dave Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Running a query from the OS CLI 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 6: explain analyze is your friend
