User András Váczi

6 votes

Accepted

Can the current search_path be used in a query?

answered May 31, 2018 at 15:19

5 votes

case inside values statement

answered May 25, 2018 at 8:26

5 votes

UPSERT in postgres stored procedure

answered Apr 26, 2018 at 13:07

5 votes

Accepted

Custom location for postgis extension .control file

answered May 15, 2018 at 20:55

5 votes

Determine if user-defined type is ENUM

answered May 22, 2018 at 15:48

5 votes

Accepted

Query a database specific configuration parameter

answered Apr 9, 2019 at 10:03

5 votes

How do I install/enable the uuid-ossp extension on Postgres 9.3?

answered Apr 9, 2019 at 15:39

5 votes

Use psql --set variable in a function

answered Jan 20, 2017 at 11:34

5 votes

How can I retrieve the image which is stored in bytea column of a pg_toast schema?

answered Dec 22, 2017 at 11:28

5 votes

Subnetting IPv6 in Postgres

answered Sep 19, 2016 at 10:05

5 votes

Accepted

SETVAL in a Window Function

answered Feb 26, 2016 at 23:24

5 votes

Accepted

org.postgresql.util.PSQLException: ERROR: canceling statement due to conflict with recovery

answered Dec 6, 2016 at 20:00

5 votes

Accepted

Postgres - Importing multiple rows with Foreign key constraint

answered Nov 2, 2016 at 11:35

5 votes

Accepted

How to display queries of separate tables in adjacent columns?

answered Nov 28, 2016 at 17:20

5 votes

Accepted

Transpose two-dimensional array from n rows to 2 columns

answered Jul 22, 2013 at 12:27

5 votes

Pass a table array as a parameter to an upsert function in postgresql

answered Apr 16, 2013 at 13:03

5 votes

To select from all tables inside the schema in PostgreSQL

answered Jun 18, 2013 at 10:30

5 votes

Accepted

Problem with nested UPDATE queries

answered Jan 23, 2013 at 14:28

5 votes

Accepted

Removing duplicate entries for each hour

answered Dec 5, 2012 at 10:58

5 votes

Slow query on large table with GROUP BY and ORDER BY

answered Nov 29, 2012 at 10:29

5 votes

sort a varchar field numerically in mysql

answered Jul 19, 2012 at 19:43

5 votes

Accepted

Which option do I have to modify to see more records without press `q`

answered Jul 31, 2012 at 8:30

5 votes

Many-to-one Subselection in single query

answered Nov 9, 2012 at 15:01

5 votes

Accepted

What are practical hurdles in making protein interaction database?

answered Aug 29, 2012 at 15:46

5 votes

Accepted

Postgres settings reported differently in pgsql

answered Feb 25, 2014 at 18:00

5 votes

Accepted

Why does this limit make the postgres planner use a much slower index scan instead of a much faster bitmap heap/index scan?

answered Mar 7, 2014 at 16:01

5 votes

psql, getting a list of databases to be parsed by a script

answered Sep 3, 2013 at 11:02

5 votes

Accepted

Does Greenplum support dynamic sql?

answered Sep 17, 2015 at 12:00

5 votes

Accepted

Would like to know why this query is behaving this way?

answered Jun 29, 2015 at 11:34

5 votes

Accepted

How do I load a data-only dump created with pg_dump to another database?

answered Nov 25, 2015 at 10:28

Stack Exchange Network

417 Answers

Can the current search_path be used in a query?

case inside values statement

UPSERT in postgres stored procedure

Custom location for postgis extension .control file

Determine if user-defined type is ENUM

Query a database specific configuration parameter

How do I install/enable the uuid-ossp extension on Postgres 9.3?

Use psql --set variable in a function

How can I retrieve the image which is stored in bytea column of a pg_toast schema?

Subnetting IPv6 in Postgres

SETVAL in a Window Function

org.postgresql.util.PSQLException: ERROR: canceling statement due to conflict with recovery

Postgres - Importing multiple rows with Foreign key constraint

How to display queries of separate tables in adjacent columns?

Transpose two-dimensional array from n rows to 2 columns

Pass a table array as a parameter to an upsert function in postgresql

To select from all tables inside the schema in PostgreSQL

Problem with nested UPDATE queries

Removing duplicate entries for each hour

Slow query on large table with GROUP BY and ORDER BY

sort a varchar field numerically in mysql

Which option do I have to modify to see more records without press `q`

Many-to-one Subselection in single query

What are practical hurdles in making protein interaction database?

Postgres settings reported differently in pgsql

Why does this limit make the postgres planner use a much slower index scan instead of a much faster bitmap heap/index scan?

psql, getting a list of databases to be parsed by a script

Does Greenplum support dynamic sql?

Would like to know why this query is behaving this way?

How do I load a data-only dump created with pg_dump to another database?