Primary interactive terminal for PostgreSQL
3
votes
2answers
528 views
Span single transaction over several sequential psql sessions
I am running PostgreSQL 8.4 database server and psql terminal front-end on Ubuntu 10.04 Lucid Lynx and would like to span a single transaction over several sequential psql sessions.
When I connect to ...
3
votes
1answer
3k views
How to use psql with no password prompt?
I have wrote a script to REINDEX many indexes in a database. Here is one of them:
echo -e "\nreindex for unq_vbvdata_vehicle started at: `date "+%F %T"`" >> ${LOG_FILE}
psql -U ${USERNAME} -h ...
