sql table definitions

[James]

On 02/04/2019 05:42, Richard Hector via dovecot wrote:

> I'm using PostgreSQL for my auth db. I used the example CREATE TABLE
> statement in the config file, but now I find the fields are too short. I
> assume dovecot will be fine with 'text' type columns replacing the
> varchars? Or failing that, I can change the length of the varchar fields?

ALTER TABLE $table ALTER COLUMN $column TYPE VARCHAR($newlenth);


My tables are very different from the dovecot suggested tables and it 
works, just make sure the queries in dovecot-sql.conf correspond.  My 
tables are different because they hold additional information for 
routing (the db is shared with exim).