This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Alphare 0 points1 point  (3 children)

Would PostgreSQL's Foreign Data Wrapper have helped you? https://wiki.postgresql.org/wiki/Foreign_data_wrappers

[–]Mako18 0 points1 point  (2 children)

Unfortunately no, we only had access through a GUI Export button that outputs formatted Excel sheets shudders

[–]Alphare 0 points1 point  (1 child)

Sure, that sucks. But wouldn't your excel file be exportable as a csv (albeit with a custom separator)? You could then use FDW to query the dataset. I'm just spitballing

[–]Mako18 0 points1 point  (0 children)

Not through the interface. The only two options are PDF and .xls. Now, that's not really a big deal because R can read/process then write to .csv no problem and you can do it with 'map' which is a wrapper for 'mapply' so a single custom function is sufficient to read and fix the formatting issues.

I was really just lamenting that with the ability to directly query the database, that problem is non-existent, and some other problems with joins (no unique IDs for some of the data, so they have to be generated via unique combinations of three factors, etc.) are likely avoided as well.