Snippet Path

Postgresql with Fa locale and predefined tables

Authors
dockerfile
FROM postgres:14.1
RUN localedef -i fa_IR -c -f UTF-8 -A /usr/share/locale/locale.alias fa_IR.UTF-8
ENV LANG fa_IR.utf8
ADD CreateDB.sql /docker-entrypoint-initdb.d/

and CreateDB.sql could be:

sql
CREATE TABLE web_origins (
    client_id character varying(36) NOT NULL,
    value character varying(255)
);