--- On Thu, 7/23/09, Albe Laurenz 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
> > ---+--++-
>
On 2009-07-22, Andrew Klaassen 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
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 | na
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
---+--++-
...
Thank