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@xxxxxxxxx> 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.ht ml
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.
