create a table inside a function

From: Alain Roger <raf(dot)news(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: create a table inside a function
Date: 2009-06-25 12:53:59
Message-ID: 75645bbb0906250553l6c674842i67d65f8751643731@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2009-06-25 12:54:37 Re: Upgrade
Previous Message Guy Flaherty 2009-06-25 12:28:07 Re: Upgrade