It is easy to create view based on SELECT which explicitly specifies the columns names. IMO it is better to hide tables structures behind views and work with them, since views are not materialized and it is easy to drop and recreate or just add another view into the database. With this approach you can than SELECT * FROM my_view without care of physical ordinal positions in a tables.
2010/11/24 Grzegorz Jaśkiewicz <gryz...@gmail.com> > just never use SELECT *, but always call columns by names. You'll > avoid having to depend on the order of columns, which is never > guaranteed, even if the table on disk is one order, the return columns > could be in some other. > -- // Dmitriy.
