On 08/22/2010 05:27 PM, c k wrote:
As I am using MS Access for a long time, many tools like ms access provides a way to get the list of columns from a query. (using filed list in combo boxes in ms access). But is it possible to get such list of columns from a query where it is not known to the user, that which columns are defined in the base 'SELECT' statement? How? I dynamically created SQL statements many times this situation occurs where the columns are not fixed and we have to get the list of columns from such a query.
What language are you using, and what technique in that language are you using? (ex. Java and JDBC, C# and ADO.NET, PHP and PDO, or PHP and PostgreSQL native) Most of these provide a way to get to the column names, but they're language- and technique-dependent.
-- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
