Selecting random record

To select a random record from PostgreSQL table use the following SQL statement:

SELECT col_name
FROM table_name
ORDER BY random()
LIMIT 1;