Postgres Pro
Downloads
Home   >   mailing lists

Selecting the last 2 rows of a table - Mailing list pgsql-novice

From Machiel Richards
Subject Selecting the last 2 rows of a table
Date
Msg-id 1289295288.2280.28.camel@machielr-laptop
Whole thread Raw
Responses Re: Selecting the last 2 rows of a table  (Thom Brown <thom@linux.com>)
Re: Selecting the last 2 rows of a table  (Majid Azimi <majid.merkava@gmail.com>)
Re: Selecting the last 2 rows of a table  (Frank Bax <fbax@sympatico.ca>)
List pgsql-novice
Tree view
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.


      I would appreciate any assistance in this.


Regards
Machiel

pgsql-novice by date:

Previous
From: Vaduvoiu Tiberiu
Date:
Subject: Delete low priority equivalent in postgresql?
Next
From: Thom Brown
Date:
Subject: Re: Selecting the last 2 rows of a table