Questions tagged [postgres-10]
50 questions
0
votes
1 answer
How do you create a database from a backup with PostgreSQL?
In SQL Server, I can create a new database on the server from a backup from another box. I can't seem to find that functionality in pgAdmin4 with PostgreSQL10. It seems like all I can do is restore an existing database. Do I need to just create a…
Bob Wakefield
- 3,739
- 4
- 20
- 30
0
votes
1 answer
How to set SEQUENCE as DEFAULT in Postgres-XL?
I use Postgres-XL 10R1.
I created table packs and sequence packs_id_seq same SQL:
CREATE TABLE packs (
id integer NOT NULL,
name varchar(10) NOT NULL
) DISTRIBUTE BY REPLICATION;
CREATE SEQUENCE packs_id_seq
AS integer
START WITH 1
…
0
votes
2 answers
Compare numeric values inside a jsonb field of postgres
I have a column inside a postgresql database table of type jsonb called meta. This is the data i have inside one of the rows in the meta column of the table.
{
budget: {
data: "2018-12-15",
target: 47.5,
spend: 12.3
…
Bubunyo Nyavor
- 2,511
- 24
- 36
-1
votes
1 answer
How to execute an insert or update operation in postgres 10 ( that not have store procedures)?
it is possible to execute an insert or update operation using only functions in postgres?.
I am using version 10.14 that not support store procedures.
EdwinMald
- 145
- 1
- 12
-2
votes
3 answers
How to join latest 2 rows into a view using postgres 10
I want to create a view where I can join the two latest statuses with their timestamps and comments to the view. I know I can use min and max for the timestamps, but how can I set their comments correctly (see comment in code)? What is the most…
Han Che
- 8,239
- 19
- 70
- 116