| From: | Jochem van Dieten <jochemd(at)oli(dot)tudelft(dot)nl> |
|---|---|
| To: | Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: What is best way to query presence of a table |
| Date: | 2003-01-03 02:23:19 |
| Message-ID: | 3E14F417.5050705@oli.tudelft.nl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> Subject: What is best way to query presence of a table
> From: Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com>
> Date: Thu, 02 Jan 2003 16:45:37 -0800
> To: pgsql-general <pgsql-general(at)postgresql(dot)org>
>
> What is the best way to query presence of a table
> I'd like to solve this such that I'm protected from internal changes
> within PG.
You might want to grab the INFORMATION_SCHEMA patch from the current
source (src/backend/catalog) and apply that (after removing the check
constraint on the domain, I think it is not implemented in 7.3). That
would give you a method that should be safe for the future and portable
to other databases.
Jochem
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hadley Willan | 2003-01-03 02:24:13 | Re: no space left on device |
| Previous Message | Bruce Momjian | 2003-01-03 02:03:48 | Re: ODBC - adding missing FROM clause entry |