psql execute SQL script 

Joined:
04/07/2009
Posts:
135

June 17, 2010 19:39:14    Last update: June 17, 2010 19:39:14
There are two ways to run a SQL script with PostgreSQL:
  1. From shell:
    $ psql theScript.sql
    

  2. Interactively:
    postgres=# \i theScript.sql
    

Share |
| Comment  | Tags