On Mon, Aug 22, 2005 at 03:23:29AM -0700, Roger Tannous wrote:
> So, D'Arcy's solution, although described as 'unsatisfactory' (ref.:
> D'Arcy's message), seem to be the only solution.
>
> So I noticed I was trying to play the wise man, trying to do things in a
> better way, but nothing was found
So, D'Arcy's solution, although described as 'unsatisfactory' (ref.:
D'Arcy's message), seem to be the only solution.
So I noticed I was trying to play the wise man, trying to do things in a
better way, but nothing was found than D'Arcy's query:
SELECT pg_namespace.nspname, pg_class.relname,pg_at
OUPS !!
Things seem to be stuck now, since the DB version is 7.3.2, so no
array_to_string method is available.
Does anyone have any idea how to solve that ?
Regards,
Roger Tannous.
--- Roger Tannous <[EMAIL PROTECTED]> wrote:
> Hi to all, there was a BIG MISTAKE in my proposition regarding my
Hi to all, there was a BIG MISTAKE in my proposition regarding my last
post:
In fact, after examining the online documentation (Note that I don't have
enough experience in postgreSQL !!) I found that
select '(' || replace('1 2', " ", ",") || ')';
could not, in any way, be equivalent to:
selec
Hi,
If you put pg_index.indkey in the select statement, you'd notice that it's
sometimes 1 ( it's when we have one PK field) and sometimes 1 2 ( for two
PK fields), etc.
So I tried to use a replace command like the following:
(just to add parentheses, replace the space by a comma to use the
res
"D'Arcy J.M. Cain" writes:
> That's a good question. The following query does this in a very
> unsatisfactory way. Anyone know what the general solution would be?
> ...
> (
> pg_index.indkey[0]=pg_attribute.attnum OR
> pg_index.indkey[1]=pg_attribute.attnum OR
> pg_index.i
On Thu, 18 Aug 2005 09:40:57 -0700 (PDT)
Roger Tannous <[EMAIL PROTECTED]> wrote:
> Thanks for your query :)
>
> But it only shows the first of the primary keys of tables having multiple
> primary keys :)
>
> This is apparently because of the pg_index.indkey[0] thing, so how can we
> manage this
Yes, I want only field names, not values.
Thanks,
Roger Tannous.
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast)---
TIP
Thanks for your query :)
But it only shows the first of the primary keys of tables having multiple
primary keys :)
This is apparently because of the pg_index.indkey[0] thing, so how can we
manage this query in order to get all of the keys :)
Thanks in advance,
Roger Tannous.
--- "D'Arcy J.M.
On Thu, 18 Aug 2005 07:36:22 -0700 (PDT)
Roger Tannous <[EMAIL PROTECTED]> wrote:
> Is there any means to get a list of the Primary Keys (or simply the
> Primary Key if there's only one :) ) for a given table using an SQL query
Here is what I do in PyGreSQL:
SELECT pg_namespace.nspname, pg_class.
RT> Hi to all,
RT> Is there any means to get a list of the Primary Keys (or simply the
RT> Primary Key if there's only one :) ) for a given table using an SQL query
RT> ?
RT> Regards,
RT> Roger Tannous.
Something like this?
select (select attname from pg_attribute where attrelid=pg_index.ind
On Thu, Aug 18, 2005 at 07:36:22AM -0700, Roger Tannous wrote:
> Is there any means to get a list of the Primary Keys (or simply the
> Primary Key if there's only one :) ) for a given table using an SQL query?
Are you looking for the primary key definition or do you want the
primary key values the
Hi to all,
Is there any means to get a list of the Primary Keys (or simply the
Primary Key if there's only one :) ) for a given table using an SQL query
?
Regards,
Roger Tannous.
__
Do you Yahoo!?
Yahoo! Mail - You care about securi
13 matches
Mail list logo
