Re: SELECT INTO deprecation - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: SELECT INTO deprecation
Date
Msg-id 8e05fc79-abca-dd3f-4d48-8aaae9525a8f@enterprisedb.com
Whole thread Raw
In response to Re: SELECT INTO deprecation  (Michael Paquier <michael@paquier.xyz>)
Responses Re: SELECT INTO deprecation
List pgsql-hackers
On 2020-12-03 00:54, Michael Paquier wrote:
> I got to wonder about the impact when migrating applications
> though.  SELECT INTO has a different meaning in Oracle, but SQL server
> creates a new table like Postgres.

Interesting.  This appears to be the case.  SQL Server uses SELECT INTO 
to create a table, and does not appear to have CREATE TABLE AS.

So maybe we should keep it, but adjust the documentation to point out 
this use case.

[some snarky comment about AWS Babelfish here ... ;-) ]



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: SELECT INTO deprecation
Next
From: Laurenz Albe
Date:
Subject: Re: Add session statistics to pg_stat_database