Обсуждение: table.column in query results?
Hi, Is it possible to get table.column in query results rather than just column? I.e. I'd like: SELECT * FROM foo, bar; foo.id | foo.name | bar.id | bar.text -------+----------+--------+--------- ... ...rather than: SELECT * FROM foo, bar; id | name | id | text ---+------+----+----- ... Thanks. Andrew __________________________________________________________________ Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your favourite sites. Download it now http://ca.toolbar.yahoo.com.
Andrew Klaassen wrote: > Is it possible to get table.column in query results rather > than just column? > > I.e. I'd like: > > SELECT * FROM foo, bar; > foo.id | foo.name | bar.id | bar.text > -------+----------+--------+--------- > ... > > ...rather than: > > SELECT * FROM foo, bar; > id | name | id | text > ---+------+----+----- > ... You'd have to use aliases, like SELECT id AS "foo.id" ... Yours, Laurenz Albe
On 2009-07-22, Andrew Klaassen <clawsoon@yahoo.com> wrote: > Hi, > > Is it possible to get table.column in query results rather than just column? it is possible to get the OID of the table from libpq. I don't think psql provides display of the table name as a formatting option, and most wrapper around libpq seem to ignore this feature. if you can manipulate the query you can alias the column in the query and hope that none of the tables or columns has a dot in its name already!
--- On Thu, 7/23/09, Albe Laurenz <laurenz.albe@wien.gv.at> wrote: > Andrew Klaassen wrote: > > Is it possible to get table.column in query results > rather > > than just column? > > > > I.e. I'd like: > > > > SELECT * FROM foo, bar; > > foo.id | foo.name | bar.id | bar.text > > -------+----------+--------+--------- > > ... > > > > ...rather than: > > > > SELECT * FROM foo, bar; > > id | name | id | text > > ---+------+----+----- > > ... > > You'd have to use aliases, like > > SELECT id AS "foo.id" ... Ah... so no way to do it with a wildcard in the query? That's unfortunate. Thanks. Andrew __________________________________________________________________ The new Internet Explorer® 8 - Faster, safer, easier. Optimized for Yahoo! Get it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/