International SQL-Ledger Network Association

User Tools

Site Tools

Trace:
psql_ascii_2_utf8

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
psql_ascii_2_utf8 [2014/10/20 15:19] – sweitmannpsql_ascii_2_utf8 [2014/10/20 15:21] – sweitmann
Line 5: Line 5:
 Then switch to the "postgres" account: Then switch to the "postgres" account:
      su postgres      su postgres
-Now create a dump of your SQL_ASCII database:+Now start by creating a dump of your SQL_ASCII database:
  
      pg_dump SQL_ASCII_database_name > SQL_ASCII_database_dump.sql      pg_dump SQL_ASCII_database_name > SQL_ASCII_database_dump.sql
Line 11: Line 11:
  
     file SQL_ASCII_database_dump.sql     file SQL_ASCII_database_dump.sql
-You should get the following output: +You should get the following output:    
-    +
     SQL_ASCII_database_dump.sql: ISO-8859 text     SQL_ASCII_database_dump.sql: ISO-8859 text
 Then you convert your ISO-8859 file to UTF8 by typing: Then you convert your ISO-8859 file to UTF8 by typing:
psql_ascii_2_utf8.txt · Last modified: 2023/02/20 14:52 by sweitmann