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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Ruiqiang Chen <chenrq2005(at)gmail(dot)com>
Cc: Ron <ronljohnsonjr(at)gmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Copying data from a CSV file into a table dynamically
Date: 2018-08-14 14:25:08
Message-ID: CAKFQuwZhj_Wz=07-QK2ADbSZh1bGfp7HOf2LtyhW1e5azZrcOA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday, August 14, 2018, Ruiqiang Chen <chenrq2005(at)gmail(dot)com> wrote:

> CSV file has no limitation of # of rows, excel max row is 2^20. Am I
> correct?
>

It's considered bad form to hijack threads in this manner.

Text files have no inherent limits. You can check the Excel documentation
for the version you care about to learn it's limits.

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ravi Krishna 2018-08-14 14:27:49 What is the use case for UNLOGGED tables
Previous Message Mike Cardwell 2018-08-14 14:18:24 pg_basebackup failed to read a file