Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] grep command

From: "Medi Montaseri" <montaseri(at)gmail(dot)com>
To: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
Cc: "Kuriakose, Cinu Cheriyamoozhiyil" <Cinu(dot)Kuriakose(at)in(dot)unisys(dot)com>, pgsql-hackers(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: [HACKERS] grep command
Date: 2007-10-29 18:58:50
Message-ID: 8078a1730710291158p6c643f03ycdd5f080ba816681@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
Or ... ask the application not the OS  ....

psql> select version() ;

Cheers
Medi

On 10/29/07, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
>
>
> Leaving aside the question of why one might want to do this, Unix 101
> should show you many ways to do it. For example,
>
> sed -n -e 's/.*PG_VERSION /PG_VERSION /p' -e /PG_VERSION/q config.log
>
> Please don't cross-post questions like this, especially when it's not
> really a PostgreSQL question at all.
>
> cheers
>
> andrew
>
> Kuriakose, Cinu Cheriyamoozhiyil wrote:
> > Hi All,
> >
> > I am giving the command
> >
> > cat config.log|grep -w 'PG_VERSION'
> >
> > Which gives the following Output:
> >
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > | #define PG_VERSION "8.3beta2"
> > #define PG_VERSION "8.3beta2"
> >
> > But the output that I would require is
> >
> > PG_VERSION "8.3beta2" that should occur only once, can anyone please
> > tell me the command to get this output.
> >
> > Thanks in advance
> >
> > Regards
> > Cinu Kuriakose
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 9: In versions below 8.0, the planner will ignore your desire to
> >        choose an index scan if your joining column's datatypes do not
> >        match
> >
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

In response to

pgsql-hackers by date

Next:From: Teodor SigaevDate: 2007-10-29 19:27:21
Subject: pgsql: - Add check of already changed page while replay WAL.
Previous:From: Jeff DavisDate: 2007-10-29 18:26:29
Subject: Re: [HACKERS] WAL archiving idle database

pgsql-admin by date

Next:From: Tom LaneDate: 2007-10-29 18:59:03
Subject: Re: Indexes for Foreign Keys?
Previous:From: Richard Broersma JrDate: 2007-10-29 17:53:49
Subject: Re: Indexes for Foreign Keys?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group