Re: Few questions
От | Oliver Elphick |
---|---|
Тема | Re: Few questions |
Дата | |
Msg-id | 1012601082.3181.88.camel@linda обсуждение исходный текст |
Ответ на | Few questions (Joep deVocht <joep@masktools.com>) |
Список | pgsql-general |
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
Вложения
В списке pgsql-general по дате отправления: