create a table inside a function - Mailing list pgsql-general

From Alain Roger
Subject create a table inside a function
Date
Msg-id 75645bbb0906250553l6c674842i67d65f8751643731@mail.gmail.com
Whole thread Raw
Responses Re: create a table inside a function
Re: create a table inside a function
List pgsql-general
Hi,

i would like to execute the following SQL command into a function based on some IF, END IF tests before.
how can i do that ?

here is my SQL command:
create table sw.tmp_import 
(
id serial NOT NULL,
software VARCHAR(1024),
barcode VARCHAR(10),
username VARCHAR(1024),
area VARCHAR(512),
locality VARCHAR(512)
CONSTRAINT id_pkey PRIMARY KEY (id))
WITH (OIDS=FALSE);

thanks a lot,
 
Alain
-----------------------------------------------------------
Windows XP x64 SP2 / Fedora 10 KDE 4.2
PostgreSQL 8.3.5 / MS SQL server 2005
Apache 2.2.10
PHP 5.2.6
C# 2005-2008

pgsql-general by date:

Previous
From: Guy Flaherty
Date:
Subject: Re: Upgrade
Next
From: Greg Stark
Date:
Subject: Re: Upgrade