Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT INTO without columns or star - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: SELECT INTO without columns or star
Date
Msg-id CAKFQuwZ_ZPuqziYZ=0uBEEGRnUFPRa9cspnmGeWb6-Jq63-B0Q@mail.gmail.com
Whole thread Raw
In response to SELECT INTO without columns or star  (Zhang Mingli <zmlpostgres@gmail.com>)
Responses Re: SELECT INTO without columns or star  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view
On Fri, Mar 31, 2023 at 8:10 AM Zhang Mingli <zmlpostgres@gmail.com> wrote:
When I exec a sql SELECT INTO without columns or * by mistake, it succeeds:


Yes, a table may have zero columns by design.

David J.

pgsql-hackers by date:

Previous
From: Zhang Mingli
Date:
Subject: SELECT INTO without columns or star
Next
From: Tom Lane
Date:
Subject: Re: SELECT INTO without columns or star