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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
