User András Váczi

10 votes

Accepted

how do I execute a void-returning procedure in pgsql 9.1?

answered May 29, 2012 at 18:37

10 votes

How to turn off header only in psql (postgresql)

answered Sep 13, 2012 at 6:42

10 votes

Order specific columns in json_agg

answered Nov 3, 2014 at 16:29

10 votes

Accepted

Return ResultSet with column names from functions

answered Oct 29, 2013 at 9:06

10 votes

Accepted

What is the relevance of 'SET default_with_oids = true' in a Postgresql dump?

answered May 12, 2015 at 13:31

10 votes

Accepted

Execute a series of commands in PSQL

answered Dec 14, 2016 at 10:22

10 votes

Can a non-owner of a table be allowed to disable the table's triggers?

answered Feb 20, 2019 at 16:44

9 votes

wal_level both hot_standby and logical

answered Jun 20, 2019 at 15:54

9 votes

Accepted

postgres create limited user that can select tables and columns of those tables

answered Jan 25, 2018 at 22:33

9 votes

Accepted

RETURNING value from SELECT table in INSERT .. SELECT

answered Sep 22, 2015 at 17:06

9 votes

Accepted

Error 42P01: relation does not exist

answered Oct 9, 2015 at 14:20

9 votes

Accepted

Why does PostgreSQL perform a seq scan when comparing a numeric value with a bigint column?

answered Aug 9, 2016 at 15:56

9 votes

Accepted

generate_series for multiple record types in postgresql

answered Dec 16, 2015 at 15:10

9 votes

Maximum number of databases for single instance of PostgreSQL 9

answered Sep 9, 2012 at 19:14

9 votes

How to set password for PostgreSQL database with a script?

answered Jun 17, 2013 at 18:30

9 votes

Accepted

Read Committed Isolation Level

answered May 2, 2013 at 10:16

8 votes

PostgreSQL stored procedure to return rows or empty set

answered Apr 17, 2013 at 10:51

8 votes

How do I set and get custom database variables?

answered Dec 7, 2012 at 6:08

8 votes

Accepted

Filtering data that could have more than one category

answered Feb 26, 2013 at 13:41

8 votes

Is a REINDEX required after CLUSTER?

answered Apr 10, 2013 at 20:56

8 votes

Accepted

Doing a comparison on two csv files with no Primary Key

answered Aug 8, 2012 at 6:37

8 votes

"ERROR:malformed array literal" when using json_to_record with a JSON array element in Postgres 9.4

answered Nov 13, 2015 at 10:01

8 votes

how do you revoke create table from a user on postgresql 9.4?

answered Sep 23, 2015 at 21:46

8 votes

Combining separate ranges into largest possible contiguous ranges

answered May 8, 2015 at 14:57

8 votes

How to refer to individual columns of a record returned by a function?

answered May 15, 2014 at 14:48

8 votes

Accepted

What is the equivalent of SQL Server's db_datareader/db_datawriter in PostgreSQL?

answered Jun 15, 2018 at 9:16

8 votes

Accepted

How to control psql displaying rows with (END)?

answered Apr 23, 2018 at 12:37

8 votes

Change Column Data Type from numeric(18, 2) to numeric(22, 6) on a BIG Table

answered Sep 22, 2022 at 14:21

8 votes

Accepted

SQL - find records that are prefixes of my string

answered Sep 14, 2016 at 9:48

8 votes

Accepted

Is it bad practice to add columns to an existing table?

answered Mar 17, 2017 at 10:35

Stack Exchange Network

417 Answers

how do I execute a void-returning procedure in pgsql 9.1?

How to turn off header only in psql (postgresql)

Order specific columns in json_agg

Return ResultSet with column names from functions

What is the relevance of 'SET default_with_oids = true' in a Postgresql dump?

Execute a series of commands in PSQL

Can a non-owner of a table be allowed to disable the table's triggers?

wal_level both hot_standby and logical

postgres create limited user that can select tables and columns of those tables

RETURNING value from SELECT table in INSERT .. SELECT

Error 42P01: relation does not exist

Why does PostgreSQL perform a seq scan when comparing a numeric value with a bigint column?

generate_series for multiple record types in postgresql

Maximum number of databases for single instance of PostgreSQL 9

How to set password for PostgreSQL database with a script?

Read Committed Isolation Level

PostgreSQL stored procedure to return rows or empty set

How do I set and get custom database variables?

Filtering data that could have more than one category

Is a REINDEX required after CLUSTER?

Doing a comparison on two csv files with no Primary Key

"ERROR:malformed array literal" when using json_to_record with a JSON array element in Postgres 9.4

how do you revoke create table from a user on postgresql 9.4?

Combining separate ranges into largest possible contiguous ranges

How to refer to individual columns of a record returned by a function?

What is the equivalent of SQL Server's db_datareader/db_datawriter in PostgreSQL?

How to control psql displaying rows with (END)?

Change Column Data Type from numeric(18, 2) to numeric(22, 6) on a BIG Table

SQL - find records that are prefixes of my string

Is it bad practice to add columns to an existing table?