Search Postgresql Archives

Re: PostgreSQL Top 10 Wishlist

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



As a service for the non-dutch speaking people, the abstract of Frank's
comment (hi Frank ;-)):

On Wed, 2006-01-18 at 09:10 +0100, ir. F.T.M. van Vugt bc. wrote:
> Op woensdag 18 januari 2006 08:10, schreef Joost Kraaijeveld:
> > Because a lot of tools that I use to manage a database during
> > *development* (e.g. PgAdmin) show the columns in an other order than the
> > order of attributes in my Java/C++ code. The "logical" order of the
> > columns/attributes can change during development.
> 
> Ter info, ik snap je vraag om ondersteuning van dit 'geintje' middels een 
> regulier system command, maar als het erg belangrijk is voor je of 
> incidenteel valt het nu ook te editten via de system tables. Iets van 
> 'ordinal position' in de table/field definitions, maar het is al erg lang 
> geleden dat ik daar mee gespeeld heb ;) Je kunt dit terugvinden in 'select * 
> from information_schema.columns', maar je zult zelf even terug moeten zoeken 
> welke systeemtabellen daar bij zijn betrokken, ik denk overigens dat dit 
> pg_attribute.attnum is. Denk eraan dat dit soort wijzigingen in de 
> systeemtabellen zonder garantie komen...... ;)

If the order of the columns is *really* important, than one could try to
change the system tables.

My point is not that I really want it, but that i can see reasons why
one could want it. Especially if one must learn how an application
interacts with a database, it is nice te be able to see the relation
between a class, it's attributes and the tables with the columns.

-- 
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@xxxxxxxxxx
web: www.askesis.nl 




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux