From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Tchouante, Merlin" <mtchouan@umaryland.edu>
cc: "pgsql-sql@lists.postgresql.org" <pgsql-sql@lists.postgresql.org>
Subject: Re: Returned row count doesn't match lines in output file
In-reply-to: 
 <BL0PR12MB2562AE54C7A5A8A680421FC7D2780@BL0PR12MB2562.namprd12.prod.outlook.com>
References: 
 <BL0PR12MB2562AE54C7A5A8A680421FC7D2780@BL0PR12MB2562.namprd12.prod.outlook.com>
Comments: In-reply-to "Tchouante, Merlin" <mtchouan@umaryland.edu>
	message dated "Thu, 07 Nov 2019 17:57:16 +0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <15358.1573149991.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 07 Nov 2019 13:06:31 -0500
Message-ID: <15359.1573149991@sss.pgh.pa.us>
Precedence: bulk

"Tchouante, Merlin" <mtchouan@umaryland.edu> writes:
> I'm executing an .sql file which looks like this:

> \o /home/bbuser/banner/gradeload/sodorgusers.txt
> \t on
> select u.user_id||'|'||u.firstname||'|'||u.lastname||'|'||u.email||'|'||=
u.student_id
> from users u, course_main cm, course_users cu
> where cu.crsmain_pk1 =3D cm.pk1
> and cu.users_pk1 =3D u.pk1
> and cm.course_id =3D 'Org.dent.Training'
> order by u.lastname, u.firstname;
> \t off
> \o

> When I look at the output file, it has a bunch of blank lines in between=
 the records but displays a line count of 4916.  What is causing the blank=
 lines?

Null values in one or more of the columns you're concatenating, perhaps?
Concatenating a null with something else yields null.  (See
coalesce() for one ad-hoc way to fix that.)

			regards, tom lane