Re: Question about SQL statement error

Mário Gamito wrote:
> Hi,
>
> I'm a newbie at postgreSQL, although i have years of experience with MySQL.

Hi Mario. No problem, but try not to reply to existing messages to post
a new question.

> My question is (and i tried to found the answer):
> why this gives an error ?
>
> SELECT url_negado INTO OUTFILE '/tmp/urls_negados.txt' FROM urls_negados;

INTO OUTFILE ... is not SQL.

From psql you can use:
\o MYFILE.TXT
SELECT * FROM ...

SQL syntax is in the "SQL COMMANDS" section of the manuals. See the
"client applications" section for details on psql.

HTH
--
Richard Huxton
Archonet Ltd