Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to convert Centura Long String into PostgreSQL Text
I use ODBC and PostgreSQL 7.2. on Win2000 with the cygwin environment. Centura Team Developer is a very comfortable IDE with native database support for many backends. And those which are not supported native, can be accessed via ODBC.- gregitg
- Post #3
- Forum: PostgreSQL Inc.: PostgreSQL
-
How to convert Centura Long String into PostgreSQL Text
Hi to all, I experienced a problem when inserting/updating a PostgreSQL table out from Centura Team Developer. The variable in Centura is defined as Long String and the correspnodent column in the database is defined as text or varchar(). The result is the same. The database sends an error...- gregitg
- Thread
- Replies: 3
- Forum: PostgreSQL Inc.: PostgreSQL
-
How to get the precision and scale part of a decimal
Hi to everybody, has somebody an idea how get the precision and scale part of a decimal/numeric datatype? What I found out is: Both are encoded in the column atttypmod in the table pg_attribute. The column contains a value e.g. 983046 what stands for a decimal(15,2) (this I know accidantly)...- gregitg
- Thread
- Replies: 0
- Forum: PostgreSQL Inc.: PostgreSQL
