Description
Retrieves the contents of a database table
Positional Parameters
account
TEXT - The account who owns the table where the smart contract was deployed
scope
TEXT - The scope within the contract in which the table is found
table
TEXT - The name of the table as specified by the contract abi
Options
-l,--limit
UINT - The maximum number of rows to return
-k,--key
TEXT - (Deprecated) The name of the key to index by as defined by the abi, defaults to primary key
-L,--lower
TEXT - JSON representation of lower bound value of key, defaults to first
-U,--upper
TEXT - JSON representation of upper bound value value of key, defaults to last
--index
TEXT - Index number, 1
: primary (first), 2
: secondary index (in order defined by multi_index), 3
: third index, etc. Number or name of index can be specified, e.g. secondary
or 2
--key-type
TEXT - The key type of --index
; primary only supports i64
. All others support i64
, i128
, i256
, float64
, float128
, ripemd160
, sha256
. Special type name
indicates an account name
--encode-type
TEXT - The encoding type of --key_type
; dec
for decimal encoding of (i[64|128|256]
, float[64|128]
); hex
for hexadecimal encoding of (i256
, ripemd160
, sha256
)
-b,--binary
UINT - Return the value as BINARY rather than using abi to interpret as JSON
-r,--reverse
- Iterate in reverse order
--show-payer
- Show RAM payer
Example
Get the data from the accounts table for the eosio.token contract, for user eosio,
cleos get table eosio.token eosio accounts
{
"rows": [{
"balance": "999999920.0000 SYS"
}
],
"more": false
}