search

wireservice / csvkit

A suite of utilities for converting to and working with CSV, the king of tabular file formats.
https://csvkit.readthedocs.io
MIT License
6.03k stars 603 forks source link

Apologies if i asked in wrong place #1228

Closed arunsnmimt closed 10 months ago

arunsnmimt commented 10 months ago

Hello All,

Does csvkit support RDS postgres database for csvsql dataload?

Thanks,

jpmckinney commented 10 months ago

Yes, it's the same as any other PostgreSQL database. You'll probably need to set Public access to “Yes” in AWS console.

arunsnmimt commented 10 months ago

Can you kindly provide a sample connection string ?

jpmckinney commented 10 months ago

postgresql://USER:PASSWORD@HOST:PORT/DB_NAME same as usual.

Please refer to AWS support and AWS questions on Stack Overflow. Nothing about this is specific to csvkit.