Postgres Pro
Downloads
Home   >   mailing lists

Thread: Change varchar lenght

Change varchar lenght

From
Eduardo
Date:
 How can I change a field that is varchar(50) to varchar(500) ??
 I did not find in docs. And did not find that option in pgaccess .

 Thanks,
     Eduardo K

RE: Change varchar lenght

From
"Sykora, Dale"
Date:
Eduardo,

Since you are changing the table definition, I would do the following.
1. Make a temp table "identical to the original table1 except for the larger
varchar size."
2. Copy table1 to the temp table.
3. Drop table1.
4. Create new table1 identical to temp table.
5. Copy temp table to table1.
6. Drop temp table.

I am a fairly new user, so there may be a better way to do this.

Good Luck,
dale.sykora@compaq.com


-----Original Message-----
From: Eduardo [mailto:ekotuja@brasilnet.net]
Sent: Monday, September 11, 2000 3:17 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Change varchar lenght


 How can I change a field that is varchar(50) to varchar(500) ??
 I did not find in docs. And did not find that option in pgaccess .

 Thanks,
     Eduardo K

RE: Change varchar lenght

From
"Sokel, John"
Date:

I don't believe you can change the size of a column once it's created.  The best way is to recreate it.  Take a look at SELECT INTO for creating a backup table easily.  Then recreate the original table and INSERT INTO <original> SELECT * FROM <temp>.  Should be fairly painless.

-----Original Message-----
From: Eduardo [mailto:ekotuja@brasilnet.net]
Sent: Monday, September 11, 2000 3:17 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Change varchar lenght

 How can I change a field that is varchar(50) to varchar(500) ??
 I did not find in docs. And did not find that option in pgaccess .

 Thanks,
     Eduardo K

windows ODBC driver for PG7.02

From
igor
Date:
Hi!

  Tell me please, is windows ODBC driver sutable for
connecting to PG 7.02? I have downloaded the last availible
release, but in "Advanced options" I can see only
selection of protocol 6.5-6.4.
Connecting with this driver I'm unable to access to database
with "Password authentication failed for user..." error.

 I'm running postmaster with -i option, and also I can
access to database with the help of psql.

 What is wrong??

 Thanks for any ideas!!

 Igor.

Re: windows ODBC driver for PG7.02

From
Vic
Date:
igor пишет:

> Hi!
>
>   Tell me please, is windows ODBC driver sutable for
> connecting to PG 7.02? I have downloaded the last availible
> release, but in "Advanced options" I can see only
> selection of protocol 6.5-6.4.

I  work   with  PG 7.0  and  drv  v06-40-0005 without  big  problems -
client on Delphi  and  Visual Foxpro.

>
> Connecting with this driver I'm unable to access to database
> with "Password authentication failed for user..." error.
>
>  I'm running postmaster with -i option, and also I can
> access to database with the help of psql.
>
>  What is wrong??
>
>  Thanks for any ideas!!
>
>  Igor.

See file  "/usr/local/pgsql/data/pg_hba.conf"
All rules for  access  from remote hosts a in  this!
And   Login  as postgress  and  after createuser  run  this
"pg_passwd $PGDATA/passwd" - its create  password  for your  users!
Simple Howto intall/use M$ - Postgres ODBC
http://t37.nevod.perm.su/linux/documents/postgresql/windows.html
Read Doc!
If  your  Delphi or CBuidlder Programmer  -
I strongly recomendate Zeos Database Objects- it dont use  BDE or ODBC -

and its  work nicely( but  have  some   ).
htttp://www.zeos.dn.ua