select * from m_api_log where data->>'params' like '%1%';
Category: PostgreSQL
Update one column from another column in same table sql
update stuffset TYPE1 = TYPE2where TYPE1 is null; update stuffset TYPE1 = TYPE2where TYPE1 ='Blank';
Check double data in postgresql
SELECTnama, email, COUNT() FROM m_pelanggan GROUP BY nama, email HAVING COUNT() > 1;
See Nextval Sequence and Change Nexval Sequence in Postgres
SELECT nextval('idsequencenextval'); ALTER SEQUENCE payments_id_seq RESTART WITH 22;
Adding ‘serial’ nextval to existing column in Postgres
CREATE SEQUENCE table_name_id_seq; ALTER TABLE table_name ALTER COLUMN id SET DEFAULT nextval('table_name_id_seq'); ALTER TABLE table_name ALTER COLUMN id SET NOT NULL; ALTER SEQUENCE table_name_id_seq OWNED BY table_name.id; SELECT setval('table_name_id_seq', (SELECT max(id) FROM table_name));
PostgreSQL Python
org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
Menggunakan Alter di PostgreSQL
How To Use Roles and Manage Grant Permissions in PostgreSQL on a VPS
What is PostgreSQL PostgreSQL is an open source database management system that uses the SQL querying language. PostgreSQL is a powerful tool that can be used to manage application and web data on your VPS. In this gude, we will discuss how to properly manage privileges and user grant permissions. This will allow you to … Continue reading How To Use Roles and Manage Grant Permissions in PostgreSQL on a VPS
My Note 