From: | Darren Ferguson <darren(at)crystalballinc(dot)com> |
---|---|
To: | Joep deVocht <joep(at)masktools(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Few questions |
Date: | 2002-02-01 22:19:03 |
Message-ID: | Pine.LNX.4.10.10202011717480.11719-100000@thread.crystalballinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)postgresql(dot)org)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 2002-02-02 01:03:14 | Re: [GENERAL] timestamp weirdness |
Previous Message | Oliver Elphick | 2002-02-01 22:04:41 | Re: Few questions |