Re: How to query by column names

On Mon, 22 Jan 2007, Richard Ray wrote:

> On Mon, 22 Jan 2007, Jeff Frost wrote:
>
>> So why are you avoiding "SELECT * FROM t1;" ?
>> 
> I was affeared that if I brought my total ignorance to light I would be band 
> from the list but here goes.
> I work in UNIX/Linux environments.
> It's my habit to record my scripts.
> A simple example:
>
> #!/bin/bash
> CMD="psql -d test \"select * from t1\""
> echo $CMD >> my_log
> eval $CMD |
> while read x; do
>  do_something_with_x
> done
>
> In this example * expands to all files in the current working directory.
> I was attempting to get around this by enumerating the table attributes.

Oh! Why didn't you just say that in the first place.  You just need quotes. 
Try this:

psql -c 'select * from t1' test

or

psql -c "select * from t1" test

or

echo "select * from t1" | psql test

-- 
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954