... | ... | @@ -42,4 +42,6 @@ WIP |
|
|
You can do a backup of a particular table with the following command:
|
|
|
`COPY "mtcarouge"."etdevice" to directory '/home/backup/' with (compression='gzip');`
|
|
|
|
|
|
A table can be erased with the command: `DROP TABLE "mtcarouge"."etdevice"` |
|
|
\ No newline at end of file |
|
|
A table can be erased with the command: `DROP TABLE "mtcarouge"."etdevice"`
|
|
|
|
|
|
A table can be created like this: `CREATE TABLE "mtcarouge"."etwaterqualityobserved" (entity_id string, entity_type STRING);` |
|
|
\ No newline at end of file |