PostgreSQL- Create Table

**dreamduster** · Dec 3, 2008 05:14

Hello

I want to create a table if it does not exists (via ASP). I tried somethig like this but i get an error.

Code:

strCheck = "SELECT * FROM " & TableName
oConn.Execute strCheck		
IF (oRs.EOF) then
 --- create table
END IF

error:

Code:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
ERROR: relation "mod48_00_2009" does not exist

How should i test this??

Thank you

**tripy** · Dec 3, 2008 06:39

use the system tables:

Code:

IF NOT EXISTS(SELECT tablename FROM pg_catalog.pg_tables WHERE tablename = 'mod48_00_2009')
...

Or, via the information_schema:

Code:

IF NOT EXISTS(SELECT table_name FROM information_schema.tables where table_name = 'mod48_00_2009')
....

**dreamduster** · Dec 3, 2008 10:34

thanks.. i will try it

User Tag List