Skip to main content

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

NameTypeDescription
search_termtextThe term to find within address metadata.

Results

ColumnTypeDescription
accounttextThe address of the account/contract
aliastextThe alias for account
contextjsonbAlll 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:*');