[postgis-users] tiger_geocoder import error

[Stephen Woodbridge]

Depends on if you just want to rename them or copy them!

Rename like:

create schema tiger_data;
begin;
-- first rename the table
alter table tiger_staging.fl_tabblock10 rename fl_tabblock;
-- then move it to the new schema
alter table tiger_staging.fl_tabblock set schema tiger_data;
commit;

If there are name conflicts you can move it to the new schema then 
rename it. If you want to copy the data then look at commands like:

create table tiger_data.fl_tabblock as select * from 
tiger_staging.fl_tabblock10;

or

insert into tiger_data.fl_tabblock (<column_list>) select <column_list> 
from tiger_staging.fl_tabblock10;

-Steve W

On 5/22/2012 11:46 AM, Jeff Rossi wrote:
> Any idea how I can get the 480K records from tiger_staging.fl_tabblock10
> to  tiger_data.fl_tabblock
>
> On Tue, May 22, 2012 at 8:47 AM, Mario Sileone [via PostGIS] <[hidden
> email] </user/SendEmail.jtp?type=node&node=4997655&i=0>> wrote:
>
>     Dear Jeff:
>              according to the error detailed
>     ERROR:  INSERT has more expressions than target columns
>              You Have:
>     the_geom,intptlon,intptlat,awater,aland,funcstat,uace,ur,mtfcc,name,tabblock_id,blockce,tractce,countyfp,statefp
>
>
>     Which count 15 expressions and
>
>     the_geom,intptlon10,intptlat10,awater10,aland10,funcstat10,uatyp10,uace10,ur10,mtfcc10,name10,tabblock_id,blockce10,tractce10,countyfp10,statefp10
>
>
>     are 16 values.
>
>     So, or You have a missin expression or one more value, check this.
>
>     Best Regards
>
>
>     El 22/05/2012 8:45, Jeff Rossi escribió:
>
>      > Sorry if this is a double post, had an issue with my mail server
>     and had to
>
>      > use my personal email.
>      >
>      > This is my first project with postgresql/postgis and it is
>     possible and
>      > maybe even probable that I made an error.  I used pgadmin to
>     generate import
>      > scripts by state and started with florida. The errors are below:
>      >
>      > ####
>      >
>      > COMMIT
>      > NOTICE:  INSERT INTO
>      >
>     tiger_data.fl_tabblock(the_geom,intptlon,intptlat,awater,aland,funcstat,uace,ur,mtfcc,name,tabblock_id,blockce,tractce,countyfp,statefp)
>
>      > SELECT
>      >
>     the_geom,intptlon10,intptlat10,awater10,aland10,funcstat10,uatyp10,uace10,ur10,mtfcc10,name10,tabblock_id,blockce10,tractce10,countyfp10,statefp10
>
>      > FROM tiger_staging.fl_tabblock10;
>      > CONTEXT:  SQL function "loader_load_staged_data" statement 1
>      > ERROR:  INSERT has more expressions than target columns
>      > LINE 1:
>     ...name10,tabblock_id,blockce10,tractce10,countyfp10,statefp10 ...
>      >                                                              ^
>      > QUERY:  INSERT INTO
>      >
>     tiger_data.fl_tabblock(the_geom,intptlon,intptlat,awater,aland,funcstat,uace,ur,mtfcc,name,tabblock_id,blockce,tractce,countyfp,statefp)
>
>      > SELECT
>      >
>     the_geom,intptlon10,intptlat10,awater10,aland10,funcstat10,uatyp10,uace10,ur10,mtfcc10,name10,tabblock_id,blockce10,tractce10,countyfp10,statefp10
>
>      > FROM tiger_staging.fl_tabblock10;
>      > CONTEXT:  PL/pgSQL function "loader_load_staged_data" line 24 at
>     EXECUTE
>      > statement
>      > SQL function "loader_load_staged_data" statement 1
>      >
>      > ####
>      >
>      > It appears to me that the extra column is uatyp10
>      >
>      > Many Thanks for your Assistance,
>      >
>      > Jeff
>      >
>      > --
>      > View this message in context:
>     http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634.html
>      > Sent from the PostGIS - User mailing list archive at Nabble.com.
>      > _______________________________________________
>      > postgis-users mailing list
>      > [hidden email]
>     <http://user/SendEmail.jtp?type=node&node=4997640&i=0>
>      > http://postgis.refractions.net/mailman/listinfo/postgis-users
>      >
>
>
>     --
>     Mario Sileone
>     _______________________________________________
>     postgis-users mailing list
>     [hidden email] <http://user/SendEmail.jtp?type=node&node=4997640&i=1>
>     http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>     If you reply to this email, your message will be added to the
>     discussion below:
>     http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997640.html
>
>     To unsubscribe from tiger_geocoder import error, click here.
>     NAML
>     <http://postgis.17.n6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
>
>
>
>
> --
> Regards
>
> Jeff Rossi
>
> Intouch MVC
> 1506 Tuscaloosa Ave
> Holly Hill, FL 32117
> (386) 226-8979
>
> View this message in context: Re: tiger_geocoder import error
> <http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997655.html>
> Sent from the PostGIS - User mailing list archive
> <http://postgis.17.n6.nabble.com/PostGIS-User-f3516033.html> at Nabble.com.
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users