Getting the oid of an anyelement - Mailing list pgsql-general

From Scott Bailey
Subject Getting the oid of an anyelement
Date
Msg-id 4AA9453D.8010801@comcast.net
Whole thread Raw
Responses Re: Getting the oid of an anyelement  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Getting the oid of an anyelement  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
If I've got a function (sql or plpgsql) that takes anyelement as a
param, how do I determine the type name or oid that was actually passed
in? I figure there is probably a function for this but darn if I can
find it.

Specifically, I'm trying to make a function like Oracle's dump that will
take anything as input and return the internal representation of it. So
I want to determine what type was passed in and call the appropriate
send function.

  SELECT dump(current_date);

  dump
  ------------------------------------------
  Type=date OID=1082 Len=4 Data=(0,0,13,212)

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: COPY command character set
Next
From: "Peter Headland"
Date:
Subject: Re: COPY command character set