Request a Demo
Home   >   mailing lists

question on renaming a foreign key - Mailing list pgsql-general

From Jonathan Vanasco
Subject question on renaming a foreign key
Date
Msg-id 05248EA4-C1AA-45BE-A203-FB87CA94C2B8@2xlp.com
Whole thread Raw
In response to Re: Newbie question about importing text files...  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: question on renaming a foreign key
Re: question on renaming a foreign key
List pgsql-general
Tree view 
I made a  HUGE mistake, and used 'UK' as the abbreviation for the
united kingdom ( the ISO abbv is 'GB' )

I've got a database where 8 tables have an FKEY on a table
'location_country' , using the text 'uk' as the value -- so i've got
9 tables that I need to swap data out on

can anyone suggest a non-nightmarish way for me to do this ?

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Newbie question about importing text files...
Next
From: Jeff Davis
Date:
Subject: Re: Is it possible to return custom type as proper ROW?