Re: [PHP3] alter table

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 &nbsp;tb_guest &nbsp;(<br>
> >&nbsp;&nbsp;&nbsp;date &nbsp;&nbsp;&nbsp;&nbsp;varchar(8)
> >&nbsp;&nbsp;&nbsp;&nbsp;not null,<br> &nbsp;&nbsp;&nbsp;time
> >&nbsp;&nbsp;&nbsp;&nbsp;varchar(6) &nbsp;&nbsp;&nbsp;&nbsp;not null,<br>
> >&nbsp;&nbsp;&nbsp;name &nbsp;&nbsp;&nbsp;&nbsp;varchar(20) not null,<br>
> >&nbsp;&nbsp;&nbsp;url &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;varchar(25),<br>
> >&nbsp;&nbsp;&nbsp;ip
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;varchar(15),<br>
> >&nbsp;&nbsp;&nbsp;browser &nbsp;varchar(50),<br> &nbsp;&nbsp;&nbsp;email
> >&nbsp;&nbsp;&nbsp;varchar(40),<br> &nbsp;&nbsp;&nbsp;home
> >&nbsp;&nbsp;&nbsp;&nbsp;varchar(50),<br> &nbsp;&nbsp;&nbsp;content
> >&nbsp;varchar(2000)<br>); <br><br>I want to modify &quot; home
varchar(50)
> >&quot; -&gt; &quot;home varchar(80)&quot;.<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
>

Browse pgsql-general by date

  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?