Solved

PostgreSQL Varchar datatype?

Posted on 2007-04-09
4
6,725 Views
Last Modified: 2008-01-09
Hey!

Just started using PostgreSQL, use to MS SQL Server. Noticed Postgre does not have a varchar table datatype.

Tried using a character[] thinking a varchar is simply a character array, though when trying to execute an insert or update on the table it's asking for {} brackets...

Please comment in detail!

Thanks :)
0
Comment
Question by:undyshelts
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 23

Expert Comment

by:Christopher Kile
ID: 18876270
It might be a better idea to post this in the PostGres or Miscellaneous section, as I doubt the average SQL Server programmer will know this stuff.  Have you tried searching the PostGres site?  http://www.postgresql.org/
0
 
LVL 62

Accepted Solution

by:
gheist earned 50 total points
ID: 18876330
http://www.postgresql.org/docs/8.2/interactive/datatype-character.html

Do you have problems with disk space that you want to use unaligned varchar sacrificing speed?
0
 
LVL 1

Author Comment

by:undyshelts
ID: 18879502
Gheist, thanks for sparking my memory!

I think you might have been over complicating the question, I was looking for the equivilant to varchar in PostgreSQL, which I have discovered is Character Varying.
0
 
LVL 62

Expert Comment

by:gheist
ID: 18881747
Whic in turn can be abberviated as "varchar"
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question