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

[Gustavo Henrique Sberze Ribas]

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