Re: Creating Primary Key after CREATE TABLE: Is Sequence created?

From: Monosij <monosij(dot)forums(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Creating Primary Key after CREATE TABLE: Is Sequence created?
Date: 2013-09-27 20:16:52
Message-ID: 1380313012323-5772651.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ok I understand about not programming to LCD.

I just initially wanted to play around with creating tables / indexes / fks
and import some data before moving to next steps.

I did want to have some control over namimg conventions.

For eg. with creating PK id and sequence with 1 statement as:
id serial primary key
I have a vague idea how the primary key and sequence was named but no
control on it.

However if I could control the naming convention from here I would be ok
with it.

Would there be a way to control the naming of the id and sequence from the
create table statement?

Thank you.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Creating-Primary-Key-after-CREATE-TABLE-Is-Sequence-created-tp5772633p5772651.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-09-27 20:26:52 Re: Creating Primary Key after CREATE TABLE: Is Sequence created?
Previous Message Monosij 2013-09-27 20:09:08 Re: Creating Primary Key after CREATE TABLE: Is Sequence created?