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

works similar like oracle rownum.