PostgreSQL allows you to get specific row id for your table. Here’s how to get row number in PostgreSQL using row_number window function.
How to Get Row Number in PostgreSQL
generate_series
How to Fill Missing Dates in PostgreSQL using generate_series
It is important to fill missing date values while plotting data on graphs. Here’s the SQL query to fill missing dates using PostgreSQL generate_series.