User Tools

Site Tools


wiki:postgres:restore

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
wiki:postgres:restore [2016/03/02 10:35]
schild
wiki:postgres:restore [2016/03/02 10:54] (current)
schild [Teilmenge einer Tabelle irrtümlich gelöscht]
Line 18: Line 18:
 bfw=# create table gea.plot_2016_02_24 (LIKE gea.plot); bfw=# create table gea.plot_2016_02_24 (LIKE gea.plot);
 bfw=# copy gea.plot_2016_02_24 FROM '/​home/​postgres/​plot.tsv';​ bfw=# copy gea.plot_2016_02_24 FROM '/​home/​postgres/​plot.tsv';​
 +bfw=# GRANT SELECT ON gea.plot_2016_02_24 TO bfw;
 +bfw=# GRANT SELECT ON gea.plot_2016_03_02 TO bfw;
 </​code>​ </​code>​
  
wiki/postgres/restore.txt · Last modified: 2016/03/02 10:54 by schild