RE: Removing all NOT NULL constraints from multiple tabl es easily

From: patrick(dot)wolf(at)Aerojet(dot)com (WOLF, PATRICK)
To: "'Sokel, John'" <jsokel(at)mdsi-usa(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: RE: Removing all NOT NULL constraints from multiple tabl es easily
Date: 2000-09-11 15:13:29
Message-ID: 63A19D0F08E6D211AD740008C7B1C47B02FE1697@APD-MAIL1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Or, do

pg_dump -s -t tablename

will output the schema for tablename

> -----Original Message-----
> From: Sokel, John [SMTP:jsokel(at)mdsi-usa(dot)com]
> Sent: Monday, September 11, 2000 8:04 AM
> To: pgsql-novice(at)postgresql(dot)org
> Cc: Dan Browning
> Subject: RE: [NOVICE] Removing all NOT NULL constraints from multiple
> tabl es easily
>
> If you do a pg_dump on the db, the first part of the data will be the
> create script. Just pull that part of the file off and alter it.
>
> John
>
> -----Original Message-----
> From: Dan Browning [mailto:danb(at)cyclonecomputers(dot)com]
> Sent: Monday, September 11, 2000 8:58 AM
> To: 'Sokel, John'; pgsql-novice(at)postgresql(dot)org
> Subject: RE: [NOVICE] Removing all NOT NULL constraints from multiple
> tables easily
>
>
> Does anyone have a program (or psql command?) that will analyze a table
> and generate a CREATE TABLE ... statement? I ask because I don't have the
> create table statements handy, and it would take a while for me to
> recreate them (plus spelling errors, etc.)
>
> -----Original Message-----
> From: Sokel, John [mailto:jsokel(at)mdsi-usa(dot)com]
> Sent: Monday, September 11, 2000 6:57 AM
> To: Dan Browning
> Subject: RE: [NOVICE] Removing all NOT NULL constraints from
> multiple tables easily
>
>
>
> I don't think you can alter that on the fly, but an easier way is
> too just use 'select into' a temporrary table, recreate, and insert the
> data back to the original file. That's what I always do, usually pretty
> quick (unless you have gobs of data).
>
> ** Create a temporrary table
> Select * into <temp_table> from <orig_table>;
>
> ** Recreate the file
> Drop table <orig_table>;
> Create table <orig_table> ...;
>
> ** Put the data back in
> Insert into <orig_table> select * from <temp_table>;
>
> ** Clean up
> Drop table <temp_table>;
>
> -----Original Message-----
> From: Dan Browning [ <mailto:danb(at)cyclonecomputers(dot)com>]
> Sent: Monday, September 11, 2000 8:32 AM
> To: pgsql-general(at)postgresql(dot)org; pgsql-novice(at)postgresql(dot)org
> Subject: [NOVICE] Removing all NOT NULL constraints from multiple
> tables
> easily
>
>
> I would like to remove all NOT NULL constraints from my tables.
>
> I've tried ALTER TABLE, but I can't seem to get the syntax right,
> and the
> docs aren't clear to me.
> What is the correct syntax? If there's another way, short of
> manually
> recreating (dump, create, import) the tables, I'd love to hear it.
>
> Thanks,
>
> Dan Browning
> Network & Database Administrator
> Cyclone Computer Systems
>

Browse pgsql-novice by date

  From Date Subject
Next Message Stephan Szabo 2000-09-11 16:37:42 Re: Removing all NOT NULL constraints from multiple tables easily
Previous Message The Hermit Hacker 2000-09-11 14:53:31 RE: cat infile | translate all occurences of "NOT NULL" to ""