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".
Thanks Michael.
PS: Does anyone know if this very portable to other databases?
-Jon
--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
Jon Lapham <lapham(at)jandr(dot)org> Rio de Janeiro, Brasil
Personal: http://www.jandr.org/
***-*--*----*-------*------------*--------------------*---------------