Re: [SQL] importing a pre sql db

From: Leslie Mikesell <les(at)Mcs(dot)Net>
To: SierraAdm(at)aol(dot)com
Cc: pgsql-novice(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] importing a pre sql db
Date: 1998-08-05 05:15:43
Message-ID: 199808050515.AAA00727@Mercury.mcs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

According to SierraAdm(at)aol(dot)com:
> I can convert that to
> create table wc_members (
> wc_last_name char(20),
> ... more such ... )
> How do I get it in as the table definition?

You can type it directly into psql (don't forget the terminating ';')
but I usually put all the table definitions, sequences, indexes
and grant statements in a file and use the '\i file' command from
psql to execute them.

Les Mikesell
les(at)mcs(dot)com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Walter St. John 1998-08-05 06:15:51 offtopic question regarding tools.
Previous Message SierraAdm 1998-08-04 21:38:21 importing a pre sql db