Postgresql Custom Field save location

Post Reply
Simon
Posts: 6
Joined: 01 May 24 1:54

Postgresql Custom Field save location

Post by Simon »

Which postgresql table are the custom field entries stored in the postgres database?

I would like to select the custom entries in an external application.
How can I query the database to access the custom field entires?
Hert
Posts: 7910
Joined: 13 Sep 03 6:24

Re: Postgresql Custom Field save location

Post by Hert »

A warm welcome to the forum.

Try this to use that info in another application:
1. Select the thumbnails
2. Right click on a select thumbnail
3. Select Metadata -> Export Metadata to CSV File
4. Tick the custom fields you'd like to have included
This is a user-to-user forum. If you have suggestions, requests or need support then please send a message
Simon
Posts: 6
Joined: 01 May 24 1:54

Re: Postgresql Custom Field save location

Post by Simon »

Thanks Hert.

I was able to achieve what I needed with that approach, but it does add about 4 minutes to the process I do 3-4 times a week which adds up.

Is this data not saved in the postgres database?
Hert
Posts: 7910
Joined: 13 Sep 03 6:24

Re: Postgresql Custom Field save location

Post by Hert »

This is a user-to-user forum and my replies here are primarily limited to the existing feature set.

I do not promote connecting to the database directly using 3rd party tools. Should be fine for querying but never be tempted to make DML (update/delete/etc) statements.
This is a user-to-user forum. If you have suggestions, requests or need support then please send a message
Post Reply