| From: | Michael Knudsen <mk267673(at)but(dot)auc(dot)dk> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Check for table existence |
| Date: | 2001-11-28 21:47:42 |
| Message-ID: | 3C055B7E.BB52F0F1@but.auc.dk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi group
First, let me say that I am new to postgres. I used MySQL before, but..
ehm..
I am trying to do a small program (in C), and I have stumbled on to some
problems:
1. How can I check if a given table exists?
2. How can I check if a given existing table has the right layout? (Correct
column names and types)
Currently, I check using something like:
select * from giventable limit 0;
but that only helps checking if the table exists and if the number of
columns is correct. I'm sure, there must be a smoother way to do this, but I
cannot seem to find it. Anyone out there with good ideas?
M.
--
Rumour is information distilled so finely that it can filter through
anything.
-- (Terry Pratchett, Feet of Clay)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roberto Mello | 2001-11-29 01:32:14 | Re: PL/pgSQL loops? |
| Previous Message | Josh Berkus | 2001-11-28 21:29:14 | Re: email address for questions |