Received: from trends.net (root@clio.trends.ca [209.47.148.2]) by hub.org (8.8.8/8.7.5) with ESMTP id IAA05974; Wed, 5 Aug 1998 08:51:30 -0400 (EDT) Received: from Kitten.mcs.com (Kitten.mcs.com [192.160.127.90]) by trends.net (8.8.8/8.8.8) with ESMTP id BAA01331; Wed, 5 Aug 1998 01:18:18 -0400 (EDT) Received: from Mercury.mcs.net (les@Mercury.mcs.net [192.160.127.80]) by Kitten.mcs.com (8.8.7/8.8.2) with ESMTP id AAA10425; Wed, 5 Aug 1998 00:15:43 -0500 (CDT) Received: (from les@localhost) by Mercury.mcs.net (8.8.7/8.8.2) id AAA00727; Wed, 5 Aug 1998 00:15:43 -0500 (CDT) From: Leslie Mikesell Message-Id: <199808050515.AAA00727@Mercury.mcs.net> Subject: Re: [SQL] importing a pre sql db To: SierraAdm@aol.com Date: Wed, 5 Aug 1998 00:15:43 -0500 (CDT) Cc: pgsql-novice@postgresql.org, pgsql-sql@postgresql.org In-Reply-To: from "SierraAdm@aol.com" at Aug 4, 98 09:38:21 pm X-Mailer: ELM [version 2.4 PL24] Content-Type: text According to SierraAdm@aol.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@mcs.com