Running sql query di pgadmin (pribdoc)

Running postgresql on pgadmin
1. Buka Pgadmin
2. Conect to database dan isi sesuai data database tujuan (ext: postgres & galileo)
3. Klik menu execute arbritary SQL queris
3. Copy/open file sql
4. pilih databse (healthcare:contohnya)
5. Klik execute query
6. untuk export ke exel, klik execute query write result to file
7. isi format file sesuai kebutuhan
8. Beri nama file sesuai keingingan
9. buka di exel klik new –> create
10. from text –> pilih File –> import
11. check delimited –>next
12 Uncheck Tab kemudian check other press at keyboard sift & \
13. next –> finish

Tentang kyaibawor

Berusaha Lurus
Pos ini dipublikasikan di Linux, Windows. Tandai permalink.

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s