Postgres Pro
Downloads
Home   >   mailing lists

proposal: function parse_ident - Mailing list pgsql-hackers

From Pavel Stehule
Subject proposal: function parse_ident
Date
Msg-id CAFj8pRC-Chs7jg+9QuoHSATQBQZkQmqqoAa0bxtVD0wRpq45BA@mail.gmail.com
Whole thread Raw
Responses Re: proposal: function parse_ident  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: Kouhei Kaigai
Date:
Subject: Re: Bug? ExecChooseHashTableSize() got assertion failed with crazy number of rows
Next
From: Fabien COELHO
Date:
Subject: Re: checkpointer continuous flushing