SOLVED How to PostgreSQL Database Direct Connection?

[ebecker1]

Installed the Baserow app, how do I connect directly to the PostgreSQL database? Thank you.

[nebulon]

Are you trying to connect to some external Postgres database or the internal one for the app?
For the internal one you can open a webterminal into the app from your Cloudron dashboard and you will find a postgres button on the top right.

[ebecker1]

This post is deleted!

[ebecker1]

This post is deleted!

[ebecker1]

Thanks, I found the postgre terminal from the cloudron dashboard.

However, I'd like to import large amounts of data into my Baserow database, how can I upload a CSV file and get it loaded into a table? Maybe I need to load the file somewhere and then reference it in a command to copy it to table?

[nebulon]

@ebecker1 hm this may probably more of an baserow application question. Have you looked into their documentation how to import large data sets and what the best option for this is?

[ebecker1]

@nebulon
Seems I need a direct connection to the database, but I don't know how to reference the load file via the cloudron webterminal.

To load data into a PostgreSQL database I can run this from the command line:
\COPY "[table]"([field1],[field2],[field3]) FROM '[file location]' DELIMITER ',' CSV HEADER;

How and where, do I load and specify [file location], on cloudron?
Can I connect from my PC to the database directly and then be able to reference a file on my machine? Maybe via Cloudron CLI?

[nebulon]

@ebecker1 there is no easy way to connect to the database from outside. However I am not sure at all if your approach here is correct. I would assume the app has better ways to import data besides tinkering with the underlying database as that seems quite the risky operation and might break the app itself.