Re: Creating tables from files

On 6 Nov 2001, Jason Earl wrote:

> Let's say you had a file (create.sql) that had:
>
> CREATE TABLE foo (
> bar SERIAL PRIMARY KEY,
> baz text
> );
>
> and you wanted to load this into the processdata database. The
> command would look like this:
>
> psql processdata -f create.sql
>
> See man psql for more information, and fire up psql and do /? and
> check out the /i command it does the same thing.
>
> I hope this is helpful,

Yup. Thank you very much, Jason.

Rich

Dr. Richard B. Shepard, President

Applied Ecosystem Services, Inc. (TM)
2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
+ 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | rshepard(at)appl-ecosys(dot)com
http://www.appl-ecosys.com