dbWriteTable in RPostgreSQL can't handle date and timestamp data types.
2011/3/8 Peng Lian <januslian at 126.com>:
At?2011-03-07?20:32:42?"Xiaobo?Gu"?<guxiaobo1982 at gmail.com>?wrote:
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
I think you can specify?data?types. Checking out the source file of RPostgreSQL package, the function of dbWriteTable use argument *filed.types* to specify data?types, so through modifying default value of *filed.types*, which is represent by data type in PostgreSQL, may specify?data?types.
Since I can't find any documentation about this, can you show me some sample code about specifying data types. Another feature we want is that we only want to specify the data type for columns that we think the automatically mapping implemented by RPostgreSQL is not suitable to us. For example, supporse we have a data frame with about 100 columns, only a few of which are numeric numbers,such as col1/col2/col3, we want the column types to be decimal(18,2), but not float8, users only need to pass col1/col2/col3 to the function, and let RPostgreSQL choose the data types for the rest of the columns.
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 at 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 >> >> >
_______________________________________________ R-sig-DB?mailing?list?--?R?Special?Interest?Group >R-sig-DB at r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-db