I want to use jsonb to solve the problem in Postgres. There are many problems here, what I want to do is:
SELECT table.column->>’key_1′ as a FROM “table” I tried -> there are some combination
Tag: PostgreSQL
I can’t run jobs on PGAgent on PostgreSQL.
I installed pgagent on Ubuntu 16.04.
I executed:
CREATE EXTENSION pgagent;
CREATE LANGUAGE plpgsql; According to this: https://www.pgadmin.org/docs/pgadmin4/1.x/pgagent_install.htm
<
PostgreSQL query is not terminated, the service postgreSQL is not started after reboot
In my work, I am running a complex query. I canceled it and went home yesterday. It is impossible to terminate the query later this morning. There is also a “after termination” “End” function. A co
PostgreSQL – Refreshing materialized view Concurrently causes table expansion
In PostgreSQL 9.5, I decided to create a materialized view “effect” and schedule hourly concurrent refreshes, because I want it to be always available:
< /p> REFRESH MATERIALIZED VIEW CONCURR
PostgreSQL – “INSERT INTO … FETCH All from …” unable to compile
I have some functions to return cursors (refcursor) on PostgreSQL 9.6:
CREATE OR REPLACE FUNCTION public.test_returning_cursor( )
RETURNS refcursor
IMMUTABLE
LANGUAGE plpgsql
AS $$
DECLARE
Deploy high performance PostgreSQL cluster
Postgres-XL is composed of three major components: the GTM (Global Transaction Manager), the Coordinator and the Datanode. Their features are given in the following sections. GTM (Global Transactio
PostgreSQL – How do I know the actual count in a big table of high insertion rates
Suppose I have a table with exactly 10M rows. I need to know the exact number of rows. It takes 5 seconds for COUNT requests. Suppose 100 rows are added to the table every second.
If I now re
How to sort in PostgreSQL via UUID?
Is there any order guarantee for using uuid_generate_v1() on postgresql?
If yes, it does not matter whether it is guaranteed to generate the UUID on each machine or on which machine? Since V1
PostgreSQL – Postgres unique constraint is not forced uniqueness
This is my constraint:
CREATE UNIQUE INDEX index_subscriptions_on_user_id_and_class_type_id_and_deleted_at
ON subscriptions
USING btree
(user_id, class_type_id, deleted_at); This query pr
PostgreSQL – Postgres hierarchy – counting of sub-level, sorted by subkey or grandson
I want to know how to write a postgres subquery so that the following example will output what I need.
id parent_id postdate
1 -1 2015-03-10
2 1 2015-03-11 (child level 1)
3 1 2015