Re: Copying data from a CSV file into a table dynamically

Поиск
Список
Период
Сортировка
От Ruiqiang Chen
Тема Re: Copying data from a CSV file into a table dynamically
Дата
Msg-id CA+yjgPTXs9hQfSt4SiMzUxo4U5HxKy2U4NbDT+cwqjZ8gOGeKw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Copying data from a CSV file into a table dynamically  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: Copying data from a CSV file into a table dynamically  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
CSV file has no limitation of # of rows, excel max row is 2^20. Am I correct? 

On Tue, Aug 14, 2018 at 9:46 AM, Ron <ronljohnsonjr@gmail.com> wrote:
On 08/14/2018 08:38 AM, pavan95 wrote:
Hi Adrian,

I tried to use
*"COPY postgres_log1 FROM '/tmp/abc/xyz/postgresql-`date --date="0 days ago"
+%Y-%m-%d`_*.csv' WITH csv;"*

But it resulted in an error. How to issue such that it is understandable by
psql?

And I am completely unaware of python & psycopg2. Anything which suits my
requirement is enough!!ostgresql-archive.org/PostgreSQL-general-f1843780.html

Why not:
cat /tmp/abc/xyz/postgresql-`date --date="0 days ago"+%Y-%m-%d`_*.csv' | \
       psql YOURDB -c "COPY postgres_log1 FROM STDIN WITH csv;"

--
Angular momentum makes the world go 'round.


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

Предыдущее
От: Vik Fearing
Дата:
Сообщение: Re: Vacuum process waiting on BufferPin
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Copying data from a CSV file into a table dynamically