Re: [GENERAL] Check if table exists

2004-12-17 Thread Guy Rouillier
ON.KG wrote: > Hi ALL! > > I need to check before selection records from table - does this table > exist How can i do that? One thing to consider: you are making a trip to the database to determine if a table exists. If it exists, you are then making another trip to the database to get rows fro

Re: [GENERAL] Check if table exists

2004-12-17 Thread ON.KG
Richard Huxton & Riccardo G. Facchini Thank you very much! ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Check if table exists

2004-12-17 Thread Riccardo G. Facchini
Sorry: I forgot to add something to option 2 --- "ON.KG" <__> wrote: > Hi ALL! > > I need to check before selection records from table - does this table > exist > How can i do that? > > Thanx in advance > > > ---(end of > broadcast)--- > TIP 1:

Re: [GENERAL] Check if table exists

2004-12-17 Thread Riccardo G. Facchini
--- "ON.KG" <__> wrote: > Hi ALL! > > I need to check before selection records from table - does this table > exist > How can i do that? > > Thanx in advance > > > ---(end of > broadcast)--- > TIP 1: subscribe and unsubscribe commands go to > [E

Re: [GENERAL] Check if table exists

2004-12-17 Thread Richard Huxton
ON.KG wrote: Hi ALL! I need to check before selection records from table - does this table exist How can i do that? You could: 1. Look in the INFORMATION_SCHEMA 2. Check pg_class 3. Examine the output of "psql -E", \d to see how psql gets its information. -- Richard Huxton Archonet Ltd

[GENERAL] Check if table exists

2004-12-17 Thread ON.KG
Hi ALL! I need to check before selection records from table - does this table exist How can i do that? Thanx in advance ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]