Pavel Stehule <pavel.steh...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers