Community
Q&A
Confluence
Questions
Confluence 6.2/Oracle : which database table contains content of Confluence pages

Confluence 6.2/Oracle : which database table contains content of Confluence pages

Hi,

Do you know if this is possible to identify the database table name in which the content of all pages is stored ? We would like to implement application that connects with Confluence database in read-only mode (in this case it is Oracle,) and retrieve the content of a few pages for further analysis.

Thank you for help,
Rafal

1 answer

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

2 votes

Answer accepted

The table is Bodycontent, but you really do not want to do this.

To make sense of the content, you're going to have to write a parser to read and interpret the content into something you can read and analyse properly.

If you do this the right way, instead of SQL, it will be far easier - use REST to get the content.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thank you Nic, I think you are right and we should switch to REST. Do you know if there is any document showing how to get a page content using REST ?

Best regards,
Rafal