Postgres Pro
Downloads
Home   >   mailing lists

Re: last row of table after csv import - Mailing list pgsql-novice

From Henry Drexler
Subject Re: last row of table after csv import
Date
Msg-id CAAtgU9SSxYFWCfgaA6Jyot0xYoekr=x+=DzAR8mULi7LAJoqhA@mail.gmail.com
Whole thread Raw
In response to last row of table after csv import  (e-letter <inpost@gmail.com>)
Responses Re: last row of table after csv import  ("Daniel Staal" <DStaal@usa.net>)
List pgsql-novice
Tree view
On Mon, Oct 17, 2011 at 6:06 PM, e-letter <inpost@gmail.com> wrote:
Readers,

After csv of data, is there a command to navigate to the last row of
data in the database table, after import of csv data? The csv file is
not sorted, so the request is to view the last row after import. Now
after import, the keyboard key 'z' is pressed down until the last row
is shown in the command terminal!

Thanks in advance.

 
perhaps first do a 
select 
count(*) from table

then 

select
*
from
table
limit 1 offset (the result of your count(*) -1)

pgsql-novice by date:

Previous
From: Josh Kupershmidt
Date:
Subject: Re: last row of table after csv import
Next
From: e-letter
Date:
Subject: Re: last row of table after csv import