From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 15171 invoked by alias); 26 Jan 2004 16:44:22 -0000 Mailing-List: contact rhdb-help@sources.redhat.com; run by ezmlm Precedence: bulk List-Subscribe: List-Post: List-Help: , Sender: rhdb-owner@sources.redhat.com Received: (qmail 15162 invoked from network); 26 Jan 2004 16:44:21 -0000 Received: from unknown (HELO touchme.toronto.redhat.com) (216.129.200.20) by sources.redhat.com with SMTP; 26 Jan 2004 16:44:21 -0000 Received: from redhat.com (sebastian-int.corp.redhat.com [172.16.52.221]) by touchme.toronto.redhat.com (Postfix) with ESMTP id F25E7800195; Mon, 26 Jan 2004 11:44:19 -0500 (EST) Message-ID: <40154335.1020206@redhat.com> Date: Mon, 26 Jan 2004 16:44:00 -0000 From: Fernando Nasser Organization: Red Hat Canada User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040113 MIME-Version: 1.0 To: rich o Cc: rhdb@sources.redhat.com Subject: Re: import text files References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-SW-Source: 2004-q1/txt/msg00026.txt.bz2 rich o wrote: > I want to import a text file into a database and I notice that under the > drop-down list when I right click the database I don't see the import or > export commands listed. Am I missing something or did I install > something wrong. > The Tcl version had import/export commands. Due to a Java restriction we had to remove those funtions for now. We haven't decided if we are going to find a way to make this work by means of an external process, or even if we will add it to our Visual PSQL tool. It may happen that it will only be available on the RHAPS version as we can use some EJBs in that environment. Sorry for the inconvenience. We hated having to remove it but it had no time to come up with something in time for the release. Fortunately the COPY TO and COPY FROM SQL commands are easy to use and the psql command line tool has a command to help with that as well, if I remember correctly. Regards, Fernando -- Fernando Nasser Red Hat Canada Ltd. E-Mail: fnasser@redhat.com 2323 Yonge Street, Suite #300 Toronto, Ontario M4P 2C9