Skip to main content
Dave's user avatar
Dave's user avatar
Dave's user avatar
Dave
  • Member for 7 years, 9 months
  • Last seen more than a month ago
18 votes
2 answers
70k views

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

7 votes
3 answers
23k views

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

7 votes
2 answers
12k views

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

6 votes
4 answers
18k views

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

5 votes
1 answer
2k views

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

4 votes
2 answers
20k views

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

4 votes
2 answers
46k views

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

3 votes
3 answers
4k views

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

3 votes
1 answer
929 views

How do I enable md5 authentication for only one user?

3 votes
3 answers
2k views

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

3 votes
1 answer
16k views

Export Postgres data without superuser privileges

3 votes
1 answer
413 views

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

3 votes
1 answer
2k views

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

3 votes
2 answers
21k views

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

3 votes
0 answers
2k views

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

2 votes
1 answer
1k views

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

2 votes
1 answer
1k views

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

2 votes
1 answer
4k views

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

2 votes
1 answer
9k views

How do I limit the size of my Postgres log?

2 votes
0 answers
2k views

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

1 vote
2 answers
1k views

How do I enable full text search on MySql 8?

1 vote
1 answer
2k views

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

1 vote
0 answers
1k views

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

1 vote
2 answers
307 views

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

1 vote
1 answer
246 views

Why is LIKE producing different results than my regex?

1 vote
0 answers
4k views

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

1 vote
1 answer
924 views

Why isn't my Postgres index being used?

1 vote
1 answer
18k views

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

0 votes
1 answer
11k views

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

0 votes
1 answer
3k views

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