Select into temp table in PostgreSQL? [duplicate]

Question

How to create temporary table using select into in PostgreSQL. For example in SQL Select * into temp_tab from source_tab;

Your question have answer here : stackoverflow.com/questions/15691243/… — Madhusudan
– Madhusudan, Commented Apr 30, 2015 at 10:25

Rahul Tripathi · Accepted Answer · 2015-04-30 10:04:57Z

74

You can try to use Create Table As command like this:

CREATE TEMP TABLE mytable AS
SELECT * from source_tab;

From the docs:

This command is functionally similar to SELECT INTO, but it is preferred since it is less likely to be confused with other uses of the SELECT INTO syntax. Furthermore, CREATE TABLE AS offers a superset of the functionality offered by SELECT INTO.

The CREATE TABLE AS command allows the user to explicitly specify whether OIDs should be included. If the presence of OIDs is not explicitly specified, the default_with_oids configuration variable is used.

answered Apr 30, 2015 at 10:04

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Parthasarathi Over a year ago

Thanks for your quick response...should i use without create temp ....i.e in your example...

Collectives™ on Stack Overflow

Select into temp table in PostgreSQL? [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related