.::: Convert Query select PostgreSQL EDB to Excel CSV :::.

 

1. query table pembelian

SELECT pg_read_file('/etc/hostname') as hostname,VERSION() AS versi;
select * from pembelian;
 

2. Ekspor Data ke File CSV
COPY pembelian TO '/convert/pembelianedb.csv' WITH CSV HEADER;
 
3. script convert to csv

[root@teguhth convert]# cat convert_to_csv.sh
#!/bin/bash

# Variabel koneksi PostgreSQL
DB_NAME="teguhth"
TABLE_NAME="pembelian"
CSV_FILE="/convert/pembelianedb.csv"

# Periksa apakah user postgres ada
if ! id "postgres" &>/dev/null; then
    echo "User 'postgres' tidak ditemukan. Pastikan PostgreSQL terinstal dengan benar."
    exit 1
fi

# Ekspor data PostgreSQL ke file CSV
echo "Mengekspor data PostgreSQL ke file CSV..."
sudo -u postgres psql -d $DB_NAME -c "COPY $TABLE_NAME TO '$CSV_FILE' WITH CSV HEADER;"

if [ $? -eq 0 ]; then
    echo "Data berhasil diekspor ke $CSV_FILE"
else
    echo "Gagal mengekspor data ke CSV"
    exit 1
fi

cat $CSV_FILE

FILE_SIZE=$(ls -lh "$CSV_FILE" | awk '{print $5}')
echo "Size File $FILE_SIZE"
[root@teguhth convert]#

4. check