On 18/10/2011, Josh Kupershmidt <schmiddy@gmail.com> wrote:
> On Mon, Oct 17, 2011 at 6:06 PM, e-letter <inpost@gmail.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.
>
No interface, using command terminal to enter sql commands.
The csv file of data is not ordered in any way, so I expect the
command '\copy' to import data into a table without changing the
relative positions of data.