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;
create auto increment row with select in postgreSQL
原文：http://www.cnblogs.com/phoenix13suns/p/4430912.html