Re: default data sort - Mailing list pgsql-general

From David Fetter
Subject Re: default data sort
Date
Msg-id 20090621181300.GF7651@fetter.org
Whole thread Raw
In response to default data sort  (Michael Fraley <fraley@usfca.edu>)
List pgsql-general
On Sun, Jun 21, 2009 at 11:01:59AM -0700, Michael Fraley wrote:
> How can I change the default data sort for a table?  When I view the
> data  in the selected table, it always opens a spreadsheet view
> sorted by the  primary key.  In this case, the primary key is a
> one-up number and a more  useful sort is the name column.  How can I
> have it default to sort by  name rather than primary key?

Whatever tool you're using for visualization can sort for you.

In SQL, tables don't have an ordering, so any ordering is the
responsibility of external tools.

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

pgsql-general by date:

Previous
From: Michael Fraley
Date:
Subject: default data sort
Next
From: Michael Fraley
Date:
Subject: subscribe-set pgsql-general digest