Susan Hurst <susan.hurst@xxxxxxxxxxxxxxxxxx> 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 -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@xxxxxxxxxxx p: 312.241.7800
