Cloudron Forum

@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?

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?

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