On Aug 25, 2004, at 8:37 PM, Mário Gamito wrote:
> why this gives an error ?
>
> SELECT url_negado INTO OUTFILE '/tmp/urls_negados.txt' FROM
> urls_negados;
I'm not sure whether this is a MySQLism or part of the SQL spec not
implemented in PostgreSQL, but I suspect the former. INTO OUTFILE is
not valid in PostgreSQL. You might want to look at the COPY command
<http://www.postgresql.org/docs/current/static/sql-copy.html>
, or perhaps using \o in psql to redirect results to a file.
<http://www.postgresql.org/docs/current/static/app-psql.html>
The PostgreSQL SQL command reference lists valid SQL syntax. I think
you'll find it useful.
Michael Glaesemann
grzm myrealbox com