I am trying to pull in the different types allowed by postgres for a create
function statement and am having problems with the types that start with an
underscore (_). Because the underscore is the wildcard for a single
character, I cannot perform the following query correctly.
SELECT typname
I understand this, but does it set the indisprimary flag in the pg_index
table? The reason I ask is because I am writing a web based app to
administer a pgsql database and am attempting to keep track of the
indices/keys.
This is the property I am looking at determine whether the index is a
prima
--- Carl Hauser <[EMAIL PROTECTED]> wrote:
> I've searched the archives and docs without finding
> any help on this.
>
> I want to use:
>
> select * from rel1 except select * from rel2;
>
> where rel1 and and rel2 each currently have about
> 2000 records and are likely to grow to twice that
> s
I've searched the archives and docs without finding any help on this.
I want to use:
select * from rel1 except select * from rel2;
where rel1 and and rel2 each currently have about 2000 records and are likely to grow
to twice that size or more.
The query works but takes inordinately long. Loo
--- Herouth Maoz <[EMAIL PROTECTED]> wrote:
> At 14:37 +0300 on 24/07/1999, Jesper K. Pedersen
> wrote:
>
> > I have been using a much older version of
> postgresql and decided to
> > "trash" it and go to the 6.5.1beta1
> >
> > All installation of the server/client/devel went
> fine - but i a
At 14:37 +0300 on 24/07/1999, Jesper K. Pedersen wrote:
> I have been using a much older version of postgresql and decided to
> "trash" it and go to the 6.5.1beta1
>
> All installation of the server/client/devel went fine - but i am unable
> to install the default database - postgresql-data-