Richard, > But only if 'sometable.csv' exists; > > If 'sometable.csv' does not exist as an input table I want to continue > the next command.
Sorry, can't be done in plpgsql. Regular procedural languages are deliberately kept ignorant of the host filesystem in order to prevent database users from being able to compromise it. It's a security thing. You could easily write a function in an "untrusted" language, like PL/PerlU or PL/PythonU, which would test for file existence and return a true/false value. -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly