[postgis-users] create table '||newtable||' (LIKE '||oldtable||' including constraints)

Júlio Almeida julio.augusto.almeida at gmail.com
Fri Apr 15 09:53:09 PDT 2011


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110415/43224447/attachment.html>


More information about the postgis-users mailing list