Fwd: From MySQL to PostgreSQL - Mailing list pgsql-php

From Matthew Terenzio
Subject Fwd: From MySQL to PostgreSQL
Date
Msg-id ca7cf34386a2f595dd0becac5af9f0c2@jobsforge.com
Whole thread Raw
List pgsql-php
On Feb 22, 2005, at 6:07 AM, Zouari Fourat wrote:

> Am just migrating from mysql db to pgsql db, an want to ask about some
> clarifications on the php pgsql api :
>
> *> is pg_fetch_all faster than iterating with pg_fetch_assoc ?
I think you should be fine with it. According to the manual,
pg_fect_assoc() is NOT significantly slower than pg_fetch_row.

> *> how to avoid sql injections, should i use the same methods with
> mysql ? (addslashes)

You should use pg_escape_string(), not addslashes.


>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>


pgsql-php by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: PostgreSQL encoding
Next
From: Ron Ellingson
Date:
Subject: permission problems