2011/4/14 Ismael L. Donis García <ismael@...>:

> Replace all:
>
> select * from table
>
> for
>
> select t.* from table t
>

Actually, I'd suggest replacing the first version
with

select <column list> from ThisTable t

The * is a handy thing in an interactive tool or a throw-away program
but one of the strengths of the relational model is separation of logical
and stored formats, leading to the ability to add columns to a table
and change column types. As soon as your application builds in
knowledge of the number of columns in a table you've blocked that
ability... unless you create a layer of views over the tables to preserve
the old formats, which begins to confuse the naming of things.

Good luck,

Ann