Re: psql command and file size

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hugo <htakada(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: psql command and file size
Date: 2006-06-08 22:31:21
Message-ID: 2369.1149805881@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hugo <htakada(at)gmail(dot)com> writes:
> If I feed psql with a file with sql sentences, what is the size limit for
> the file,

There is no particular limit.

> I have a more or less 67MB file , with about 439.000 insert
> sentences, but only inserts 3900 rows, what can I do to "see" what insert
> sentences are failing ?

Check the postmaster log for errors, perhaps?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message pobox@verysmall.org 2006-06-08 22:57:06 Re: php 5.1.4 with PostgreSQL 8.1.4 causes Apache 1.3.36
Previous Message David Fetter 2006-06-08 22:30:51 Re: Fabian Pascal and RDBMS deficiencies in fully implementing the relational model