From: | ÃÖÁø¹é <webmaster(at)dbinfo(dot)co(dot)kr> |
---|---|
To: | "Richard Lynch" <lynch(at)cognitivearts(dot)com> |
Cc: | <php3(at)lists(dot)php(dot)net>, <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [PHP3] alter table |
Date: | 1999-06-12 04:54:44 |
Message-ID: | 99061213574195700@nt001 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi.
Thank you for your help.
I used this method
create table cp_guest as
select * from tb_guest;
after drop tb_guest table.
and modify and run this sql.
insert into tb_guest
select * from cp_guest;
Thank you from your help ...
----------
> º¸³½ »ç¶÷: Richard Lynch <lynch(at)cognitivearts(dot)com>
> ¹Þ´Â »ç¶÷: ÃÖÁø¹é <webmaster(at)dbinfo(dot)co(dot)kr>
> Á¦¸ñ: Re: [PHP3] alter table
> ³¯Â¥: 1999³â 6¿ù 12ÀÏ Åä¿äÀÏ ¿ÀÈÄ 12:43
>
> You will need to create a new temp table, copy everything into it, drop
the
> old one, and rename the new one.
>
> See www.postgresql.org website for precise details.
>
> A search for "alter table" should come up with an example.
>
> >$)CI am sorry. I use the postgreSQL database.
> >----------------------------------------------------------------
> >
> >hi all, I have a problem that is I want to modify ( alter ) this
tb_guest
> >table.
> >
> >create table tb_guest (
> > date varchar(8) not null,
> > time varchar(6) not null,
> > name varchar(20) not null,
> > url varchar(25),
> > ip varchar(15),
> > browser varchar(50),
> > email varchar(40),
> > home varchar(50),
> > content varchar(2000)
> >);
> >
> >I want to modify " home varchar(50) " -> "home varchar(80)".
> >Help me, please, solve this problem!
> >Thanks.
> >
> >With Best Regards,
> >CHOI JINBAEK.
> >
> >
> >$)C<html><head></head><BODY bgcolor="#FFFFFF"><p><font size=2
> >color="#000000" face="1<82">I am sorry. I use the postgreSQL
>
>database.<br>--------------------------------------------------------------
> >--<br><br>hi all, I have a problem that is I want to modify ( alter )
this
> >tb_guest table.<br><br>create table tb_guest (<br>
> > date varchar(8)
> > not null,<br> time
> > varchar(6) not null,<br>
> > name varchar(20) not null,<br>
> > url varchar(25),<br>
> > ip
varchar(15),<br>
> > browser varchar(50),<br> email
> > varchar(40),<br> home
> > varchar(50),<br> content
> > varchar(2000)<br>); <br><br>I want to modify " home
varchar(50)
> >" -> "home varchar(80)".<br>Help me, please, solve
this
> >problem!<br>Thanks.<br><br>With Best Regards, <br>CHOI
> >JINBAEK.<br><br><br></p>
> ></font></body></html>
>
> -- "TANSTAAFL" Rich lynch(at)cognitivearts(dot)com webmaster@ and www. all
of:
> R&B/jazz/blues/rock - jademaze.com music industry org -
chatmusic.com
> acoustic/funk/world-beat - astrakelly.com sculptures -
olivierledoux.com
> my own nascent company - l-i-e.com cool coffeehouse -
uncommonground.com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Alexander | 1999-06-12 05:22:36 | Newbie disturbed about lack of CASE tools for PostgreSQL |
Previous Message | dustin sallings | 1999-06-12 04:04:05 | Re: [GENERAL] code making rule? |