Rownum in postgresql

Question

Is there any way to simulate rownum in postgresql ?

Answer 1

I have just tested in Postgres 9.1 a solution which is close to Oracle ROWNUM:

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