pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedData types and binary data
4+ messages / 4 participants
[nested] [flat]
* Data types and binary data
@ 1998-08-20 02:37 Matthew Hagerty <matthew@wolfepub.com>
0 siblings, 2 replies; 4+ messages in thread
From: Matthew Hagerty @ 1998-08-20 02:37 UTC (permalink / raw)
To: pgsql-interfaces
Greetings,
Sorry for the off topic question.
Where can I find a *complete* list of postgresql data types? I have looked
all over the web site and found what seems to be a partial list. I assume
it to be partial because I see no reference to the text, name, filename,
etc. types.
Also, is there an equivilant of the CAE specification (1992) Extended-SQL
data type binary(n)?
Thanks,
Matthew
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Data types and binary data
@ 1998-08-20 05:12 Thomas G. Lockhart <lockhart@alumni.caltech.edu>
parent: Matthew Hagerty <matthew@wolfepub.com>
1 sibling, 1 reply; 4+ messages in thread
From: Thomas G. Lockhart @ 1998-08-20 05:12 UTC (permalink / raw)
To: Matthew Hagerty <matthew@wolfepub.com>; +Cc: pgsql-interfaces
> Where can I find a *complete* list of postgresql data types? I have
> looked all over the web site and found what seems to be a partial
> list. I assume it to be partial because I see no reference to the
> text, name, filename, etc. types.
Hmm. I updated the User's Guide html document on the web site the other
day, and put tar files of the html in /pub/patches/*.tar.gz
Pretty sure I don't mention "filename" in the docs, but am certain I
talk about "text" and mention "name" in passing. Look inside the chapter
on Data Types, in the section on Character Types.
I also forgot to discuss the "oid" type; if there are any others missing
from the docs let me know. Others should speak up too if they see
omissions; that's "my" chapter :)
> Also, is there an equivilant of the CAE specification (1992)
> Extended-SQL data type binary(n)?
Don't know. What does it do? Is the same as a blob? If so, then you need
to use the large object interface.
- Tom
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Data types and binary data
@ 1998-08-20 11:39 James Olin Oden <joden@lee.k12.nc.us>
parent: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 0 replies; 4+ messages in thread
From: James Olin Oden @ 1998-08-20 11:39 UTC (permalink / raw)
To: Thomas G. Lockhart <lockhart@alumni.caltech.edu>; +Cc: Matthew Hagerty <matthew@wolfepub.com>; pgsql-interfaces
> I also forgot to discuss the "oid" type; if there are any others missing
> from the docs let me know. Others should speak up too if they see
> omissions; that's "my" chapter :)
Well, I don't know if it belongs in that chapter, but I have been unable to
find anything documented concerning the catalogues. The other day someone
sent an email with a shell script that did a select onpg_database (which I
did not know existed). It was really cool, because, he could get the list
of the database names, and insure that he truly backed _everything_ up.
Anyway, I would like to see that part of the postgres documented (if its not
already, and I have just not looked hard enough).
Thanks...james
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Data types and binary data
@ 1998-08-20 12:39 Tom Good <tomg@nrnet.org>
parent: Matthew Hagerty <matthew@wolfepub.com>
1 sibling, 0 replies; 4+ messages in thread
From: Tom Good @ 1998-08-20 12:39 UTC (permalink / raw)
To: Matthew Hagerty <matthew@wolfepub.com>; +Cc: pgsql-interfaces
On Wed, 19 Aug 1998, Matthew Hagerty wrote:
> Where can I find a *complete* list of postgresql data types? I have looked
> all over the web site and found what seems to be a partial list. I assume
> it to be partial because I see no reference to the text, name, filename,
> etc. types.
Hi.
output from \dT at the isql (psql) prompt...
type |description
---------+-------------------------------------------------------------
SET |set of tuples
abstime |absolute, limited-range date and time (Unix system time)
aclitem |access control list
bool |boolean 'true'/'false'
box |geometric box '(lower left,upper right)'
bpchar |blank-padded characters, length specifed when created
bytea |variable length array of bytes
char |single character
char16 |16 characters, fixed length
char2 |2 characters
char4 |4 characters
char8 |8 characters
cid |command identifier type, sequence in transaction id
circle |geometric circle '(center,radius)'
date |ANSI SQL date 'yyyy-mm-dd'
datetime |date and time 'yyyy-mm-dd hh:mm:ss'
filename |filename used in system tables
float4 |single-precision floating point number, 4-byte
float8 |double-precision floating point number, 8-byte
int2 |two-byte integer, -32k to 32k
int28 |8 2-byte integers, used internally
int4 |4-byte integer, -2B to 2B
line |geometric line '(pt1,pt2)'
lseg |geometric line segment '(pt1,pt2)'
money |money '$d,ddd.cc'
name |31-character type for storing system identifiers
oid |object identifier type
oid8 |array of 8 oid, used in system tables
oidint2 |oid and int2 composed
oidint4 |oid and int4 composed
oidname |oid and name composed
path |geometric path '(pt1,...)'
point |geometric point '(x, y)'
polygon |geometric polygon '(pt1,...)'
regproc |registered procedure
reltime |relative, limited-range time interval (Unix delta time)
smgr |storage manager
text |native variable-length string
tid |tuple identifier type, physical location of tuple
time |ANSI SQL time 'hh:mm:ss'
timespan |time interval '@ <number> <units>'
timestamp|limited-range ISO-format date and time
tinterval|time interval '(abstime,abstime)'
unknown |
varchar |non-blank-padded-length string, length specified when created
xid |transaction id
(46 rows)
Cheers,
Tom
----------- Sisters of Charity Medical Center ----------
Department of Psychiatry
----
Thomas Good, System Administrator <tomg@q8.nrnet.org>
North Richmond CMHC/Residential Services Phone: 718-354-5528
75 Vanderbilt Ave, Quarters 8 Fax: 718-354-5056
Staten Island, NY 10304 www.panix.com/~ugd
----
Powered by PostgreSQL 6.3.2 / Perl 5.004 / DBI-0.91::DBD-PG-0.69
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1998-08-20 12:39 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-08-20 02:37 Data types and binary data Matthew Hagerty <matthew@wolfepub.com>
1998-08-20 05:12 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1998-08-20 11:39 ` James Olin Oden <joden@lee.k12.nc.us>
1998-08-20 12:39 ` Tom Good <tomg@nrnet.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox