Re: Check for table existence

Поиск
Список
Период
Сортировка
От Roberto Mello
Тема Re: Check for table existence
Дата
Msg-id 20011129190525.A16107@cc.usu.edu
обсуждение исходный текст
Ответ на Check for table existence  (Michael Knudsen <mk267673@but.auc.dk>)
Список 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 по дате отправления:

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: Can I CONSTRAIN a particular value to be UNIQUE?
Следующее
От: "Jason Kwok"
Дата:
Сообщение: Selecting from a dynamic name