Name

dns_txt_get — Use for DNS text record retrieval.

Synopsis

varchar dns_txt_get ( in dns_serevr_ip_or_null any ,
in dns_entry varchar );

Description

This function can be used for DNS text record retrieval. It works on UNIX, Windows, Mac OS X w/o additional libraries.

Parameters

dns_serevr_ip_or_null

DNS server IP or null. If null, then the system will try to find the system defined DNS servers. First argument null together with xenc_key_RSA_read() with 3d argument of 1 (int) can be used to write a PL procedure for DKIM signature check of mails.

dns_entry

DNS entry.

Examples

Example24.156.Obtaining DNS text record

SELECT dns_txt_get (null, 'x._domainkey.example.com');
dns_txt_get
VARCHAR
_______________________________________________________________________________

v=DKIM1; k=rsa; p=...