Mário Gamito wrote:
> Hi,
>
> I'm a newbie at postgreSQL, although i have years of experience with MySQL.
>
> 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;
>
> Any help would be appreciated.
You can not do it in postgres in that way.
Try with this:
\o '/tmp/urls_negados.txt'
select url_negado from urls_negados;
\o
Regards
Gaetano Mendola