Обсуждение: default data sort

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?

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