User Dave

16 votes

2 answers

62k views

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

asked Oct 21, 2016 at 17:11

7 votes

3 answers

21k views

Find rows in which the column doesn't contain a "space"

asked Mar 24, 2017 at 20:11

6 votes

2 answers

11k views

psql is not prompting me for a password, then denies access

asked Sep 10, 2017 at 17:00

5 votes

4 answers

16k views

In Postgres, set log_rotation_size but my logs are still not rotating

asked Dec 29, 2016 at 23:40

5 votes

1 answer

2k views

Why is Postgres not respecting my log file name convention dictated by "log_filename"?

asked Dec 31, 2016 at 19:34

4 votes

2 answers

45k views

How do I uninstall the old version of Postgres on CentOS 7?

asked May 8, 2018 at 20:01

3 votes

1 answer

833 views

How do I enable md5 authentication for only one user?

asked Feb 24, 2018 at 18:53

3 votes

3 answers

2k views

Can connect to virtual MySql instance using 127.0.0.1, but not localhost

asked Nov 18, 2021 at 21:30

3 votes

0 answers

2k views

How do I generate a Postgres dump with the column names in my INSERT statement?

asked Dec 28, 2016 at 16:00

3 votes

1 answer

18k views

In Postgres, how do I adjust the "pgsql_tmp" setting?

asked Apr 10, 2017 at 19:19

3 votes

1 answer

310 views

Is there a more efficient way to search for a record but only if it has associations?

asked Jan 29, 2017 at 21:24

3 votes

1 answer

2k views

How do I build a PostgreSQL ORDER BY expression based on a concatenation of columns?

asked Feb 21, 2017 at 16:04

3 votes

2 answers

20k views

How do I set MySQL's "character_set_server" and "collation_server" variables when creating a database?

asked Mar 7, 2017 at 20:14

2 votes

1 answer

4k views

Select rows from my table where a character column matches a pattern

asked Mar 8, 2017 at 2:23

2 votes

1 answer

1k views

How do I create a psql alias for "\q"?

asked Jan 12, 2017 at 21:28

2 votes

1 answer

1k views

Want to clone a role, but am getting "can't login" message after doing so

asked Oct 25, 2016 at 19:02

2 votes

1 answer

13k views

Export Postgres data without superuser privileges

asked Dec 4, 2021 at 16:54

2 votes

1 answer

8k views

How do I limit the size of my Postgres log?

asked Dec 29, 2016 at 17:10

2 votes

0 answers

2k views

Ran "Grant all privileges" but still getting "permission denied for relation"

asked Jul 28, 2017 at 19:04

1 vote

3 answers

3k views

Is there a more concise way in Postgres to extract a portion of a string?

asked Mar 15, 2019 at 20:34

1 vote

2 answers

1k views

How do I enable full text search on MySql 8?

asked Aug 14, 2020 at 15:56

1 vote

1 answer

2k views

How do I import CSV UUID data into Postgres on the command line?

asked Dec 12, 2021 at 0:58

1 vote

0 answers

987 views

Is it possible to update Mac mysqldump version to same version as what's available for Ubuntu?

asked Jan 27, 2022 at 21:15

1 vote

1 answer

853 views

Why isn't my Postgres index being used?

asked Nov 23, 2016 at 20:04

1 vote

1 answer

17k views

How do I disable foreign key constraints in my Postgres dump file?

asked Dec 29, 2016 at 4:14

1 vote

2 answers

275 views

How do I rewrite my query to use less temporary space?

asked Apr 11, 2017 at 1:34

1 vote

1 answer

239 views

Why is LIKE producing different results than my regex?

asked Apr 25, 2017 at 17:05

1 vote

0 answers

4k views

Getting "pg_ctl: No such file or directory" when trying to start Postgres server on Mac

asked Jun 22, 2017 at 17:05

0 votes

1 answer

11k views

How do I export Postgres data in "Insert ... on conflict" format instead of "cp" format?

asked Dec 26, 2016 at 15:52

0 votes

1 answer

2k views

In Postgres 12, how do I set a default schema when logging in using psql?

asked Jul 20, 2022 at 14:28

Stack Exchange Network

36 Questions

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

Find rows in which the column doesn't contain a "space"

psql is not prompting me for a password, then denies access

In Postgres, set log_rotation_size but my logs are still not rotating

Why is Postgres not respecting my log file name convention dictated by "log_filename"?

How do I uninstall the old version of Postgres on CentOS 7?

How do I enable md5 authentication for only one user?

Can connect to virtual MySql instance using 127.0.0.1, but not localhost

How do I generate a Postgres dump with the column names in my INSERT statement?

In Postgres, how do I adjust the "pgsql_tmp" setting?

Is there a more efficient way to search for a record but only if it has associations?

How do I build a PostgreSQL ORDER BY expression based on a concatenation of columns?

How do I set MySQL's "character_set_server" and "collation_server" variables when creating a database?

Select rows from my table where a character column matches a pattern

How do I create a psql alias for "\q"?

Want to clone a role, but am getting "can't login" message after doing so

Export Postgres data without superuser privileges

How do I limit the size of my Postgres log?

Ran "Grant all privileges" but still getting "permission denied for relation"

Is there a more concise way in Postgres to extract a portion of a string?

How do I enable full text search on MySql 8?

How do I import CSV UUID data into Postgres on the command line?

Is it possible to update Mac mysqldump version to same version as what's available for Ubuntu?

Why isn't my Postgres index being used?

How do I disable foreign key constraints in my Postgres dump file?

How do I rewrite my query to use less temporary space?

Why is LIKE producing different results than my regex?

Getting "pg_ctl: No such file or directory" when trying to start Postgres server on Mac

How do I export Postgres data in "Insert ... on conflict" format instead of "cp" format?

In Postgres 12, how do I set a default schema when logging in using psql?