Cara untuk backup tabel di database postgresql dapat dilakukan di command line server :
Bila ada perbedaan versi antara database dengan command pg_ctl, dapat menambahkan opsi '-i' (ignore) dalam command backup.
Semoga bermanfaat...
- Backup hanya data (option -a)
pg_dump -a -t tablename database > filedump.sql
- Backup hanya sql query (option -d)
pg_dump -d -t tablename database > filedump.sql
- Backup data dan query
pg_dump -d -t tablename database > filedump.sql
pg_dump -i -a -d -t tablename database > filedump.sql
When you take a look at|have a look at} slots on-line, 코인카지노 although, they turn into much simpler to handle. Caesar’s Empire is packed filled with ancient historical inspirations – from its RTG title to its visuals and gameplay. For instance, the reel desk is framed by an image of the Roman Colosseum, which is a significant symbol of the empire’s historical past.
BalasHapus