Postgres pg_delete和“DELETE FROM ...”之间的差异

Question

PHP: pg_delete : http://php.net/manual/es/function.pg-delete.php

and use: "Delete From . . ."

What is the difference between both sequences? wich one is more efficient? ¿Wich one have less probable to get errors?

Answer 1

To be honest, I'm only guessing here as I've never used pg_delete(), but I'd say that it constructs a DELETE FROM... query behind the scenes and sends it to the server.

Given this, the difference between them is that with DELETE FROM... you are writing the SQL by hand, while with pg_query() you're using a PHP function that does it for you (albeit at the cost of less flexibility).

Which you use will depend on what framework you're using for your database queries, and what you're most comfortable doing.