Re: Selecting the last 2 rows of a table

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Selecting the last 2 rows of a table
Date: 2010-11-09 12:05:17
Message-ID: 4CD938FD.6070605@sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Machiel Richards wrote:
> Good day all
>
> I am trying to find out how I can select the last 2 or (n amount )
> of rows from a specific table.
>
> We have a table which has been growing rediculously the last view
> days (I must say after a code go-live).
>
> I am trying to find out what data is being written to the table
> that is causing this, however due to the size of the table at the
> moment, it can cause problems so I am just interested in the last number
> of records.

Compare two backup files.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Vaduvoiu Tiberiu 2010-11-09 13:46:09 MySql Concat function equivalent
Previous Message Majid Azimi 2010-11-09 09:48:42 Re: Selecting the last 2 rows of a table