[GENERAL] Check if table exists

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]

Re: [GENERAL] Check if table exists

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

Re: [GENERAL] Check if table exists

--- 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 [EMAIL PROTECTED]

Re: [GENERAL] Check if table exists

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: subscribe and

Re: [GENERAL] Check if table exists

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

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 from