PostGre SQL - EXPORT to CSV

[rene]

Hello Daminion Community,

Is it possible to export the Database to CSV?

 

The reason i ask is this:

 

I would like to see in excel which files are missing which entries.

 

e.g. is COLLECTION, or Copyright placed at every photo, etc

 

 

thanks

[Uwe]

Hi Rene,

one can select all items->right click->Export to CSV.

But I would use the "Advanced Search" function to check if e.g. "Collection is empty".

Regards, Uwe

[lintujuh]

Or you can select from the Tags pane the Collections/Events/... and the first entry in the category is Unassigned.

 

-Juha

[rene]

Thank you, i totally forgot about this topic! I tried to export as follows 

 

https://www.pgadmin.org/docs/pgadmin4/4.30/import_export_data.html

but the Import/export is greyed out

[WilfriedB]

1 minute ago, rene said:

but the Import/export is greyed out

Rene, you need to select at least one item before you can export to CSV. It allows you to export selected items, but not the complete catalog  (If I understand it correctly)

[rene]

I just found the possibility to export all files at once into a csv file!

1. opening the folder selecting all

2. upper right click export 

3. choose export to csv

4. select all tags

5. done