I have the following 2 tables, and a spread sheet that needs to be
converted to the assigned_networks table. In the spreadsheet there is
an approximation of the router name, but it needs some massaging. I need
to load the id field of the router table into the router field of the
assigned networks table. Is there an easy way to code a function that
can massage the name to the correct DNS name to do this at insert time?
Thanks!
LER
--
Larry Rosenman http://www.lerctr.org/~ler/
Phone: +1 972 414 9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 US
ler=# \d router Table "router"Attribute | Type |
Modifier
-----------+------------------------+-----------------------------------
----------------id | integer | not null default
nextval('"router_id_seq"'::text)name | character varying(256) | ethernet | inet | model |
charactervarying(256) | nexthop | inet | comments | character varying(256) |
Index: router_pkey
ler=# \d assigned_networks Table "assigned_networks" Attribute | Type | Modifier
-------------------+------------------------+----------netblock | cidr | router |
integer | interface | character varying(256) | dest_ip | inet |
mis_token | character(16) | assigned_date | date | assigned_by | character
varying(256)| justification_now | integer | justification_1yr | integer | cust_asn
| smallint |
ler=#