Dear Friends,
Postgres 7.3.2.
I have an database with owner USRA who owns about
300 objects (tables and functions). Now I want to give 'ALL' permission to all
the objects of USRA to another database user USRB.
If I use the grant i need to type all the objects
as comma separated, like th
hi
SELECT 'tbl'::regclass;
works fine
SELECT 'tbl'::text::regclass;
says cannot convert type text to regclass
what to do ?
---(end of broadcast)---
TIP 8: explain analyze is your friend
hi,
does any version of postgresql support the 'SET' idiom in an insert
statement? Need this to generate an insert statement from a python dictionary
--
regards
kg
--
http://www.ootygolfclub.org
---(end of broadcast)---
TIP 6: Have you searched ou
hello list,
i am using pgsql 7.2.1
i need something like
select * from t1 full join t2 using(bla) full join t3 using(bla)
i searched the archives and found that this is not possible with my
version of postgres.
is this implemented in newer versions of postgres? since which version?
i'll try the
On Wed, 14 Apr 2004, Tina Messmann wrote:
> hello list,
>
> i am using pgsql 7.2.1
> i need something like
>
> select * from t1 full join t2 using(bla) full join t3 using(bla)
>
> i searched the archives and found that this is not possible with my
> version of postgres.
> is this implemented i
Thanks for the reply.
-Tony
- Original Message -
From: "Christoph Haller" <[EMAIL PROTECTED]>
To: "Tony Reina" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, April 14, 2004 5:42 PM
Subject: Re: [SQL] Help with COPY command
> >
> > Ok. I found the libpq syntax for COPY i
>
> Ok. I found the libpq syntax for COPY in the Programmer's manual. I've
> got a working version, but wanted to verify something.
>
> PQexec(conn, "COPY foo FROM STDIN");
> PQputline(conn, "3\thello world\t4.5\n");
> PQputline(conn,"4\tgoodbye world\t7.11\n");
> ...
> PQputline(conn,"\\.\n");
>
