Timeline for How do I create a view in Postgres?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 12, 2018 at 16:01 | vote | accept | JClarkson | ||
| Nov 12, 2018 at 15:54 | comment | added | HeikkiVesanto♦ | You cant' do select * then. You have to specify the column names, so layer1.id, layer1.geom, layer1.other, layer2.id as id2. The resulting table cannot have two columns with the same name. | |
| Nov 12, 2018 at 15:50 | comment | added | JClarkson | Thanks! Having a problem creating the view. The query itself worked fine, but when i press create view and enter a name e.g. test, it throws the error: column geom specified more than once | |
| Nov 12, 2018 at 15:42 | history | answered | Dave C | CC BY-SA 4.0 |