Re: Space Stalker in SQL Output

2018-06-27 Thread Joe Conway
On 06/27/2018 12:45 PM, Susan Hurst wrote: > Wow!  The -A option worked perfectly! > > Thanks for the syntax lesson Steve and Jerry! If you are going to be doing lots of scripting with Postgres, you might want to take a look here: https://github.com/jconway/shebang HTH, Joe -- Crunchy Data -

Re: Space Stalker in SQL Output

2018-06-27 Thread Susan Hurst
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.hu...@brookhurstdata.com Mobile: 314-486-3261 On 2018-06-27 14:38, Jerry Sievers wrote:

Re: Space Stalker in SQL Output

2018-06-27 Thread Jerry Sievers
Susan Hurst 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