Postgres Pro
Downloads
Home   >   mailing lists

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

From Alexander Steinert
Subject Re: Check for table existence
Date
Msg-id 20011129151734.C859@tyche.svt.tu-harburg.de
Whole thread Raw
In response to Check for table existence  (Michael Knudsen <mk267673@but.auc.dk>)
List pgsql-sql
Tree view 
> First, let me say that I am new to postgres. I used MySQL before, but..
> ehm..

Welcome.

>     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)

http://archives2.us.postgresql.org/pgsql-sql/2001-07/msg00319.php
and
http://archives2.us.postgresql.org/pgsql-sql/2001-07/msg00403.php
will show you the way to go.

Stony

pgsql-sql by date:

Previous
From: Gary Stainburn
Date:
Subject: Re: Fixing faulty dates - select on day part of a date field
Next
From: Markus Bertheau
Date:
Subject: Re: Fixing faulty dates - select on day part of a date field