0

I would like to identify which links in a column are broken (i.e. no longer active/information no longer found). So ideally, I'm aiming for the output:

id   link   is_broken
1    url    true
2    url    false
3    url    true

Can this be obtained through PostgrSQL as opposed to using external tools? Note that I'm working on Metabase.

Joehat
  • 979
  • 1
  • 9
  • 36
  • Check this : https://stackoverflow.com/questions/3325292/how-can-i-send-some-http-request-from-postgresql-function-or-trigger but i don't think it's the role of the database to do that. A deamon/service testing urls every x days and refreshing a table with the results would be more pertinent – kipy Oct 13 '22 at 09:31

0 Answers0