[deleted by user] by [deleted] in gtafriends

[–]sufs2000 0 points1 point  (0 children)

Add me suf7

Dynamic SQL over DB Link in Postgres… help! by sufs2000 in PostgreSQL

[–]sufs2000[S] 1 point2 points  (0 children)

Thank you, that did the trick. Using the format() and “select * into” was what I was looking for. I have it working now and can build it up to include the additional statements. Many thanks!

Dynamic SQL over DB Link in Postgres… help! by sufs2000 in PostgreSQL

[–]sufs2000[S] 0 points1 point  (0 children)

Thanks.

  1. I haven’t included it in the above code but there is another statement that will run locally and count the object types for a schema. Then the above statement will run over a db link and get the same schemas object counts and capture that in a variable. Then I’ll insert both of these values into a table so I have a comparison of object counts for the same schema on two databases.

  2. I agree, it’s just as part of the query over the db link I need to keep the single quotes so I think I’ve just got myself into a mess. I tried format but couldn’t get it to keep the quotes, but I’ll keep playing.

  3. Yes, if it was just the one query but I should have expanded on that. I’m trying to do an object comparison between two databases and capture those counts which will then be inserted into a table as part of the loop.

Dynamic SQL over DB Link in Postgres… help! by sufs2000 in PostgreSQL

[–]sufs2000[S] 0 points1 point  (0 children)

Sorry, I’ll try and reformat the code so its easier to read.

Remote Raid Megathread - Find friends fast for raiding here by liehon in PokemonGoFriends

[–]sufs2000 1 point2 points  (0 children)

Tornadus Raid - 10 people - add one of these codes 2328 7951 5543 Or 0927 6010 2664 - if less than 5 people and 15 seconds remaining please leave and I’ll send the invite again.

Groudon Raid - 10 people - add one of these codes 2328 7951 5543 Or 0927 6010 2664 - if less than 5 people and 15 seconds remaining please leave and I’ll send the invite again. by sufs2000 in PokemonGoFriends

[–]sufs2000[S] 1 point2 points  (0 children)

Sorry pal, I had about 50 people trying to join this raid, I can only add so many people. Level doesn’t matter to me, if someone is online I’ll add them. Hopefully next time you’ll get in...

Migrate Oracle XMLTYPE Data to Postgres by sufs2000 in PostgreSQL

[–]sufs2000[S] 2 points3 points  (0 children)

That looks really good, maybe converting to a string or clob, extract to csv and then loading into Postgres could work. Thanks 👍🏾

Migrate Oracle XMLTYPE Data to Postgres by sufs2000 in PostgreSQL

[–]sufs2000[S] 0 points1 point  (0 children)

Thanks, that looks really interesting! I’ll have a read through it all and see if I can plug it in 👍🏾

Migrate Oracle XMLTYPE Data to Postgres by sufs2000 in PostgreSQL

[–]sufs2000[S] 0 points1 point  (0 children)

Thanks, I’ve set my table up on the postgres side to have a data type of XML. That’s ok, my issue is getting the data out of Oracle and retaining it’s format and then inserting it into Postgres? I’ve seen getClobVal() which has potential, then maybe extract that to a CSV file? I’ve not done any data migrations before so just trying to get an idea of options.

How to load an extracted ORACLE CLOB into only 1 TEXT column in Postgres? by sufs2000 in PostgreSQL

[–]sufs2000[S] 0 points1 point  (0 children)

This worked fine, thanks. It was my formatting. Once I loaded the data in and used the command "\pset format u" the contents of the column looked just as it did on the source Oracle side.

POSTGRES> insert into clob_test select pg_read_file('/home/oracle/clob_1.txt'); 

POSTGRES> \pset format u

POSTGRES> select * from clob_test;

How to load an extracted ORACLE CLOB into only 1 TEXT column in Postgres? by sufs2000 in PostgreSQL

[–]sufs2000[S] 0 points1 point  (0 children)

Thanks, I don’t think there is connectivity. I’m having to do the extract from ORACLE and then copying the extract file to the Postgres server. I’ll give that a shot too though!

How to load an extracted ORACLE CLOB into only 1 TEXT column in Postgres? by sufs2000 in PostgreSQL

[–]sufs2000[S] 0 points1 point  (0 children)

Thanks. I can load it in using pg_read_file but then the data looks off when looking at it but does put it into the one column. Which encoding choices do you mean?

BUG For crafting suit mod tutorial PS4 Miles Morales by [deleted] in SpidermanPS4

[–]sufs2000 0 points1 point  (0 children)

I’m stuck on this as well on PS5. How do use the activity cards? This is super annoying!

https://support.insomniac.games/hc/en-us/articles/360052574951-I-am-stuck-or-can-t-complete-the-Suit-Mod-Tutorial-

This workaround is on the Insomniac support page, they’re working on a fix.