postgre koneksi php

<?php
$conn = pg_connect("host=localhost port=5432 dbname=dfg user='postgres'
password='ddd'");

//$result = pg_prepare($conn, "my_query", 'SELECT * FROM halamans');
//// disini saya membuat table dengan nama mahasiswa
//$result = pg_execute($conn, "my_query",array());
//while ($row = pg_fetch_assoc($result))
//{
//    print_r($row);
//}


new query pg

$pgquery ="SELECT *  FROM sdm.ms_pegawai where nik='$nik'  limit 1";
            $pgresult = pg_query($pgquery);
            $line = pg_fetch_array($pgresult, null, PGSQL_ASSOC);

postgre conver int varchar dan sum colom

SELECT
sum(Cast(replace(handling_fee,'.','') as float))+sum(Cast(replace(thc_fee,'.','') as float))
FROM "public"."tdopel_uploads"

postgre autoincrement (serial)

testdb=# CREATE TABLE COMPANY(
   ID  SERIAL PRIMARY KEY,
   NAME           TEXT      NOT NULL,
   AGE            INT       NOT NULL,
   ADDRESS        CHAR(50),
   SALARY         REAL
);

Tutorial postgres CMD

totorial melihat database dan table postgre sql
1. masuk terlebih dahulu dalam folderbin postgre

C:\Program Files\PDDIKTI\pgsql\bin

2. masuk kedalam database postgres

psql -h localhost -U postgres

3.melihat seluruh database

\l

4.memilih database

\c namadatabase

5. memilih table dan melihat seu table

\dt * untuk melihat semua
\ dt namatable untuk memilih table