Skip to main content
Question

Has anyone tried to write to an In-Memory table such as a PostGIS temporary table?


Has anyone tried to write to an In-Memory table such as a PostGIS temporary table?

2 replies

mark2atsafe
Safer
Forum|alt.badge.img+44
  • Safer
  • October 18, 2019

For what it's worth, I've tried this in a SQLExecutor transformer before, like...

FME_SQL_DELIMITER ;
DROP TABLE imark_temp_table;
CREATE TEMPORARY TABLE imark_temp_table (a varchar(100),b varchar(100));
INSERT INTO imark_temp_table (a,b) values ('xxxx','yyyy');
SELECT COUNT(*) AS FeatureCount FROM imark_temp_table;

But it only exists during that SQLExecutor. If I tack another SQLExecutor on afterwards and repeat the SELECT COUNT(*) command, it tells me imark_temp_table doesn't exist.

So I guess it works, but I'd say the uses are fairly limited.


  • Author
  • October 28, 2019

I gathered that postgresql temporary tables are created in the buffer. So, I wonder whether the use of temporary tables can help speed up the process.

 

Any clue?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings