Maximum field in a table

Started by G.Elangovanover 27 years ago4 messagesgeneral
Jump to latest
#1G.Elangovan
elangog@wipinfo.soft.net

I want to Create and handle table , this table has provision to get new
fields added and removed existing field
My doubt is what is the maximum field (column ) a table can have, i need
the answere because my table dynamically increases with coloumn
Also tell me what is the maximum record a table can have
Thanku

#2Cho Yan Wong
pwong@pobox.leidenuniv.nl
In reply to: G.Elangovan (#1)
copy probs

Greetings,

What's an easy way to convert a paradox database to pgsql? I have an
ascii dump of the database which I modified for the copy command. I've tried
"copy Employee from '/mydir/somewhere/db.asc' using delimiters ';';"
Everything seems to work fine except my dates are messed up. Instead of
05-19-1877 I get 05-19-31284. Actually I get 31284 or 32766 for every year.
Help?

Tempest

http://www.wi.leidenuniv.nl/~cwong/games
http://www.planetquake.com/infinity

#3Jose David Martinez Cuevas
david@morgana.estadistica.unam.mx
In reply to: Cho Yan Wong (#2)
Re: [SQL] copy probs

On Tue, 25 Aug 1998, Cho Yan Wong wrote:

Everything seems to work fine except my dates are messed up. Instead of
05-19-1877 I get 05-19-31284. Actually I get 31284 or 32766 for every year.
Help?

Well, I don't know too much about Paradox.

About dates, there is only one thing I can say. If you use a format like
"yyyy-mm-dd" I'm sure your date fields won't fail. I would
recommend you to modify your ASCII files in order to have the date's in
such format.

Buena Suerte Amigo !!

_______________________________________
David Martinez Cuevas
Direccion General de Estadistica, UNAM - Mexico
Tel. 622-60-80
E-mail david@estadistica.unam.mx
----------------------------------------

#4Cho Yan Wong
pwong@pobox.leidenuniv.nl
In reply to: Jose David Martinez Cuevas (#3)
Re: [SQL] copy probs

At 10:22 8/25/98 -0500, Jose David Martinez Cuevas wrote:

On Tue, 25 Aug 1998, Cho Yan Wong wrote:

Everything seems to work fine except my dates are messed up. Instead of
05-19-1877 I get 05-19-31284. Actually I get 31284 or 32766 for every year.
Help?

Well, I don't know too much about Paradox.

About dates, there is only one thing I can say. If you use a format like
"yyyy-mm-dd" I'm sure your date fields won't fail. I would
recommend you to modify your ASCII files in order to have the date's in
such format.

The current format is "dd-mm-yyyy". At least, it complains when I try to
insert the values in any other way. Can anybody still help out? I'm miffed
by it completely.

Tempest

http://www.planetquake.com/infinity
http://www.wi.leidenuniv.nl/~cwong/games