Timeline for PostgreSQL, CREATE TABLE AS with predefined column(s)
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 9, 2018 at 10:21 | vote | accept | Wine Too | ||
| Jan 9, 2018 at 9:19 | answer | added | Vao Tsun | timeline score: 1 | |
| Jan 7, 2018 at 19:03 | comment | added | Wine Too | I understand that. That's why I ask for solution with CREATE TABLE AS and SELECT query. It seem's a bit strange to be able to create and fill a table but unable to define it's columns. | |
| Jan 7, 2018 at 18:58 | comment | added | user330315 |
The immediate solution is to first create the table then do an insert into ... select but a foreign table would be a lot easier to deal with.
|
|
| Jan 7, 2018 at 18:53 | history | asked | Wine Too | CC BY-SA 3.0 |