Re: Creating db from sql script file

Try pg_dump with the '-s' option. That should give you what you need.
See man pg_dump for more information.

Jason

"John Winn" <JWinn(at)HuffTech(dot)com> writes:

> I have worked with MSSql for awhile and one of the most convienent
> features of the Enterprise Manager is the "export sql to file"
> function. I am new to postgres and wondering if postgres supports
> this. The main reason is I use a dev. box and a live box. If I make
> the changes on the dev box, can I export the sql and transfer it to
> the live box? Not to mention, when the database is created it would be
> nice to export the sql to have a hard copy.
>
> Is there an export/import sql feature? I have not been able to find
> it.
>
> Thanks
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 1: subscribe and unsubscribe
> commands go to majordomo(at)postgresql(dot)org