-
wrote on Dec 16, 2021, 2:08 PM last edited by
Installed the Baserow app, how do I connect directly to the PostgreSQL database? Thank you.
-
-
-
-
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. -
wrote on Dec 16, 2021, 11:52 PM last edited byThis post is deleted!
-
wrote on Dec 17, 2021, 1:03 AM last edited byThis post is deleted!
-
wrote on Dec 17, 2021, 2:11 PM last edited by
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?
-
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?
-
@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?
wrote on Dec 17, 2021, 3:38 PM last edited by ebecker1 Dec 17, 2021, 3:49 PM@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
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?@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.