[postgis-users] create table sintax

Júlio Almeida julio.augusto.almeida at gmail.com
Tue Apr 19 01:46:18 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/20110419/dc2037e2/attachment.html>


More information about the postgis-users mailing list