Обсуждение: Maximum field in a table

Поиск
Список
Период
Сортировка

Maximum field in a table

От
"G.Elangovan "
Дата:
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



copy probs

От
Cho Yan Wong
Дата:
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


Re: [SQL] copy probs

От
Jose David Martinez Cuevas
Дата:

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
----------------------------------------







Re: [SQL] copy probs

От
Cho Yan Wong
Дата:
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