Re: [GENERAL] Return keys for values with dot-separation in joined statements

2012-03-12 Thread Alexander Reichstadt
PGSQLKit for Cocoa. Am 12.03.2012 um 18:09 schrieb Tom Lane: > Alexander Reichstadt writes: >> Is there a way or some setting on postgres server to tell postgres to use >> the fieldnames exactly as provided in the select? > > You didn't say exactly which "API" you're using, but in libpq you c

Re: [GENERAL] Return keys for values with dot-separation in joined statements

2012-03-12 Thread Tom Lane
Alexander Reichstadt writes: > Is there a way or some setting on postgres server to tell postgres to use the > fieldnames exactly as provided in the select? You didn't say exactly which "API" you're using, but in libpq you could look at the PQftable and PQftablecol column property inquiry functi

[GENERAL] Return keys for values with dot-separation in joined statements

2012-03-12 Thread Alexander Reichstadt
Hi, writing a client frontend I started with mysql and migrated to postgres. Now I found out that there is a difference in the way joined queries are returned: The query SELECT persons.id,persons.lastname,persons.firstname,persons.salutation,persons.title,addresses.address1,addresses.address2,