Jason Earl wrote:
>
> psql <database_name> -U postgres -f loadfile.sql
>
> Should do what you want. Or if you are already in
> psql take a look at the \i command.
Especially if you're just starting, you might like to start psql as
'psql -s'. This puts you in single step mode, so when you use \i, the
SQL commands you are loading will be executed one at a time.
--
Ron Peterson
Network & Systems Manager
Mount Holyoke College
GPG and other info at http://www.mtholyoke.edu/~rpeterso