[R-sig-DB] dbWriteTable in RPostgreSQL can't handle date and timestamp data types.

[Xiaobo Gu]

Can we specify data types for columns of the table created by
dbWriteTable, most times we want timestamp without timezone.
Another case is numeric numbers, in current implement all numeric data
are converted as float, but for some applications want it to be
decimal with scales,

Xiaobo Gu


On Mon, Mar 7, 2011 at 6:37 PM, Tomoaki NISHIYAMA
<tomoakin using kenroku.kanazawa-u.ac.jp> wrote:
> Hi,
>
>>> class(df[["c"]])
>>
>> [1] "Date"
>>>
>>> class(df[["d"]])
>>
>> [1] "POSIXct" "POSIXt"
>
>
> Ok, if you know the class name, the change is simple as r179.
> (r178, r180 are cleanups of other part)
> --
> Tomoaki NISHIYAMA
>
> Advanced Science Research Center,
> Kanazawa University,
> 13-1 Takara-machi,
> Kanazawa, 920-0934, Japan
>
>