create at increment row with select in postgreSQL
880 ワード
http://stackoverflow.com/questions/3959692/rownum-in-postgresql
SELECT
row_number() OVER (ORDER BY col1) AS i,
e.col1,
e.col2,
...
FROM ...
ORselect row_number() over() as id, t.*
from information_schema.tables t;