To restore from such a script, feed it to psql. Script files can be used to reconstruct the database even on other machines and other architectures; with some modifications even on other SQL database products.
PG Lightning Admin is a powerful GUI administration program for Postgresql 7.4.x and greater. It includes many advanced features such as a tabbed based MDI system, tabbed Enterprise Manager and more. * IDE style editors for functions,queries ...