User Sahap Asci

36 votes

Accepted

CREATE TABLE LIKE another table but with additional columns

answered May 17, 2018 at 19:05

28 votes

How do I list all tables in all schemas owned by the current user in Postgresql?

answered Aug 4, 2015 at 13:08

14 votes

Find objects linked to a PostgreSQL role

answered Nov 15, 2016 at 21:20

13 votes

Accepted

Deleting old postgresql log files (Ubuntu)

answered Mar 26, 2016 at 16:31

7 votes

Accepted

Why the WHERE clause is not pushed down in the view's query?

answered Aug 8, 2015 at 19:35

4 votes

Accepted

Export roles with privileges under PostgreSQL 9.3

answered Mar 18, 2016 at 22:16

4 votes

Error loading example PostgreSQL database: "Could not find header for file ..."

answered Sep 12, 2016 at 17:35

4 votes

Select orphaned rows (in a generic way)

answered May 14, 2018 at 15:41

4 votes

How do I move all tables from one Postgres schema to another

answered May 14, 2019 at 12:19

4 votes

Accepted

PSQL asks for password for a specific database

answered Jun 10, 2021 at 21:56

4 votes

Accepted

How to generate constraint sql?

answered Aug 13, 2021 at 22:38

4 votes

Postgresql pg_toast tables, are they mandatory?

answered Nov 30, 2021 at 20:18

4 votes

Unable to drop database because of special character?

answered Jul 26 at 11:05

3 votes

PostgeSQL Schedule Jobs

answered Nov 24, 2022 at 21:37

3 votes

Using collations with JSONB

answered Jan 1 at 20:37

3 votes

Accepted

Return all rows with a certain value in jsonb dictionary in Postgres

answered Mar 9, 2019 at 1:20

3 votes

How to update an element in json array with where clause?

answered Apr 25, 2019 at 9:22

3 votes

Accepted

How to store and work from a Postgresql database on an external hard drive?

answered Nov 26, 2020 at 0:02

3 votes

Accepted

Postgresql get rows based on minimum value

answered Mar 1, 2021 at 9:42

3 votes

Accepted

Fetch Data from same table name across schema

answered Jul 1, 2018 at 20:34

3 votes

Accepted

GRANT ALL ON ALL TABLES IN SCHEMA does not allow user to see tables

answered Oct 28, 2018 at 21:16

3 votes

Postgres jsonb vs composite type performance differences

answered Jan 17, 2019 at 21:16

3 votes

PostgreSQL performance citext

answered Dec 28, 2017 at 20:57

2 votes

Accepted

Select from arrays in a way similar to IN

answered Jul 4, 2017 at 8:25

2 votes

Get all rows from table where JSON column contains a certain value

answered Nov 16, 2016 at 19:23

2 votes

Accepted

Postgres permission for EXPLAIN

answered Jul 11, 2016 at 10:36

2 votes

DB schema for storing the process tree of linux

answered May 31, 2016 at 7:43

2 votes

Unable to force drop Postgres database

answered Nov 9, 2015 at 7:44

2 votes

Accepted

Postgres JSON output using specific column as JSON key

answered Sep 4, 2018 at 23:59

2 votes

Accepted

how to extract difference between timestamps

answered Oct 8, 2018 at 22:01

Stack Exchange Network

80 Answers

CREATE TABLE LIKE another table but with additional columns

How do I list all tables in all schemas owned by the current user in Postgresql?

Find objects linked to a PostgreSQL role

Deleting old postgresql log files (Ubuntu)

Why the WHERE clause is not pushed down in the view's query?

Export roles with privileges under PostgreSQL 9.3

Error loading example PostgreSQL database: "Could not find header for file ..."

Select orphaned rows (in a generic way)

How do I move all tables from one Postgres schema to another

PSQL asks for password for a specific database

How to generate constraint sql?

Postgresql pg_toast tables, are they mandatory?

Unable to drop database because of special character?

PostgeSQL Schedule Jobs

Using collations with JSONB

Return all rows with a certain value in jsonb dictionary in Postgres

How to update an element in json array with where clause?

How to store and work from a Postgresql database on an external hard drive?

Postgresql get rows based on minimum value

Fetch Data from same table name across schema

GRANT ALL ON ALL TABLES IN SCHEMA does not allow user to see tables

Postgres jsonb vs composite type performance differences

PostgreSQL performance citext

Select from arrays in a way similar to IN

Get all rows from table where JSON column contains a certain value

Postgres permission for EXPLAIN

DB schema for storing the process tree of linux

Unable to force drop Postgres database

Postgres JSON output using specific column as JSON key

how to extract difference between timestamps