Help with setting up table and importing data.

From: Ronnie Doggart <rdoggart(at)netcomuk(dot)co(dot)uk>
To: pgsql-sql(at)postgresql(dot)org
Subject: Help with setting up table and importing data.
Date: 1998-09-02 16:48:23
Message-ID: 35ED76D6.53ABF841@netcomuk.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Ronnie Doggart 1998-09-03 11:56:45 Forming Query
Previous Message Maarten Boekhold 1998-09-02 13:40:44 Re: [SQL] upper() and lower() on varchar