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@xxxxxxxxx> Rio de Janeiro, Brasil
Personal: http://www.jandr.org/
***-*--*----*-------*------------*--------------------*---------------
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
