Re: Newbie-question

From: Andrew Ayers <aayers(at)eldocomp(dot)com>
To: Victor Spång Arthursson <victor(at)tosti(dot)dk>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Newbie-question
Date: 2003-10-28 15:57:01
Message-ID: 3F9E91CD.6070407@eldocomp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Victor Spång Arthursson wrote:
> Are presently converting from mysql to postgresql, and my first
> newbiequestion is how to make all the rows in a result from a select
> just "swosh" by? That is, I dont want to see them page for page; just to
> scroll by so I can se the last line with the number of corresponding rows.

You seem to want to see the number of corresponding rows, not the stuff
"swish" by - or at least, I would hope you are more interested in the
count and not just text flying by...

In that case, do a "select count(*) from" SQL select...

Andrew Ayers
Phoenix, Arizona

-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.

Browse pgsql-general by date

  From Date Subject
Next Message Marco Colombo 2003-10-28 15:57:34 Re: [OT] Choosing a scripting language.
Previous Message Fernando Nasser 2003-10-28 15:51:41 Re: Versioning control in PostgreSQL?