I am in the process of trying to convince a Microsoft SQL Guy, that Postgres is what
we need to look at, for replacing one of our OTHER ($$) databases. He wants to go
with SQL Server. One of his arguments is that PostgreSQL functions don't return
Record Sets. Is this true, or can functio
I am looking at 7.1 beta 1 to see how my application (currently on 7.0.3) will
operate under 7.1. To calculate used space, in 7.0.3, I lookup the relpages count
for the table in pg_class and multiply it by 8 (8k is my block size). In my testing
of 7.1 beta 1, I created a record of length
field matches the oid field in pg_attribute (which is the
"fields" table for pgsql).
On 30 Nov 2000, at 11:17, Dale Anderson wrote:
>I am able to add table and column descriptions, and I am also able
>to retrieve the table description. The problem is that I can not
&
The BitBucket on unix is /DEV/NULL, or the place where things will disappear.
>>> Herbert Liechti <[EMAIL PROTECTED]> 06/27/00 09:35AM >>>
Thomas Lockhart wrote:
> > Yeah, it just vanished. Not my fault. The bitbucket ate it.
And what is a bitbucket? My dictioniary knows nothing
about this word
'));
INSERT 22825 1
danderso=# select * from test;
time
2000-06-28 00:00:00-05
(1 row)
danderso=#
Thanks,
Dale.
>>> Tom Lane <[EMAIL PROTECTED]> 06/26/00 05:41PM >>>
"Dale Anderson" <[EMAIL PROTECTED]> writes:
Is there a way to query the field names and types of a table in either 6.5 or 7.0?? I
am writing an application, and in one piece, I need to get the field names and field
types of any table. Can this be done??? I have searched both the web and
documentation, and I can't seem to find a C func
Is there any way to use table names longer than 32 characters
Dale.