Re: Tablespace with multiple locations

2023-01-03 Thread Peter Eisentraut
On 29.12.22 15:29, PG Doc comments form wrote: I m kindly requesting a clarification regarding a debatable subject in one of my projects, that if it's possible to create one global tablespace and assign many locations like the following example: create tablespace TBS1 location (

Tablespace with multiple locations

2022-12-30 Thread PG Doc comments form
lobal tablespace and assign many locations like the following example: create tablespace TBS1 location ('/pgdata1','/pgdata2'); Which will be helpful on database migration, once the new database to be restored needs further available space than the created tablespace ( if the

Re: TABLESPACE

2022-09-05 Thread Nicolas Shiacolas
bsite: >> >> Page: https://www.postgresql.org/docs/14/sql-createtablespace.html >> Description: >> >> When exporting a table create script pgAdmin includes a command >> "TABLESPACE >> pg_default;" such as below >> >> CREATE TABLE IF NOT E

Re: TABLESPACE

2022-09-04 Thread Guillaume Lelarge
Le dim. 4 sept. 2022, 10:19, PG Doc comments form a écrit : > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/sql-createtablespace.html > Description: > > When exporting a table create script pgAdmin includes a c

TABLESPACE

2022-09-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-createtablespace.html Description: When exporting a table create script pgAdmin includes a command "TABLESPACE pg_default;" such as below CREATE TABLE IF NOT EXISTS &quo