[postgis-users] How can I add geom column into a temporary table?

[Fay Du]

Thanks for your help, Gustavo.
But 4gl does not like geometry. When I compile it, I got error message
geometry is not a league data type. And I was given a list of data type
I should use at here. 
Fay

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Gustavo Henrique Sberze Ribas
Sent: Thursday, June 08, 2006 9:39 AM
To: PostGIS Users Discussion
Subject: RES: [postgis-users] How can I add geom column into a temporary
table?

Hello,

  You can add it during the creation of the temporary table, just add
a field of type 'GEOMETRY'.

Ex:
   CREATE TABLE "myTable" (
      "gid"   integer   NOT NULL,
      "geom"  geometry
   )
 
--
Gustavo

-----Mensagem original-----
De: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] Em nome de Fay Du
Enviada em: quarta-feira, 7 de junho de 2006 11:47
Para: postgis-users at postgis.refractions.net
Assunto: [postgis-users] How can I add geom column into a temporary
table?


Hi list:
I need to create a temporary table while I am running 4gl program. I
want to add geometry column into the table. And SELECT AddGeometryColumn
seems does not work for temporary table. How can I add this column into
the table? Many thanks for the help.
 
Fay
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users