I have a PostGIS database with an empty table ch01.highways. With the following code, I want to populate the table:
INSERT INTO ch01.highways (gid, feature, name, state, geom) SELECT gid, feature, name, state, ST_TRANSFORM(geom, 2163) FROM ch01.highways_staging WHERE feature LIKE 'Principal Highway%'
The ch01.highways_staging table was imported with the shp2pgsql-gui. For both tables, the owner is postgres.
When I run the command the ch01.highways remains empty, no data are imported.