On Sat, Feb 20, 2010 at 10:11 AM, Nilesh Govindarajan <[email protected]> wrote: > I want a script to backup all databases table by table in different .sql > files.
Why? It may be that pg_dump / pg_restore already provide the functionality you are looking for. > How to do this ? pg_dump -t tablename dbname rinse repeat > Also since it is a script, there has to be some role having read access to > all tables on all databases. How to grant that ? Can they just be a superuser? Or can you grant them the role that has ownership of the tables? -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
