Hello,
In pgAdmin 1.8.2 - is there a way to *not display the data types in the
query data output window? Below the selected field names? Eg:
Fieldname1 Fieldname2
Biginit double precision,etc,,etc,,,
Your help in this would be greatly appreciated.
Thanks
d
>
>
> Regardless of your request about silencing context messages (did not
> look into that): maybe SQL along these lines would do the job for you?
>
> select id_cliente, array_to_string(ARRAY(SELECT apellido from clientes
> c0 WHERE c0.id_cliente = c.id_cliente), E'\n')
> from clientes c
> group b
On Apr 8, 3:01 pm, [EMAIL PROTECTED] ("Fernando Hevia") wrote:
(...)
> --- Function declaration follows in case it helps ---
> CREATE OR REPLACE FUNCTION f_inner(p_client numeric(10)) RETURNS void AS
> $BODY$
> DECLARE
> r_clients clientes%ROWTYPE;
> BEGIN
> SELECT * INTO r_clients FROM cliente
Dave Page wrote:
On Tue, Apr 1, 2008 at 1:17 AM, Erwin Brandstetter
<[EMAIL PROTECTED]> wrote:
Mistaken I am! A related, but different bug it is. This time, views it
affects, not tables.
Fixed it is. Pleased you'll be.
Pleased I shall be. May the force be with you, Master Dave!
-
On Tue, Apr 8, 2008 at 3:22 AM, Guillaume Lelarge <[EMAIL PROTECTED]>
wrote:
> Fernando Hevia a écrit :
>
> > On Mon, Apr 7, 2008 at 8:55 PM, Fernando Hevia <[EMAIL PROTECTED] > [EMAIL PROTECTED]>> wrote:
> > > Hi list,
> > >
> > > How do I remove CONTEXT messages from being displayed in pgadmi
On Tue, Apr 8, 2008 at 3:29 AM, Julius Tuskenis <[EMAIL PROTECTED]> wrote:
> Hello.
>
> What do you mean saying CONTEXT messages? Could you give an example what
> you get and what you want to get from your functions?
>
>
>
Sure. I have made a simple example to show this with 2 functions: f_outer
w
Abhi,
1st., the word is Hello, not Hallo!
Next, PgAdmin does allow you to change the name, but you cannot have a current
connection to that same database.
Steps to do this.
1. Right click the Databases branch and select refresh.
2. Click on database postgres and then open a Query window.
3. AL
Hi,
backup, create a new DB with the name you want and then restore data
into it.
--
Julius Tuskenis
leoabhi rašė:
Hallo,
Thanks for your reply. It helped and worked.
I tried to change the name of Database to small letters, but Pgadmin doesnt
allow me to do so or i failed to figure it o
Hallo,
Thanks for your reply. It helped and worked.
I tried to change the name of Database to small letters, but Pgadmin doesnt
allow me to do so or i failed to figure it out ?
Any suggestions how i can replace my existing database with a new name ?
thanks
Rgrds,
Abhi
Melvin Davidson-3 wr
On Tue, Apr 1, 2008 at 1:17 AM, Erwin Brandstetter
<[EMAIL PROTECTED]> wrote:
> I slightly miswrote:
>
>
> > I am afraid, the RULE privilege for pg >= 8.2 has risen from the dead in
> pgadmin 1.8.2.
> > My original bug report (to pgadmin-support@postgresql.org at 2007-03-05)
> applies in full again
Gah, that's what I get for not doublechekcing what that darn word
completion on my phone did with what I wrote :-)
That looks like it could be a *unicode* BOM. Can you open the file in a
*hex* editor and check the first couple of bytes..
//Magnus
Magnus Hagander wrote:
> Looks like it could be a
11 matches
Mail list logo