Random unique identifier generator for PostgreSQL

[ypandit]

• uniquename are required for strains, plasmids, genotype, phenotype, environment
• Namespaces used

Data	Namespace
strain	DBS
plasmid	DBP
genotype	DSC_G
phenotype	?
environment	?

• We need a PostgreSQL random number generator that can be used with each of these namespaces.
• Check how it will work with more than 1 simultaneous queries!

Ref: Legacy Oracle codebase (for similar functionality in Oracle)

[ypandit]

• Stackoverflow - SELECT nextval in multiuser env
• PostgreSQL - Sequence functions