On Wed, Nov 02, 2005 at 02:49:57PM -0200, Jon Lapham wrote:
> Michael Fuhr wrote:
> >test=> SELECT id, foo FROM foo;
> > id | foo
> >----+---------------------------------------------------------
> > 1 | (1,123,"this is a test",2005-11-02,t,"\\000\\001\\002")
>
> Perfect! Wow, in all these years of using PostgreSQL, I did not know
> you can "SELECT tablename FROM tablename".
It only works in 8.0 and later.
> PS: Does anyone know if this very portable to other databases?
Dunno, but it doesn't work in MySQL 5.0.15.
--
Michael Fuhr