Re: Few questions

Поиск
Список
Период
Сортировка
От Darren Ferguson
Тема Re: Few questions
Дата
Msg-id Pine.LNX.4.10.10202011717480.11719-100000@thread.crystalballinc.com
обсуждение исходный текст
Ответ на Few questions  (Joep deVocht <joep@masktools.com>)
Список pgsql-general
SQL: You can make a SELECT tablename FROM pg_tables
                    WHERE tablename = 'YOUR TABLE NAME';

INTERFACE: I don't know that one

Darren

Darren Ferguson
Software Engineer
Openband

On Fri, 1 Feb 2002, 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)
>
> - Id there a call to retrieve all table names?
>
> 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?
>
> Many thanx in advance.
>
> Joep de Vocht.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>


В списке pgsql-general по дате отправления:

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: Few questions
Следующее
От: "PG Explorer"
Дата:
Сообщение: Re: Few questions