search_address_metadata
Schema: lib
Description
This function allows you to search for address metadata by account, alias, or context using a provided "search_term". The "search_term" can be any valid Postgres tsquery to use for searching.
Usage
Signature
lib.search_address_metadata(search_term text)
Parameters
Name | Type | Description |
---|---|---|
search_term | text | The term to find within address metadata. |
Results
Column | Type | Description |
---|---|---|
account | text | The address of the account/contract |
alias | text | The alias for account |
context | jsonb | Alll context associated with the account |
Examples
Search for address metadata by account
select *
from lib.search_address_metadata('0x461ee1a16d5259448f45981a77320bacae839ff1');
Search for address metadata related to USDC
select * from lib.search_address_metadata('USDC');
Search for address metadata for Steadefi accounts related to both USDC and WBTC
select *
from lib.search_address_metadata('steadefi & usdc & wbtc');
Search for address metadata for Steadefi accounts related to either USDC or WBTC
select *
from lib.search_address_metadata('steadefi & (usdc | wbtc)');
Search for address metadata with any words beginning with the letters 'hov'
select *
from lib.search_address_metadata('hov:*');