create auto increment row with select in postgreSQL

http://stackoverflow.com/questions/3959692/rownum-in-postgresql

SELECT 
    row_number() OVER (ORDER BY col1) AS i, 
    e.col1, 
    e.col2, 
    ... 
FROM ...

OR

select row_number() over() as id, t.*
from information_schema.tables t;