<p>Assuming that an NFT is implemented as a multiasset (pretty sure that is not the only way) then this is relatively trivial:</p>
<pre><code>select * from ma_tx_out where tx_out_id = &lt;insert your tx_out id here&gt; ; 
</code></pre>

CC BY-SA 4.0
2022-06-28T07:16:32.840Z
2022-06-28T07:16:32.840Z
Erik de Castro Lopo
<p>Is it possible to find out if an UTxO on the tx_out postgres table holds an NFT? OR in generell which kind of asset this UTxO holds?</p>
<p>Thank you!</p>

<nft><cardano-db-sync><utxo><metadata>
How can I see if an UTxO holds an NFT in the postgres DB?
# How can I see if an UTxO holds an NFT in the postgres DB?

(Asked by: username_0 on 2022-06-28)

Is it possible to find out if an UTxO on the tx\_out postgres table holds an NFT? OR in generell which kind of asset this UTxO holds?

Thank you!

**Tags:** nft, cardano-db-sync, utxo, metadata

---

## 1 answers

### Answer by username_1 on 2022-06-28. Score: 2

Assuming that an NFT is implemented as a multiasset (pretty sure that is not the only way) then this is relatively trivial:
select * from ma_tx_out where tx_out_id =  ;


---

