pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Drop Not Null
5+ messages / 4 participants
[nested] [flat]

* Drop Not Null
@ 2007-10-18 06:01  yogesh <yogesh.arora.daffodil@gmail.com>
  0 siblings, 3 replies; 5+ messages in thread

From: yogesh @ 2007-10-18 06:01 UTC (permalink / raw)
  To: pgsql-admin

Hello Frnds,
 What is the Command to drop the  Not Null  Constraint from a Column
of the Table.....Please reply asap.............

Regards,
 Yogesh Arora.




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Drop Not Null
@ 2007-10-18 14:01  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  parent: yogesh <yogesh.arora.daffodil@gmail.com>
  2 siblings, 0 replies; 5+ messages in thread

From: Kevin Grittner @ 2007-10-18 14:01 UTC (permalink / raw)
  To: yogesh <yogesh.arora.daffodil@gmail.com>; pgsql-admin

>>> On Thu, Oct 18, 2007 at  1:01 AM, in message
<1192687310.749557.227290@q5g2000prf.googlegroups.com>, yogesh
<yogesh.arora.daffodil@gmail.com> wrote: 
>  What is the Command to drop the  Not Null  Constraint from a Column
 
http://www.postgresql.org/docs/8.2/interactive/sql-altertable.html
 





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Drop Not Null
@ 2007-10-18 23:20  Alex Kloss <alexkloss@att.net>
  parent: yogesh <yogesh.arora.daffodil@gmail.com>
  2 siblings, 1 reply; 5+ messages in thread

From: Alex Kloss @ 2007-10-18 23:20 UTC (permalink / raw)
  To: yogesh <yogesh.arora.daffodil@gmail.com>; pgsql-admin

yogesh wrote:
> Hello Frnds,
>  What is the Command to drop the  Not Null  Constraint from a Column
> of the Table.....Please reply asap.............
>
> Regards,
>  Yogesh Arora.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
>   
ALTER TABLE table ALTER COLUMN column DROP NOT NULL

See http://www.postgresql.org/docs/8.2/interactive/ddl-alter.html#AEN2311
for more information about dropping constraints.

Alex Kloss

Attachments:

  signature.asc (application/pgp-signature, 188B) download

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Drop Not Null
@ 2007-10-19 05:09  Ashish Karalkar <ashish.karalkar@info-spectrum.com>
  parent: yogesh <yogesh.arora.daffodil@gmail.com>
  2 siblings, 0 replies; 5+ messages in thread

From: Ashish Karalkar @ 2007-10-19 05:09 UTC (permalink / raw)
  To: yogesh <yogesh.arora.daffodil@gmail.com>; pgsql-admin

alter table table_name alter column column_name drop not null;
----- Original Message ----- 
From: "yogesh" <yogesh.arora.daffodil@gmail.com>
To: <pgsql-admin@postgresql.org>
Sent: Thursday, October 18, 2007 11:31 AM
Subject: [ADMIN] Drop Not Null


> Hello Frnds,
> What is the Command to drop the  Not Null  Constraint from a Column
> of the Table.....Please reply asap.............
> 
> Regards,
> Yogesh Arora.
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Drop Not Null
@ 2007-10-19 05:39  yogesh <yogesh.arora.daffodil@gmail.com>
  parent: Alex Kloss <alexkloss@att.net>
  0 siblings, 0 replies; 5+ messages in thread

From: yogesh @ 2007-10-19 05:39 UTC (permalink / raw)
  To: pgsql-admin

On Oct 19, 4:20 am, alexkl...@att.net (Alex Kloss) wrote:
> yogesh wrote:
> > Hello Frnds,
> >  What is the Command to drop the  Not Null  Constraint from a Column
> > of the Table.....Please reply asap.............
>
> > Regards,
> >  Yogesh Arora.
>
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: Don't 'kill -9' the postmaster
>
> ALTER TABLE table ALTER COLUMN column DROP NOT NULL
>
> Seehttp://www.postgresql.org/docs/8.2/interactive/ddl-alter.html#AEN2311
> for more information about dropping constraints.
>
> Alex Kloss
>
>  signature.asc
> 1KDownload

Thx for your Support




^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2007-10-19 05:39 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-10-18 06:01 Drop Not Null yogesh <yogesh.arora.daffodil@gmail.com>
2007-10-18 14:01 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2007-10-18 23:20 ` Alex Kloss <alexkloss@att.net>
2007-10-19 05:39   ` yogesh <yogesh.arora.daffodil@gmail.com>
2007-10-19 05:09 ` Ashish Karalkar <ashish.karalkar@info-spectrum.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox