sql-for-r-users icon indicating copy to clipboard operation
sql-for-r-users copied to clipboard

Provide a case for why Postgre > SQLite

Open jaeyk opened this issue 5 years ago • 0 comments

One example is the limitation to deal with datetime.

Let's say df contains a field that is defined as datetime using as.POSIXct.

if we copy_to(dest = database, df = df)

then

the table doesn't get datetime correctly as SQLite doesn't support it.

jaeyk avatar Sep 16 '20 07:09 jaeyk