Getting primary key sequence number in postgres – SEO
We've got a table where we're exposing a ShortID to our consumers that generates a Youtube like identifier (heavily inspired by this SO post). We use the primary KEY of the row to generate it (in the view). For example…