Re: Import csv to temp table

Поиск
Список
Период
Сортировка
От Paolo Saudin
Тема Re: Import csv to temp table
Дата
Msg-id CADtZQgmiypdTa=nDvCprXqn1bGF++ga4fLDbMFnbRXdeWijB6Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Import csv to temp table  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Import csv to temp table
Список pgsql-general
Il giorno mar 2 gen 2024 alle ore 21:17 Adrian Klaver <adrian.klaver@aklaver.com> ha scritto:
On 1/2/24 11:47, arun chirappurath wrote:

Reply to list
Ccing list
> Hi Adrian,
>
> Love this tool..however it doesn't like supporting RDS.

1) This was Daniel Vérité's suggestion not mine.

2) Define "... doesn't like supporting RDS".

a) You can generate an SQL statement without connecting to the database.
Then use that statement directly in the database.

b) If SQLAlchemy can reach the database then csvkit should be able to.

>
> https://csvkit.readthedocs.io/en/latest/
> <https://csvkit.readthedocs.io/en/latest/>
>
> Regards
> Arun
>


--
Adrian Klaver
adrian.klaver@aklaver.com


 
You can user pgloader (https://pgloader.io/) as well to load data from CSV to Postgres
Paolo 

В списке pgsql-general по дате отправления:

Предыдущее
От: "PGUser2020"
Дата:
Сообщение: Re: PostgreSQL 11 packages gone from reporpms?
Следующее
От: Ryan Kelly
Дата:
Сообщение: Re: Import csv to temp table