Postgresql find missing id

SELECT all_ids AS missing_ids
FROM generate_series((SELECT MIN(id) FROM your_table), (SELECT MAX(id) FROM your_table)) all_ids
EXCEPT 
SELECT id FROM your_table

Source: stackoverflow.com

Similar codes

1 vote332 views1 answer
Oracle get current schema
SQL
53 votes506 views6 answers
Sql server alter column
SQL
0 vote312 views1 answer
Sql use with to get value counts and percentages
SQL
0 vote300 views1 answer
How to check even or odd in sql
SQL
0 vote294 views1 answer
On update current_timestamp jpa
SQL
0 vote322 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
5 votes313 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
3 votes291 views1 answer
Show index table
SQL
0 vote293 views1 answer
Mysql command line ubuntu
SQL
0 vote294 views1 answer
Jooq replace
SQL