Yes you could use alter table but I meant you should click on public, which is the default value, into the gui and set it to whatever you want.
Hug -----Message d'origine----- De : postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] De la part de Ryan Dalton Envoyé : mardi 17 avril 2012 17:30 À : postgis-users@postgis.refractions.net Objet : [postgis-users] Shp2pgsql-gui, Save to schema other than public? I see that I can run the command "ALTER TABLE [name] SET SCHEMA [new_schema]" via SQL, is this what you are referring to? Or are you suggesting an alternate way to "manually edit the schema" within the GUI that I must not be seeing...? Ryan ________________________________ Did you try to edit manually the name of the shema ? That should be ok and you can do the same to set the table name, geometry column and srid. Hug ________________________________ I just got PostGIS 2.0 installed and was using the Shp2pgsql-gui to load some shapefiles into the database. I have created a 'data' schema where I was planning to store all of my imported data, but when I use the shapefile import GUI, it does not appear as though there is an option to specify which schema to load the data into, and it just goes into 'public'. Is it possible to load to an alternate schema, and am I just missing something obvious? Maybe a future feature enhancement if not? Thanks, Ryan _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
