Received: from bubbles.electricutopia.net (bubbles.electricutopia.net [63.214.178.76]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f25JCNx24863 for ; Mon, 5 Mar 2001 14:12:23 -0500 (EST) (envelope-from dave@slickness.org) Received: from localhost (dave@localhost) by bubbles.electricutopia.net (8.9.3/8.9.3) with ESMTP id LAA01075; Mon, 5 Mar 2001 11:08:40 -0800 Date: Mon, 5 Mar 2001 11:08:40 -0800 (PST) From: David Olbersen X-X-Sender: To: "Jeff S." cc: Subject: Re: How do I use text script containing SQL? In-Reply-To: <20010305185600.44574.qmail@web12702.mail.yahoo.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200103/56 X-Sequence-Number: 1701 On Mon, 5 Mar 2001, Jeff S. wrote: ->I want to be able to use the file to create my table. ->I've tried psql -d databasename -e < filename.txt ->but that doesn't work. You're making it too dificult :-) 'psql -d databasename < filename.txt' should work just fine -- Dave