proposal: function parse_ident

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: proposal: function parse_ident
Date: 2015-08-19 05:16:30
Message-ID: CAFj8pRC-Chs7jg+9QuoHSATQBQZkQmqqoAa0bxtVD0wRpq45BA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

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)

Examples:

SELECT parse_ident('"some schema".tablename');

Comments, ideas, notes?

Regards

Pavel

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michal Šalko 2015-08-19 06:04:58 Missing equivalent xpath_table in xml2
Previous Message Paul A Jungwirth 2015-08-19 04:25:33 Re: GiST support for UUIDs