how to retrieve project names from jira database for the mentioned Github repositories or account

[Santhosh Vegolam]

I want the query to run in my Postgres database to retrieve project names which projects are linked to mentioned GitHub repositories or account from Jira database

please help me with the query to run in postgres

Thanks

santhosh 

[Sean Binny]

Please look at https://developer.atlassian.com/server/jira/platform/attachments/jira-7-9-2-database-schema.pdf

The table storing this association is jiradb.AO_E8B6CC_REPO_TO_PROJECT

Sean Binny

Product Manager

At a Glance Plugin