Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sql: support CREATE TABLE ... AS ...? #2483

Closed
petermattis opened this issue Sep 11, 2015 · 2 comments
Closed

sql: support CREATE TABLE ... AS ...? #2483

petermattis opened this issue Sep 11, 2015 · 2 comments
Assignees
@WillHaack
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
Milestone
Later

Comments

@petermattis
Copy link
Collaborator

Support for CREATE TABLE ... AS ... was removed from the grammar in #2479, but it could be easily resurrected. The actual implementation would not be terribly difficult, though it might depend on supporting tables without primary keys (see #2081).

From a comment in #2479:

@jusongchen writes:
CREATE TABLE ... AS is a very useful feature. Without this feature,an end user cannot easily store a query result as a intermediate table. This feature is very useful when it comes to ad-hoc data analysis and it is widely supported by most RDBMS vendors.
@petermattis petermattis added this to the Post 1.0 milestone Sep 11, 2015
@petermattis petermattis added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) and removed SQL labels Feb 13, 2016
@dt dt added the help wanted Help is requested / needed by the one who filed the issue to fix it. label May 2, 2016
@dt dt mentioned this issue May 2, 2016
Closed
@petermattis petermattis removed the help wanted Help is requested / needed by the one who filed the issue to fix it. label Jul 5, 2016
@WillHaack
Copy link
Contributor

#8802

@knz
Copy link
Contributor

knz commented Sep 4, 2016

Closed by #8802.

@knz knz closed this as completed Sep 4, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@WillHaack WillHaack

Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
Projects
None yet
Milestone
Later
Development

No branches or pull requests
4 participants
@dt @knz @WillHaack @petermattis