Skip to main content
Database Administrators

Notable Question

 Notable Question
Question with 2,500 views. This badge can be awarded multiple times.

earned this badge 19 times.
How do I build a PostgreSQL ORDER BY expression based on a concatenation of columns?
Awarded Sep 6 at 6:17
How do I escape characters when running COPY command on command line?
Awarded Jul 31 at 5:55
How do I import CSV UUID data into Postgres on the command line?
Awarded Jul 27 at 3:17
In Postgres 12, how do I set a default schema when logging in using psql?
Awarded Mar 3 at 12:27
Is there a more concise way in Postgres to extract a portion of a string?
Awarded May 24, 2023 at 17:25
Export Postgres data without superuser privileges
Awarded Aug 13, 2022 at 15:03
How do I locate my Postgres data directory while the server is down?
Awarded Apr 3, 2022 at 15:30
Getting "pg_ctl: No such file or directory" when trying to start Postgres server on Mac
Awarded Dec 8, 2021 at 8:26
Select rows from my table where a character column matches a pattern
Awarded Jul 15, 2020 at 13:45
psql is not prompting me for a password, then denies access
Awarded Oct 17, 2019 at 13:50
How do I limit the size of my Postgres log?
Awarded Jun 23, 2019 at 8:25
In Postgres, how do I adjust the "pgsql_tmp" setting?
Awarded May 23, 2019 at 7:30
How do I export Postgres data in "Insert ... on conflict" format instead of "cp" format?
Awarded Jan 24, 2019 at 3:05
Find rows in which the column doesn't contain a "space"
Awarded Dec 1, 2018 at 5:55
How do I uninstall the old version of Postgres on CentOS 7?
Awarded Nov 28, 2018 at 10:10
In Postgres, set log_rotation_size but my logs are still not rotating
Awarded Oct 5, 2018 at 10:40
How do I set MySQL's "character_set_server" and "collation_server" variables when creating a database?
Awarded Jun 28, 2018 at 7:13
How do I disable foreign key constraints in my Postgres dump file?
Awarded Nov 27, 2017 at 5:51
How do I install/enable the uuid-ossp extension on Postgres 9.3?
Awarded Aug 21, 2017 at 15:36

Others with this badge