User tinlyx - Database Administrators Stack Exchange

14 votes

Accepted

How to get a user's password in PostgreSQL?

answered Oct 2, 2022 at 22:48

5 votes

Check constraint to guarantee ltree ancestors

answered Jun 16, 2021 at 1:43

5 votes

How can I get a unique array in PostgreSQL?

answered Apr 27, 2022 at 20:56

4 votes

Accepted

Why is this not in 2NF and 3NF form?

answered Mar 27, 2016 at 22:33

4 votes

list of PostgreSQL trusted languages?

answered Jan 16, 2017 at 18:38

4 votes

How to upgrade PostgreSQL 9.6 to 10 in Ubuntu 16.04?

answered Oct 27, 2017 at 16:08

3 votes

Improving RAM and CPU utilization by PostgreSQL 9.6

answered Sep 22, 2017 at 19:52

2 votes

Accepted

Joining to same table and updating column on row match for multiple columns

answered Sep 25, 2017 at 1:39

2 votes

Accepted

Difference of sets with different amount of columns?

answered Jan 27, 2018 at 6:14

2 votes

Why are scalar functions special? A case study of trying to understand database terminology as a beginner

answered Jul 27, 2022 at 22:16

2 votes

Accepted

Is there a way to calculate a column based on an expression of other columns?

answered Feb 23 at 1:29

1 vote

How to select distinct for one column and any in another column?

answered Mar 8, 2021 at 22:50

1 vote

What does it mean by PostgreSQL's ERROR: schema XX is not a member of extension YY?

answered Aug 19, 2022 at 17:40

1 vote

Accepted

When is SELECT necessary in PL/pgSQL functions?

answered Mar 15, 2018 at 16:02

1 vote

Obtaining a MIN() value in a column in a subquery

answered Sep 29, 2017 at 6:54

0 votes

using PERFORM to insert a string of SELECT statement into a temp table

answered Sep 15, 2017 at 19:58

0 votes

Accepted

Test if a string is a valid, unquoted identifier?

answered Mar 20, 2018 at 1:03

0 votes

Accepted

How to case text array elements automatically?

answered Apr 27, 2022 at 21:07

0 votes

LEFT JOIN LATERAL conditions and JSONB

answered Mar 31, 2023 at 21:58

Stack Exchange Network

19 Answers

How to get a user's password in PostgreSQL?

Check constraint to guarantee ltree ancestors

How can I get a unique array in PostgreSQL?

Why is this not in 2NF and 3NF form?

list of PostgreSQL trusted languages?

How to upgrade PostgreSQL 9.6 to 10 in Ubuntu 16.04?

Improving RAM and CPU utilization by PostgreSQL 9.6

Joining to same table and updating column on row match for multiple columns

Difference of sets with different amount of columns?

Why are scalar functions special? A case study of trying to understand database terminology as a beginner

Is there a way to calculate a column based on an expression of other columns?

How to select distinct for one column and any in another column?

What does it mean by PostgreSQL's ERROR: schema XX is not a member of extension YY?

When is SELECT necessary in PL/pgSQL functions?

Obtaining a MIN() value in a column in a subquery

using PERFORM to insert a string of SELECT statement into a temp table

Test if a string is a valid, unquoted identifier?

How to case text array elements automatically?

LEFT JOIN LATERAL conditions and JSONB