Row_Number - PostgreSQL

SELECT *, row_number() over (order by count) as idn
FROM temp_urut

COUNT    URUT    IDN
1    9    1
2    9    2
3    9    3
4    9    4
5    9    5

Menambahkan rownumber berdasarkan order  by
INSERT INTO "temporary".tmp_bukubesar
SELECT
ROW_NUMBER () OVER (

ORDER BY
tanggal_jurnal,
d_entry
),
user_id userid,
kodejurnal,
tanggal_jurnal,
d_entry,
debet,
kredit,
saldoakhir,
nomor_rekening,
keterangan,
nomorakun
FROM