I'm not sure what mysql uses for passwords, but the source is available so
you could always wrip out the code for their password function and make a
postgresql version... then you wouldn't have to change any of the SQL
scripts at all...
-philip
On Wed, 10 Jul 2002, Roderick A. Anderson wrote:
> 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..."
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>