This is a testplease disgregard.
This is a test, please disregard.
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
you can find it throuh a query like this
select tablename from pg_tables where tablename =
'tbl_updated_status_master';
regards:
Anoop
How can I test if a table is present in database?
Regards,
Ole
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
I want to use pgsql to send the command:
Copy sometable from 'sometable.csv';
But only if 'sometable.csv' exists;
If 'sometable.csv' does not exist as an input table I want to continue
the next command.
My full procedure is as follows and any help is greatly appreciated.
Thanks
Richard
CREAT
Please ignore - testing a previously misconfigured email client
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
testing 1,2,3
---(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
Just a teste, please ignore
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
x
--
Kaare Rasmussen--Linux, spil,--Tlf:3816 2582
Kaki Datatshirts, merchandize Fax:3816 2501
Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECTED]
2000 FrederiksbergLørdag 11.00-17.00 Web: www.suse
Please ignore.
Thanks
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
test
--
**
POZZO Ange Michel
mail : [EMAIL PROTECTED]
Administrateur - Développeur
ALPINFO
617 Rue Denis Papin
73290 La Motte Servolex
Savoie - France
tel : 04 79 26 06 28
fax : 04 79 25 68 36
Zonecommerce, l'annuaire fr
This is a test to see if I can post. Seems my last post didn't go
through...
15 matches
Mail list logo