Thanks everybody, I got it.
Rosta
> Hi Rosta,
>
> try:
> psql db_name < file_name
>
> regards,
>
> Devinder Rajput
> Stores Division Corporate Offices
> Chicago, IL
> (773) 442-6474
>
>
>
>
> "Rosta Farzan" <rosta@sn432s03.sci.csuhayward.edu>
> Sent by: pgsql-novice-owner@postgresql.org
> 01/15/2003 03:50 PM
>
>
> To: pgsql-novice@postgresql.org
> cc:
> Subject: [NOVICE] reading command from file
>
>
> Hi everybody
>
> I need help in how to read sql commands from file instead of typing in
> postgres (psql) command line. I mean I have a file which includes for
> example a create table command and I want to load it to postgres
> created database. Would you please help me with this.
> Thanks,
> Rosta
************************************
Rosta Farzan
Laboratory for Adaptive Hypermedia and Assistive Technologies
Department of Math and Computer Science CSU Hayward
rosta@acc.csuhayward.edu
(510) 885-4026
*************************************