Posts about using the database server PostgreSQL.

Getting A Random Row From A PostgreSQL Table

10th January 2008 - 1 minute read time

To get a random row from a PostgreSQL database you need to use the RANDOM() function. This is similar to the MySQL function RAND() and will generate a new random number for each row and order them by that new number. This is used in conjunction with the LIMIT clause to limit the amount of returned rows to one.