Answers for "postgres get random record"

SQL
1

generate random data postgresql

insert into towns (
    code, article, name, department
)
select
    left(md5(i::text), 10),
    md5(random()::text),
    md5(random()::text),
    left(md5(random()::text), 4)
from generate_series(1, 1000000) s(i)
Posted by: Guest on August-25-2021
0

postgres random select

select * from app_product order by random() limit 10;
Posted by: Guest on February-26-2021

Code answers related to "postgres get random record"

Code answers related to "SQL"

Browse Popular Code Answers by Language