On 08/06/2010 17:47, Bob McConnell wrote: > I have been using 8.4 and just installed 10.3. Both have a menu option > to view the first 100 records of a table. I have several tables on both > development and QA servers with several thousand records in them. I only > need to see the most recent. Is there a simple way to view the last 100 > records in a table?
You'll need to do SELECT.... ORDER BY .... DESC LIMIT 100 from an edit window - there's no "built-in" way of doing it from a menu item. The definition of "first" and "last" is always going to be situation-dependent in any case... I think the the menu item does it based on the primary key, and your specific needs may differ. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
