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