2009/3/5 Newton Teixeira do Nascimento Júnior
<newton.jun...@eletronorte.gov.br>:
>
> porém pra ela funcionar perfeitamente preciso testar se um determinado
> arquivo existe no servidor (em um path determinado).
>


Verifique se a função pg_stat_file(filename text) atende suas necessidades.
http://www.postgresql.org/docs/current/interactive/functions-admin.html

Atenção para:
"The functions shown in Table 9-55 provide native file access to files
on the machine hosting the server. Only files within the database
cluster directory and the log_directory can be accessed. Use a
relative path for files within the cluster directory, and a path
matching the log_directory configuration setting for log files. Use of
these functions is restricted to superusers. "

Osvaldo
_______________________________________________
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a