retrieving attachments from mantis database(postgresql) session

[bpabla50]

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.

[cas]

well if you an access the database with a tool, you can retrieve a lot of info but you need to study the database scheme of mantis to get a coherent set of data. Other way can be to create a few scripts using Mantis functions to achieve what you want. It is not available out of the box