Re: Space Stalker in SQL Output

Wow!  The -A option worked perfectly!

Thanks for the syntax lesson Steve and Jerry!

Sue

---
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Susan E Hurst
Principal Consultant
Brookhurst Data LLC
Email: susan.hurst@brookhurstdata.com
Mobile: 314-486-3261

On 2018-06-27 14:38, Jerry Sievers wrote:
> Susan Hurst <susan.hurst@brookhurstdata.com> writes:
> 
>> Why would a psql statement insert a leading space into the output,
>> which is a single integer value?
>> 
>> The leading space caused my job call to fail elsewhere in the same
>> shell script as the psql call.  Here is the anonymized version of the
>> psql call to assign a value to a shell script variable:
>> 
>> IDz=`psql -d proddb -U produser -h 10.9.999.99 -p 99900 -t <
>> last_id.sql`
> 
> Get in the habit of including -A which gets rid of alignment padding in
> psql output.
> 
> As in...
> 
> shellvar=`psql -Atqc 'select froboz;'` $db
> 
> HTH