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

Júlio Almeida julio.augusto.almeida at gmail.com
Sun Apr 17 07:38:49 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/20110417/a0416cea/attachment.html>


More information about the postgis-users mailing list