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

Поиск
Список
Период
Сортировка
От pavan95
Тема Re: Copying data from a CSV file into a table dynamically
Дата
Msg-id 1534253907682-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: Copying data from a CSV file into a table dynamically  (Adrian Klaver <adrian.klaver@aklaver.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  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
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!!

Thanks in Advance

Regards,
Pavan



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html


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

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