Jonathan Leffler wrote: > > I don't see how quote_identifier helps a user of DBI write more portable > code.
Suppose I'm writing a cross DBMS system that needs to interact with various (unkown at compile time) database objects. Suppose I want to display a list of objects in the database, perhaps I call $dbh->table_info to get this, easy. But when I want to retieve the contents of one of those objects I need to issue a SELECT statement on a fully qualified object name - I need to build an identifier for the FROM clause. Now all I need to do is call quote_identifier with the appropriate identifiers and the method will return an appropriate complex identifier quoted according to the rules of the underlying DBD or DBMS. -- Simon Oliver
