Skip site navigation (1) Skip section navigation (2)

Re: last row of table after csv import

From: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
To: e-letter <inpost(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: last row of table after csv import
Date: 2011-10-18 02:50:36
Message-ID: CAK3UJRHvOwEMCz+QaHd70=xPoFjoWEEnGf3AREndcJQgNfzAMQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Mon, Oct 17, 2011 at 6:06 PM, e-letter <inpost(at)gmail(dot)com> wrote:
> 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!

Uh, what interface are you using to talk to PostgreSQL (e.g. pgAdmin,
phpPgAdmin, psql, something else?). If the tool you're using lets you
enter SQL queries, you should be able to enter a SELECT query with
ORDER BY and LIMIT to get the result you need. You will have to figure
out what you mean by "last row", i.e. what column(s) you give to ORDER
BY.

If you're not using psql, you might have to ask on a forum specific to
the interface you're dealing with (this list is fine for questions
about psql).
Josh

In response to

Responses

pgsql-novice by date

Next:From: Henry DrexlerDate: 2011-10-18 11:34:00
Subject: Re: last row of table after csv import
Previous:From: Josh KupershmidtDate: 2011-10-18 02:42:09
Subject: Re: Partitioning with a lot of number of partitions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group