Re: Space Stalker in SQL Output

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

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

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

Space Stalker in SQL Output

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