Run a script in multiple PostgreSQL databases

Question

How can you run a script in multiple PostgreSQL databases in Mac?

Peter Eisentraut · Accepted Answer · 2013-01-02 15:41:23Z

4

for db in first_db second_db ...; do
    psql -d $db -f yourscript.sql
done

Of course there will be many variations depending on exactly what you want to do.

answered Jan 2, 2013 at 15:41

Peter Eisentraut

37.1k12 gold badges91 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1