title: Postgres Dynamically Create Sequences
body: <p>I'm writing an application where there are multiple users are users can upload reports within the application.</p>
  
  <p>Currently, I have a 'reports' table that holds all of the submitted reports which has an 'id' field that is a serial primary key on the table.</p>
  
  <p>The requirements I have specify that users need to be able to specify a prefix and a number for their reports to start counting from. For example, a user should be able to say that their reports start at ABC-100, then the next one is ABC-101, ABC-102, and so on and so forth.</p>
  
  <p>The way I'm thinking of achieving this is that when a user creates an account, he can specify the prefix and start number, and I will create a postgres sequence with the name of the prefix that is specified and a minValue of the number the user wants reports to start at.</p>
  
  <p>Then when a user submits a new report, I can mark the report_number as nextval(prefix_sequence). In theory this will work, but I am pretty new to postgres, and I want some advice and feedback on if this is a good use of sequences or if there is a better way.</p>