Moving Data In and Out of PostGIS - PostGIS - page 18

CREATE TABLE
"chp01"."global_24h_geographic" (gid
serial PRIMARY KEY,
"latitude" varchar(80),
"longitude" varchar(80),
"brightness" varchar(80),
...
"frp" varchar(80),
"geog" geography(POINT,4326));
INSERT INTO
"chp01"."global_24h_geographic"
("latitude","longitude","brightness","scan","track","acq_date","acq_time","satellite","confidence","version","bright_t31","frp",geog)
VALUES
('-23.386','-46.197','307.5','1.1','1','2012-08-20','0140','T','54','5.0','285.7','16.5','0101000000F0A7C64B371947C0894160E5D06237C0');
...
4. Run the global_24h.sql file in PostgreSQL:
$ psql -U me -d postgis_cookbook -f
global_24h.sql
Tip
If you are on Linux, you may concatenate the commands from the last
two steps in a single line in the following manner:
$ shp2pgsql -G -I global_24h.shp
chp01.global_24h_geographic | psql -U
me -d postgis_cookbook
5. Check if the metadata record is visible in the geography_columns view
(and not in the geometry_columns view as with the -G option of the
shp2pgsql command, we have opted for a geography type):