Home/ Questions/Sample about "random function in postgresql"
Next
Answered
Aaron Rodriguez
  • 12
Asked: 2022-04-18T13:09:40+00:00 In:

Sample about “random function in postgresql”

  • 12

. Advertisement .

..3..

. Advertisement .

..4..

Where can I get some samples to “random function in postgresql”? I count on the support from you guys.

♦ Suggestions of ITtutoria Team
Idea for “random function in postgresql”: The random function in Postgresql is a SASL-enabled function that returns a random integer between 0 and the value passed to it.

......... ADVERTISEMENT .........

..8..

Source: w3resource.com

Share

1 Answer

  1. Best Answer

    Here is an example that uses the random function, you can refer to them

    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)
​
    • 5

Leave an answer

You must login to add an answer.

Need An Account,