Skip to content

Instantly share code, notes, and snippets.

@joshteng

joshteng/psql_encoding.markdown

Forked from turboladen/psql_encoding.sql
Last active October 31, 2022 19:23
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save joshteng/9895494 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save joshteng/9895494 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. Joshua Teng revised this gist Apr 1, 2014. 1 changed file with 1 addition and 2 deletions.
    3 changes: 1 addition & 2 deletions psql_encoding.markdown
    View file
    Original file line number Diff line number Diff line change
    @@ -6,8 +6,7 @@ psql
    ```sql
    update pg_database set datistemplate=false where datname='template1';
    drop database Template1;
    create database template1 with owner=postgres encoding='UTF-8'
    lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;
    create database template1 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;
    update pg_database set datistemplate=true where datname='template1';
    \q
    ```
  2. Joshua Teng renamed this gist Apr 1, 2014. 1 changed file with 7 additions and 3 deletions.
    10 changes: 7 additions & 3 deletions psql_encoding.sql → psql_encoding.markdown
    View file
    Original file line number Diff line number Diff line change
    @@ -1,13 +1,17 @@
    ```shell
    sudo su postgres

    psql
    ```

    ```sql
    update pg_database set datistemplate=false where datname='template1';
    drop database Template1;
    create database template1 with owner=postgres encoding='UTF-8'
    lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;

    update pg_database set datistemplate=true where datname='template1';
    \q
    ```

    exit
    ```sh
    exit
    ```
  3. Joshua Teng revised this gist Apr 1, 2014. 1 changed file with 4 additions and 1 deletion.
    5 changes: 4 additions & 1 deletion psql_encoding.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -7,4 +7,7 @@ drop database Template1;
    create database template1 with owner=postgres encoding='UTF-8'
    lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;

    update pg_database set datistemplate=true where datname='template1';
    update pg_database set datistemplate=true where datname='template1';
    \q

    exit
  4. @turboladen turboladen created this gist Oct 2, 2013.
    10 changes: 10 additions & 0 deletions psql_encoding.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,10 @@
    sudo su postgres

    psql

    update pg_database set datistemplate=false where datname='template1';
    drop database Template1;
    create database template1 with owner=postgres encoding='UTF-8'
    lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;

    update pg_database set datistemplate=true where datname='template1';