Thread: Schema Import

Schema Import

From
"Bob McCormick"
Date:
All,

I've found a case tool that will generate a schema based on PostgreSQL
syntax and am wondering if it is possible to run this generated SQL script
to have the database schema created?

If so, could someone knowledgeable give me a clue???

Thanks...Bobbo ;-)

Bob McCormick
Intuitive Software Technology








Re: Schema Import

From
Anand Raman
Date:
hi Bob,

Try

psql -h <ur_machine> <db_name> -U <user_name> -f <the_schema.sql>

HTH
Anand
On Mon, Apr 16, 2001 at 12:36:06PM -0700, Bob McCormick wrote:
>All,
>
>I've found a case tool that will generate a schema based on PostgreSQL
>syntax and am wondering if it is possible to run this generated SQL script
>to have the database schema created?
>
>If so, could someone knowledgeable give me a clue???
>
>Thanks...Bobbo ;-)
>
>Bob McCormick
>Intuitive Software Technology
>
>
>
>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html