Home > mailing lists

create table sintax - Mailing list pgsql-general

From	Júlio Almeida
Subject	create table sintax
Date	April 19, 2011 08:51:15
Msg-id	BANLkTim67wD0PE02KPFobpOkEUQ7p6WRng@mail.gmail.com Whole thread Raw
Responses	Re: create table sintax
List	pgsql-general

Hello,

If I run

create table newtable (like oldtable including constraints);

in the SQL window with works just file.

But if i execute

execute 'create table '||newtable||' (LIKE '||oldtable||' including constraints)';

inside a function, in a LOOP, the constraints aren't created.

What is the problem?

Tanks,

julio almeida

From: Nick Raj
Date: 19 April 2011, 05:56:45
Subject: Re: Typecast

From: Frank van Vugt
Date: 19 April 2011, 10:40:03
Subject: Re: REASSIGN OWNED doesn't for all objects, ALTER FUNCTION seems to fix it