On Sun, Jan 14, 2001 at 04:46:08AM +0100, Alvar Freude wrote:
> Peter Eisentraut schrieb:
> >
> > > today i was trying to perform a query on a database using a time stamp
> > > field, i need to get all records which belong to year 2000, month 11,
> [...]
> > select user_name from tbacct whe
At 1/12/2001 10:35 AM, Josh Berkus wrote:
>Mr. Naik,
>
> > What's the purpose of Serials in Data types of postgres ?
> > TIA
> > Sharmad
SERIAL is the same as makeing a column and then setting the default value
to a sequence. If you insert and don't specify the column that is of type
serial it w
I'm trying to extract references (relationships) between tables for the
purpose of reverse/forward engineer from a modeling tool called
PowerDesigner.
Here is the sql:
select u.usename,
p.relname,
v.usename,
c.relname,
t.tgconstrname,
dumpref(t.tgargs, 4),
> Sharmad Naik wrote:
>
> Dear Sir,
> I m doing a library management program using Postgresql as backend. We are
> given an ISO 2709 format flat file which is only a books dbase which is to be
> converted to postgres format
> My Q is that where should I import the file ? Please if possibl
Joe Conway writes:
> I was looking for a datatype to represent a single byte unsigned integer.
> The closest thing I can find looking through the online manual is a one byte
> char. Are there any side-effects of using a char datatype for this purpose?
Yes, it won't store single byte unsigned int
Dear Sir,
I m doing a library
management program using Postgresql as backend. We are given an ISO
2709 format flat file which is only a books dbase which is to be
converted to postgres format
My Q is that where should I
import the file ? Please if possible specify the file or directo
Hello,
I was looking for a datatype to represent a single byte unsigned integer.
The closest thing I can find looking through the online manual is a one byte
char. Are there any side-effects of using a char datatype for this purpose?
Is there a better datatype to use?
Thanks in advance,
Joe
