Popular Question - Badge - Database Administrators Stack Exchange

Popular Question

Question with 1,000 views. This badge can be awarded multiple times.

Dave

64310 gold badges18 silver badges37 bronze badges

earned this badge 26 times.

How do I enable full text search on MySql 8?

Awarded Nov 17 at 16:10

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

Awarded Jun 20 at 13:05

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

Awarded Feb 21 at 8:27

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

Awarded Feb 1 at 13:11

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

Awarded Dec 20, 2022 at 21:21

How do I escape characters when running COPY command on command line?

Awarded Dec 7, 2022 at 10:18

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

Awarded Nov 9, 2022 at 17:21

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

Awarded Jun 22, 2022 at 9:46

Export Postgres data without superuser privileges

Awarded May 26, 2022 at 8:52

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

Awarded Nov 1, 2021 at 13:46

How do I locate my Postgres data directory while the server is down?

Awarded Aug 18, 2021 at 15:48

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

Awarded Oct 9, 2020 at 12:16

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

Awarded Jul 9, 2020 at 23:00

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

Awarded Dec 4, 2019 at 16:10

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

Awarded Jan 8, 2019 at 6:15

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

Awarded Nov 12, 2018 at 22:05

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

Awarded Sep 18, 2018 at 2:15

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

Awarded Aug 22, 2018 at 14:20

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

Awarded Jul 20, 2018 at 21:08

How do I limit the size of my Postgres log?

Awarded Jul 8, 2018 at 8:31

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

Awarded Jun 12, 2018 at 8:18

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

Awarded Apr 23, 2018 at 11:34

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

Awarded Feb 14, 2018 at 22:11

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

Awarded Dec 22, 2017 at 1:01

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

Awarded Jul 7, 2017 at 5:22

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

Awarded Mar 25, 2017 at 22:52

Others with this badge