Nageshwar Rao wrote:
Can we write/read a file in postgresql procedure ?
Using one of the "untrusted" languages, yes. They can only be used by an administrator but have access to the full capabilities of the underlying procedural language.
Of course, you will read and write files as the user PostgreSQL runs as, which opens up a whole world of possibilities regarding security breaches and database destruction.
-- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq