how to see postgres database table in opdk

[rohanjangid]

hi folks,

I wanted to see the table where the analytics data are stored 

I found resource from apigee https://docs.apigee.com/private-cloud/v4.19.06/how-monitor#postgres 

but I want to see the table of Postgres database 

Thanks.

[cjking · Accepted solution]

The version of postgres that Apigee ships is still postgres, so basically all standard postgres commands should still work. (Whether they're officially supported and whether Apigee will still work if you use those commands to make changes is different matter of course)

This means psql's \d command (https://www.postgresql.org/docs/10/app-psql.html) still works as expected, and is probably what you want.

[rohanjangid]

thanks for the clarification I would like to ask one more thing

"Does Postgres store personal data"

means that ever data I am sending in the payload that 

[cjking]

Postgres won't contain your API payload data by default. If you use the StatisticsCollector to do funky things then all bets are off, but that's easily avoided.

Depending on your definition of "personal data", Postgres will contain some things that you should be aware of but which are not part of the API payload - client IP addresses, developer details (name, email) etc.