Skip to content

Instantly share code, notes, and snippets.

@ganesh-karthick
ganesh-karthick / pg.sql
Last active January 14, 2022 06:00
SQL JSONPATH Postgres 12
### Create Table
CREATE TABLE orders (
id serial NOT NULL PRIMARY KEY,
info jsonb NOT NULL
);
## Insert data
INSERT INTO orders (info)
VALUES('{ "customer": "Lily Bush", "items":34,"description":"foo"}'),
@ganesh-karthick
ganesh-karthick / kube_service_create.sh
Last active February 7, 2023 23:02
PgAdmin Kubernetes service depoyment example
#!/usr/bin/env bash
kubectl create -f pgadmin.yaml
sleep 15s
kubectl logs pgadmin-76gjgvvjh-yghg
## Access pgAdmin
## https://<IP>:31560
## username/password: user@e-mail.com / password