Free AI web copilot to create summaries, insights and extended knowledge, download it at here

Abstract

Tablespace in PostgreSQL</figcaption></figure>Types of tablespaces:<ul><li>1.Default tablespace</li><li>when we are creating DB without specifying tablespace location by default objects are stored into pg_default 1.pg_default → all the user related objects are stored here 2.pg_global → all the system related objetcs are stored here</li><li>2. Non-Default tablespace The DB objects are stored into specific location/directory Which was defined by user.</li></ul>What are the advantages of using non-default tablespace?1.logically maintaining the objects on specific directory 2.better I/O retention 3.Maintenance activities (like to take backup specific volume backup)To define a tablespace<div id="c707"><pre>CREATE TABLESPACE tbspace1 LOCATION '/u01/postgresql/data';</pre></div>Note:<ul><li>The

Options

location must be an existing, empty directory that is owned by the PostgreSQL operating system user. All objects subsequently created within the tablespace will be stored in files underneath this directory.</li><li>Creation of the tablespace itself must be done as a database superuser, but after that you can allow ordinary database users to use it</li></ul>To create DB with tablespace:<div id="31c2"><pre>CREATE DATABASE Sports TABLESPACE tbspace1;</pre></div>To view the tablespace:<ul><li>Here this system catalog to view the existing tablespace .</li></ul><div id="8592"><pre>SELECT * FROM pg_tablespace;</pre></div>List Command To View Tablespace:<ul><li>The below meta-command is also useful for listing the existing tablespaces.</li></ul><div id="5abd"><pre>\db</pre></div></article></body>

Dr Michael Heng PBM — A Top 50 Global Thought Leader & Influencer on CSR 2022

Ranking at #14

Based on Thinkers360’s patent-pending holistic measure of thought leadership and authentic influence looking far beyond social media alone, Dr Michael Heng PBM has been selected as a Top 50 Global Thought Leader and Influencer on CSR (corporate social responsibility) 2022.

Top 50 Global Thought Leaders and Influencers on CSR 2022

Thinkers360 Leaderboard Sponsored by the Carbon Negative Alliance Find and work with the World's Premier B2B Thought…

www.thinkers360.com

Screen captured from Youtube by www.thinkers360.com

Dr Michael Heng PBM created a renewable energy value integrator company with a sustainability theme. In response to the inconvenient truth of global climatic implosion, Energycorp Global was created from the vision of a brave new world with an abundant energy future where one and all would have access to the clean and limitless natural powers around us.

We embrace a natural partnership with the environment to bridge the nexus between sustainability and profitability to make them our twin business goals. We encourage new value innovations to harness renewable natural energy and deploy technologies in clean, cost-effective alternative energy methods.

In 2019, he was conferred the Earth Care Award for Sustainability Leadership in a climate-friendly business enterprise.

2019 EARTH CARE AWARD for MICHAEL HENG

Full Citation Dr Michael Heng Swee-Hai Dr Michael Heng puts sustainability at the heart of his business. He envisions a…

www.linkedin.com

He was conferred the CSR Leadership Award 2012 on World CSR Day 2012 in recognition of his contributions which have made a difference to people and the community. He also received a Global CSR Leadership Award at the Global CSR Summit 2012. And at the Philip Kotler World Marketing Summit 2013, he received the CSR Leadership Excellence Award. He was an Advisor to World CSR Congress from 2014–2017.

On National Day 2002, Dr Michael was recognised on the National Day 2002 Honours List and awarded the Public Service Medal (PBM) for community service by the President of Singapore.

Dr Michael Heng PBM is recognized as an influential thought-leader, thinker and writer on human capital, venture creation, business strategy, politics, sustainability and CSR.

Thinkers360 is the largest and premier marketplace for B2B thought leaders and influencers with the world’s foremost experts on cutting-edge business, technology, and sustainability topics.

Please enjoy my recent Articles.

You can also subscribe to my stories and social media posts via your email. Enjoy more interesting Articles by signing up to Medium here:

Join Medium with my referral link - Dr Michael Heng

Read every story from Dr Michael Heng (and thousands of other writers on Medium). Your membership fee directly supports…

thefuturistoracle.medium.com

Please become a Medium Member to directly support me and other writers you read. You’ll also get full access to every story on Medium. You can also receive an email whenever I publish a story on Medium.