Re: Seeking quick way to clone a row, but give it a new pk. - Mailing list pgsql-sql

From Bryce Nesbitt
Subject Re: Seeking quick way to clone a row, but give it a new pk.
Date
Msg-id 45CACE3C.4010302@obviously.com
Whole thread Raw
In response to Seeking quick way to clone a row, but give it a new pk.  (Bryce Nesbitt <bryce1@obviously.com>)
List pgsql-sql
I have a table that describes some properties.  It is logically
equivalent to:
   pk      userid   favorite_color  time_zone  count   122    100     red                   Pacific        7   145
101    blue                  Eastern      7
 

For various reasons I need to manually add a few rows to this table. 
Manually copying one users row, then editing it, would be easier than
starting from scratch.

Hiltibidal, Robert wrote:
> What are you trying to accomplish?
>
> The more normalized a database is the faster it operates, the more
> efficient it will be. What you are describing creates a lot of in
> efficiencies within a database.
>   


pgsql-sql by date:

Previous
From: "Chad Wagner"
Date:
Subject: Re: question on passing parameter in sql query
Next
From: Bryce Nesbitt
Date:
Subject: Re: Seeking quick way to clone a row, but give it a new pk.