Add function for quote_qualified_identifier?

From: "Brendan Jurd" <direvus(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Add function for quote_qualified_identifier?
Date: 2007-09-12 03:15:29
Message-ID: 37ed240d0709112015g6746be2bp91fcf5aeee1e92f1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Hi hackers,

I note that we currently expose the usefulness of the quote_identifier
function to the user with quote_ident(text).

Is there any reason we shouldn't do the same with quote_qualified_identifier?

We could just add a quote_qualified_ident(text, text) ... it would
make forming dynamic queries more convenient in databases that use
multiple schemas.

Clearly a DBA could just create this function himself in SQL (and it
wouldn't be difficult), but is that a good reason not to have it in
our standard set of functions?

Would be happy to cook up a patch for this.

Cheers,
BJ

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Brendan Jurd 2007-09-12 03:29:31 Re: Per-function search_path => per-function GUC settings
Previous Message Jeremy Drake 2007-09-12 02:47:34 buildfarm failure after ICC configure change

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2007-09-12 03:27:12 Re: prevent invalidly encoded input
Previous Message Bruce Momjian 2007-09-12 03:12:21 Re: Version in Japanese FAQ is wrong (was [COMMITTERS] pgsql: Stamp releases 8.2.5, 8.1.10, 8.0.14, 7.4.18, 7.3.20.)