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