Timeline for copy command in postgresql to append data
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 17, 2023 at 11:25 | comment | added | Daniel Vérité |
@Ray: that's because in the context of the question, tableName is dynamic so the code is plpgsql (procedural) to build the sql query and then execute it. I've edited this answer to clarify that.
|
|
| Oct 17, 2023 at 11:18 | history | edited | Daniel Vérité | CC BY-SA 4.0 |
Clarify in what context execute is used
|
| Oct 17, 2023 at 11:13 | history | edited | Daniel Vérité | CC BY-SA 4.0 |
Clarify in what context execute is used
|
| Oct 16, 2023 at 14:24 | comment | added | Ray |
In case anyone else is trying this, on PostgreSQL 15, I had to remove the execute '' part to get it working.
|
|
| Sep 16, 2016 at 2:26 | comment | added | RBB |
if newer version supports, really its cool. But unfortunately, I'm using 9.1 . As of now, I'm using unlogged option and doing testing.
|
|
| Sep 15, 2016 at 13:56 | history | edited | Daniel Vérité | CC BY-SA 3.0 |
add solution for pg<9.3
|
| Sep 15, 2016 at 12:53 | history | answered | Daniel Vérité | CC BY-SA 3.0 |