Tutorial 19-PostgreSQL Temp table
In this session we are going to discuss table management (Temp table) in postgresql
What is temp table?
The table is temporary
Temporary table stores the content specific to the session
it will available duration of this session
if the session established this table cant be used by other session
it would be stored in temporary tablespace
ex:Temp_tbs
what is the use?
it will be used for report, migration activities
to check temp tablespaces
show temp_tablespaces;
to view the physical location
select spcname,pg_tablespace_location(oid) from pg_tablespace;
to view the temp tables
select schemaname,tablename,tableowner,tablespace from pg_tables where
tablename in ('ocdr','ocpr','ocdrp');
Types of temp tables
Note: by default autocommit is on we are disable it for this below
demo
1. on commit delete rows - structure will be there rows will be
deleted
create temp table ocdr (no int) on commit delete rows
tablespace temp_tbs;
2.on commit preserve rows - structure and rows will be there after
commit
create temp table ocpr (no int) on commit preserve rows
tablespace temp_tbs;
3.on commit drop - structrue and rows drop
create temp table drop (no int) on commit drop
tablespace temp_tbs;
subscribe to our channel:
-----------------------------------------
https://rebrand.ly/8z3l1y1
For doubts and queries kindly contact us on
-----------------------------------------------------------------------
mynotesdba@gmail.com
Follow us:
www.facebook.com/MyNotesOracleDba
#temptable #tablemanagement #typesoftemptables
Auf dieser Seite können Sie das Online-Video Tutorial 19-PostgreSQL Temp table mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer mynotesoracledba 15 Juni 2020 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 4,592 Mal angesehen und es wurde von 15 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
