Received: from camelot.netcom.net.uk (root@camelot.netcom.net.uk [194.42.225.1]) by hub.org (8.8.8/8.7.5) with ESMTP id LAA04438 for ; Wed, 2 Sep 1998 11:41:16 -0400 (EDT) Received: from netcomuk.co.uk (dialup-14-05.netcomuk.co.uk [194.42.231.133]) by camelot.netcom.net.uk (8.8.8/8.8.8) with ESMTP id QAA20590 for ; Wed, 2 Sep 1998 16:41:06 +0100 (BST) Sender: root@camelot.netcom.net.uk Message-ID: <35ED76D6.53ABF841@netcomuk.co.uk> Date: Wed, 02 Sep 1998 16:48:23 +0000 From: Ronnie Doggart Organization: Trinity Group Ltd. X-Mailer: Mozilla 4.05 [en] (X11; I; Linux 2.0.34 i586) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Help with setting up table and importing data. Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi All, I am new to using Postgresql but use Oracle in work. I want to set up a table with four fields, such as part-number, description, cost, status. The cost field is the only numeric field. I want to import the data to the table from a file which has the cost stored as 73400 which represents $734.00, the decimal is implied. How can I load this into a table where I have defined cost to be of type money. Regards Ronnie Doggart