Re: table with no column with some rows inside !!

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: table with no column with some rows inside !!
Date: 2004-08-05 14:11:33
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB34101AF23@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi all,
> is it a paradox or not have table with no column but with rows in in
> ( I mean, we want it ) ?
>
> Here a way to obtain it.

It's even easier than that actually;

create table test();

insert into test default values;
insert into test default values;
insert into test default values;

select * from test;

--
(3 rows)

I think it's kind of cool.

Merlin

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-08-05 14:19:45 Re: No such file or directory during PITR
Previous Message Gaetano Mendola 2004-08-05 14:02:36 pg_dump: could not parse ACL list