How to import data frame with character column (RPostgreSQL)?

Question

I have a problem with import table using RPostgreSQL. I mean, one column is bigint format, and when I create simple query:

df<- dbGetQuery(con, "
                     SELECT euid
                     FROM table
                     LIMIT 5;")

I received

       euid
1 6.011e+18
2 5.010e+18
3 1.001e+18
4 6.012e+18
5 6.013e+18

Of course I do not wat to get logarithic notation. Instead just the same euid number as I have in database.

When I use options(scipen=999) I get

                 euid
 1 6011000000000000000
 2 5010000000000000000
 3 1001000000000173312
 4 6012000000000000000
 5 6013000000000000000

but real euid number in database is

          euid
   ---------------------
   6011000000000000150
   5010000000000000240
   1001000000000173341
   6012000000000000117
   6013000000000000119

It is possible to import all column in character format?

Krzysztof Jędrzejewski · Accepted Answer · 2015-02-05 15:53:02Z

2

Casting euid to TEXT should help, as this way it will not be treated as a numeric value.

df<- dbGetQuery(con, "
                     SELECT euid::TEXT
                     FROM table
                     LIMIT 5;")

answered Feb 5, 2015 at 15:53

Krzysztof Jędrzejewski

7084 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nicolabo Over a year ago

Thanks Krzysztof! You save my life!

Collectives™ on Stack Overflow

How to import data frame with character column (RPostgreSQL)?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related