Re: Check for table existence - Mailing list pgsql-sql

From Roberto Mello
Subject Re: Check for table existence
Date
Msg-id 20011129190525.A16107@cc.usu.edu
Whole thread Raw
In response to Check for table existence  (Michael Knudsen <mk267673@but.auc.dk>)
List pgsql-sql
On Wed, Nov 28, 2001 at 10:47:42PM +0100, Michael Knudsen wrote:
> 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)

There's a function to check for a table's existance in the PostgreSQL
Cookbook (http://www.brasileiro.net/postgres/)

-Roberto

-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU -
http://www.brasileiro.net      http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
 
Daddy, why doesn't this magnet pick up this floppy?


pgsql-sql by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Can I CONSTRAIN a particular value to be UNIQUE?
Next
From: "Jason Kwok"
Date:
Subject: Selecting from a dynamic name