Re: Few questions

On Fri, 2002-02-01 at 21:28, Joep deVocht wrote:
>
> Hi,
>
> I have a few questions. I read through the docs but didn't
> seem to find the answers.
>
> SQL:
>
> - Is it possible to check whether a table exists?
>   (I have a script in which I need to delete tables when they exist.
>    And I don't want the error-message when I simply delete it)

  SELECT * FROM pg_tables WHERE tablename = 'your_table_name';

> - Id there a call to retrieve all table names?

  SELECT tablename FROM pg_tables;

(pg_tables is a view of pg_class.)

> Interface:
>
> - I'm using large objects. What I see is that if I create a large object
>   and then delete it again later (which will happen often), the large
> object id
>   (loid) keeps increasing. This worries me a bit since I don't know
> what's going to
>    happen when that variable hit MAXINT or something similar.
>   Is there a way to reset the loid?

I don't know that one.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "And be not conformed to this world; but be ye
      transformed by the renewing of your mind, that ye may
      prove what is that good, and acceptable, and perfect,
      will of God."             Romans 12:2