Re: [SQL] Test if a table is present

On Sat, 26 Jul 2008, "Ole Ekerhovd" <[EMAIL PROTECTED]> writes: > How can I test if a table is present in database? SELECT TRUE FROM information_schema.tables WHERE table_name = '' AND table_schema = '' BTW, this query is portable across database systems supporting information

Re: [SQL] Test if a table is present

you can find it throuh a query like this select tablename from pg_tables where tablename = 'tbl_updated_status_master'; regards: Anoop

Re: [SQL] Test for file exists?

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

Re: [SQL] test

At least you could spell your ads correctly ! - Plusieurs centaines de magasins re'fe'rence's - Les ide'es d'olivia bye, Jerome ALET - [EMAIL PROTECTED] - http://cortex.unice.fr/~jerome Faculte de Medecine de Nice - http://noe.unice.fr - Tel: 04 93 37 76 30 28 Avenue de Valombrose - 06107 NICE