Fwd: Creating Partition in existing Table using postgreSQL11
---------- Forwarded message ---------
From: Jonathan S. Katz <jkatz@postgresql.org>
Date: Fri, Nov 2, 2018 at 7:33 PM
Subject: Re: Creating Partition in existing Table using postgreSQL11
To: Maheswaran R <rmaheswaranmca@gmail.com>, <webmaster@postgresql.org>
Hi,
This email address is for reporting issues related to the PostgreSQL
website. For places to ask general support questions, please refer to:
https://www.postgresql.org/support/
Thanks,
Jonathan
On 11/2/18 1:34 AM, Maheswaran R wrote:
Dear Sir/madam,
I want to create partition on existing table, is it possible to create a
partition on existing tables in postgreSQL 11?
if so please give a sample script/syntax.--
Ragards
Maheswaran R
Krishnagiri*Love India,**Save India and Serve to Indian*
--
Ragards
Maheswaran R
Krishnagiri
*Love India,** Save India and Serve to Indian*
Attachments:
signature.asctext/plain; charset=US-ASCII; name=signature.ascDownload
Import Notes
Reply to msg id not found: e248286d-a00a-bc4e-90dc-646719833bc7@postgresql.orgReference msg id not found: CAMfCLzP6HEfR53_c6rU8UfbP2zrYRk9c=6xrHWcq2cYw4x54XA@mail.gmail.comReference msg id not found: e248286d-a00a-bc4e-90dc-646719833bc7@postgresql.org
Hi,
On 11/2/18 1:34 AM, Maheswaran R wrote:
Dear Sir/madam,
I want to create partition on existing table, is it possible to create a
partition on existing tables in postgreSQL 11?
if so please give a sample script/syntax.
You can create a partition on an existing table only if the existing table
is defined as a partitioned table, like this:
create table existing_table_name (...) partition by ....
Read more about how to create partitioned tables and their partitions at
the following documentation of CREATE TABLE:
https://www.postgresql.org/docs/11/sql-createtable.html
By the way, this is not a bug, so pgsql-bugs@... is not the list to ask
this. Next time, please send emails with such questions to
pgsql-general@lists.postgresql.org. Also, read about which mailing lists
to use in different situations by reading their descriptions here:
https://www.postgresql.org/list/
Thanks,
Amit