PostgreSQL connector shows dabase content

user007036 · May 2019

I am trying to pull in a dataset with PostgreSQL, and when I put in the credentials it shows the database, however it will not run. I am told that the database is called acct.chartofaccounts, although it just shows chartofaccounts. Is there something that needs to be entered in addition to pull in this database?

BrendanH · May 2019

Have you whitelisted the proper IP addresses in your server, if not you can find that list here,

https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/General_Guide_to_Connecting_with_Connectors/Whitelisting_IP_Addresses_for_Connectors

user007036 · May 2019

It ended up we needed to include part of the statement with "

select * from acct."databasename"

Thanks for your help.

PostgreSQL connector shows dabase content

Comments

Categories