Recently I needed to query a postgres database and put some of the info in a sqlite database. At first I wondered how am I going to do that?, but it’s much much easier then you’d think it is. A small example of a bash script doing just that: #!/bin/bash export PGPASSWORD=mypassword psql="psql -h localhost -U myuser -d mydatabase" [...]
Nov 102009