Stack Exchange

Daniel Vérité

Paris, France

https://postgresql.verite.pro

Writing free software, maintaining databases and mail systems.
I use mostly PostgreSQL, C++/Qt, Perl, php on Unix servers.
Author of manitou-mail
Tweets (lang=fr,en) @DanielVerite
PostgreSQL blog in english
PostgreSQL blog in french

top accounts reputation activity subscriptions
Top Questions
Top Answers
424
Using current time in UTC as default value in PostgreSQL
stackoverflow.com

297
PostgreSQL: Resetting password of PostgreSQL on Ubuntu
stackoverflow.com

294
Granting a user account permission to create databases in PostgreSQL
dba.stackexchange.com

216
Options to retrieve the current (on a moment of running query) sequence value
stackoverflow.com

160
Using psql to connect to PostgreSQL in SSL mode
stackoverflow.com

157
Postgres ERROR: could not open file for reading: Permission denied
stackoverflow.com

125
How to search a specific value in all tables (PostgreSQL)?
stackoverflow.com

99
Creating user with encrypted password in PostgreSQL
stackoverflow.com

89
"cannot write to log file pg_upgrade_internal.log" when upgrading from Postgresql 9.1 to 9.3
stackoverflow.com

79
Postgres password authentication fails
stackoverflow.com

78
Measure the size of a PostgreSQL table row
dba.stackexchange.com

77
Check return status of psql command in unix shell scripting
stackoverflow.com

75
Hashing a String to a Numeric Value in PostgreSQL
stackoverflow.com

75
Is there a "pg_restore --quiet" option like "psql --quiet"?
stackoverflow.com

73
Why is a new user allowed to create a table?
dba.stackexchange.com

73
Created user can access all databases in PostgreSQL without any grants
dba.stackexchange.com

68
Do I need to reindex after vacuum full on Postgres 9.4
stackoverflow.com

59
Does adding a null column to a postgres table cause a lock?
stackoverflow.com

59
Is there a maximum length constraint for a postgres query?
dba.stackexchange.com

57
How to duplicate huge postgres table?
dba.stackexchange.com

54
How to handle special characters in the password of a Postgresql URL connection string?
stackoverflow.com

52
ERROR: cannot execute CREATE TABLE in a read-only transaction
stackoverflow.com

51
Preventing PostgreSQL from starting on boot in Ubuntu
dba.stackexchange.com

50
What is the impact of LC_CTYPE on a PostgreSQL database?
dba.stackexchange.com

48
ERROR: no schema has been selected to create in
dba.stackexchange.com

44
PostgreSQL - how to render date in different time zone?
stackoverflow.com

39
Can't log into system user postgres
stackoverflow.com

38
How to fix pg_dump version mismatch errors?
stackoverflow.com

38
How do you find the row count for all your tables in Postgres
stackoverflow.com

35
Constraint defined DEFERRABLE INITIALLY IMMEDIATE is still DEFERRED?
stackoverflow.com

1 2 3 4 5 … 10