How to auto-populate fields from Database query?

[Randall Hinds]

I have just connected our Confluence page to our PostgreSQL DB, and I can set Field Definitions to query individual fields successfully. 

Using the Dynamic Dropdown (database) field type, I'd like to query a column by a unique ID and then populate other fields from other DB columns in that same row.

Not having much DBAdmin or query experience, I am struggling to figure this out.  It seems this is the right place to start, though... 

Dynamic dropdown field with the choices served from a database query. Make sure you have a column ID in your query, and it is unique - this will be used as identifier and stored in ConfiForms for later lookups. You can have multiple columns returned. All values then can be referenced through this field and shown in ConfiForms views. Second column will be used as a label for a dropdown choice