Help with setting up table and importing data.

Поиск
Список
Период
Сортировка
От Ronnie Doggart
Тема Help with setting up table and importing data.
Дата
Msg-id 35ED76D6.53ABF841@netcomuk.co.uk
обсуждение исходный текст
Список 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


В списке pgsql-sql по дате отправления:

Предыдущее
От: Maarten Boekhold
Дата:
Сообщение: Re: [SQL] upper() and lower() on varchar
Следующее
От: Ronnie Doggart
Дата:
Сообщение: Forming Query