Re: [GENERAL] change database

2009-07-17 Thread Florian Chis
Since there is no other way, I'll close it then reopen it again. Thank you for your time. Regards, Florian Chis 2009/7/15 Bill Moran > In response to Florian Chis : > > > > I'm working on a port from mysql to postgres. I have a function which > > connect's to the database, checks for database

Re: [GENERAL] change database

2009-07-15 Thread Bill Moran
In response to Florian Chis : > > I'm working on a port from mysql to postgres. I have a function which > connect's to the database, checks for database existance and creates it > otherwise. > The last thing it does it executes "use my_database" (mysql stuff). Now I'm > trying to find something si

Re: [GENERAL] change database

2009-07-15 Thread Jeff Davis
On Wed, 2009-07-15 at 11:36 +0300, Florian Chis wrote: > I'm working on a port from mysql to postgres. I have a function which > connect's to the database, checks for database existance and creates > it otherwise. > The last thing it does it executes "use my_database" (mysql stuff). > Now I'm tryin

[GENERAL] change database

2009-07-15 Thread Florian Chis
Hi, I'm working on a port from mysql to postgres. I have a function which connect's to the database, checks for database existance and creates it otherwise. The last thing it does it executes "use my_database" (mysql stuff). Now I'm trying to find something similar in postgres. I know that psql ha

Re: [GENERAL] change database encoding without corrupting data (latin9 to utf8)

2007-05-19 Thread Michael Fuhr
On Fri, May 18, 2007 at 02:46:26AM -0700, filippo wrote: > I have a problem to entry data to postgres database (latin9) from my > perl/tk application running on windows (utf8). Whenever I try to entry > letter with accents, these looks corrupted once stored into database. > > A workaround is to se

[GENERAL] change database encoding without corrupting data (latin9 to utf8)

2007-05-19 Thread filippo
I have a problem to entry data to postgres database (latin9) from my perl/tk application running on windows (utf8). Whenever I try to entry letter with accents, these looks corrupted once stored into database. A workaround is to set client encoding to UTF8 after creating the database connection: