Fairly straightforward if you just need a listing in a text file. Two main areas of choice:

1. Which fields do you want to include, apart from the project name ?
2. How should the fields be delimited : tab characters ? CSV ?

If you wanted to export any date fields, you would also need to choose a date format. You might also want to decide whether you really want every project in the database (including completed ones, for example), or just projects that have some particular status.

(Every now and then I spend a little time on a more general solution to this problem (an extension to Where in OF for generalised exporting, using an applescript-based query language rather than SQL) but a promise of water doesn't quench thirst, and the project is not advanced or high on my agenda, so I'm very happy to scribble something quick, simple and indicative in the meanwhile).

--