address_metadata_for_company

Schema: `lib`

This function retrieves address metadata for all addresses tied to a company. It can also filter the results by a specific contract type.

lib.address_metadata_for_company(company text, contract_type text)

Name	Type	Description
company	text	The name of the company to retrieve address metadata for.
contract_type	text	(Optional) The type of contract to filter the results by. If left out, all address metadata for the company will be returned

The function returns a table with the following columns:

Column	Type	Description
account	text	The address that the metadata is associated with.
alias	text	The alias (friendly name) associated with the address.
context	jsonb	Additional context associated with the address.
created_at	timestamp	The timestamp when the address metadata was created.
updated_at	timestamp	The timestamp when the address metadata was last updated.

Retrieve all address metadata for the company Circle

select * from lib.address_metadata_for_company('Circle');