I migrate a wiki that had a lot of broken link to a domain that no longer exist. How can I massively update my database, instead of change any single link?

My idea is to connect in postgres and update manually the database with

update table set field = replace(field, 'cat', 'dog')

Someone think it's possible? In which table and field I can found my entries?

  • I think this question is better suited for stackoverflow.com, not apple.stackexchange.com – CousinCocaine May 6 '15 at 11:20
  • I'm voting to close this question as off-topic because I'm not really sure where it belongs, but it has nothing to do with Apple or anything related to Apple hardware or software. – Ɱark Ƭ May 6 '15 at 11:29
  • @Mark This is the wiki in the server app so is on topic - and is not really code so unlikely to be on topic for stackoverflow more like configuration so I think this is the best place (and see if notification to Mark works :() – user151019 May 6 '15 at 13:18
  • @Mark I missed that it was was specified in the tags and not in the question itself. And yes, the notification worked. I think the question could be made more clear by adding in the version of the OS and Server.app that is being used. It might make a difference. – Ɱark Ƭ May 6 '15 at 14:19
  • Sorry if I not specified that i was talking (of course) of Server App's Wiki that is different from the others. I use the last version (OS X 10.10.3 and Server.app 4.1): I don't specified it cause wiki's structure (table an database) are the same in Mavericks. – cristianof May 6 '15 at 17:00

You must log in to answer this question.

Browse other questions tagged .