Pavel Stehule <pavel.stehule@gmail.com> writes:
> I miss a functionality that helps with parsing any identifier to basic
> three parts - database, schema, objectname. We have this function
> internally, but it is not available for SQL layer.
> FUNCTION parse_ident(IN ident text, OUT dbname text, OUT schemaname text,
> OUT objectname text)
What exactly would you do with this that would not be better done with,
for example, regclass?
Don't say "parse names for things other than tables". Only a minority
of the types of objects used in the database have names that meet this
specification.
regards, tom lane