For this , its easy, just using RANDOM() built-in function in PostgreSQL Above example we will get a random key value from the table KEY_STORE . Everytime execute it will get a random score VALUE.
The default schema in PostgreSQL is “public“. Some time you need to change it for some raisons (Example Migration of DB)Before start to change, you have to check what is current PostgreSQL default schema ? for that run this command : check the DB config to set the new schema , use this command : […]