Hello All, I built the latest postgresql 7.4.2 in HPUX PA. The command "psql -E <databasename>", is not give the output like in 7.3.4. In Postgresql 7.3.4, it gives the following output: $ echo "select * from db5;" | psql -E test ********* QUERY ********** BEGIN; SELECT usesuper FROM pg_catalog.pg_user WHERE usename = 'postgres'; COMMIT ************************** name | age ------------+----- James | 25 (1 row) But in Postgresql 7.4.2, $ echo "select * from db5;" | psql -E test name | age ------------+----- James | 25 (1 row) Why it gives diffferent output from previous version? Regs, Raj. ____________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match