Oh my god. I never thought I'd be asking a MySQL question on this list
but being lazy this week I'll give it a shot.
I'm attempting to convert an application from MySQL to PostgreSQL. Got
pretty much all done except for a few lines loading some sample data into
the tables. I didn't even notice this until I got an error message. Just
cut and pasted the code into psql.
The insert statement has one value of "password('foo')." Since the app
was designed for MySQL I'm sure I'll run into this later so I need to
figure out the PgSQL way or a workaround. My guess is this is a function
to encrypt 'foo'. Is there a similar functionality in Pg? My look
through Bruce's and the O'Reilly Mammoth books turned up nothing. Is
there something in contrib that does this?
TIA,
Rod
--
"Open Source Software - Sometimes you get more than you paid for..."