windows gunakan cmd administrator
yg pertama backup
yg kedua restore
C:\Program Files\PostgreSQL\9.2\bin>psql -U postgres -d tes_data < c:\tes.sql
C:\Program Files\PostgreSQL\9.2\bin>pg_dump -U postgres SET_MASTER_STAGING > c:\tes.sql
Related Posts :
postgres trigger created update datehttps://www.revsys.com/tidbits/automatically-updating-a-timestamp-column-in-postgresql/
https://www.the-art-of-web.com/sql/trigger-update-… Read More...
sum balance per month postgreswith a AS (SELECT * FROM (VALUES('Jan',100),('Jan',150),('Jan',50),('Feb',70),('Feb',80)) temp_table(MONTH_NAME,BALANCE)), b as (select *, r… Read More...
query postgres kumpulan
https://www.holistics.io/blog/postgresql-queries-usage-monitoring/
https://gist.github.com/rgreenjr/3637525… Read More...
concate postgres ato string_aggSELECT * FROM public.group_by_ex
GO
SELECT CITY, STATE, string_agg(member, ', '), SUM(DONATION) FROM group_by_ex
GROUP BY CITY,STATE
… Read More...
command postgres di linuxhttps://ambilgratis.com/tag/melihat-kolom-tabel-postgre/… Read More...
0 Response to "backup-restore pgadmin"
Posting Komentar