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 <ronljohnso...@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. > >
