Re: default data sort

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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

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