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 <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
