Re: Question about SQL statement error

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