retrieving attachments from mantis database(postgresql) session
Posted: 20 Mar 2023, 14:51
Hi :
Since I am not able to export some information to CSV file e.g. attachments, relationship table etc. I am wondering, can these be retrived using SQL commands of postgresql database.
I am logged into database session, how the syntax of SELECT will look like , if I want to a) retrieve all attachments of a given issue b) retrieve all attachments for the whole project covering every issue of that project?
Any advice? Thanks.
Since I am not able to export some information to CSV file e.g. attachments, relationship table etc. I am wondering, can these be retrived using SQL commands of postgresql database.
I am logged into database session, how the syntax of SELECT will look like , if I want to a) retrieve all attachments of a given issue b) retrieve all attachments for the whole project covering every issue of that project?
Any advice? Thanks.