Insert string as row in Postgresql

Question

I have some strings in an audit table that describe an entire row that was deleted. Ie, they look like:

'(029e99b4-6ea2-46e4-a89d-91d96aff41c4/4/5b,029e99b4-6ea2-46e4-a89d-91d96aff41c4,029e99b4-6ea2-46e4-a89d-91d96aff41c4,M4,short_rainy,54,Coffee,1,,2,,,2015-11-09,2,,,,,2,,)'

They were creating using the ROW() function in the useful script described here.

Now, I want to insert them into the table they came from. It still has the same schema, so each column in the string should correspond to the correct column in the table. How can I do that?

My apologies if this has been asked already - I looked around and only found this question, which doesn't seem workable in my case because I have so many columns.

Thanks

Clodoaldo Neto · Accepted Answer · 2017-04-03 17:36:13Z

1

Cast it to the table type before inserting:

insert into t
values
    ((
        029e99b4-6ea2-46e4-a89d-91d96aff41c4/4/5b,
        029e99b4-6ea2-46e4-a89d-91d96aff41c4,
        029e99b4-6ea2-46e4-a89d-91d96aff41c4,
        M4,short_rainy,54,Coffee,1,,2,,,2015-11-09,2,,,,,2,,
    )::t)

answered Apr 3, 2017 at 17:36

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert string as row in Postgresql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related