Hello,
2011/1/13 tbazadaykin :
> I need something like that
>
> SELECT sprintf('String with pattens: %d, %s',13,'abc');
>
function sprintf is available from pltoolbox library
http://pgfoundry.org/frs/?group_id=1000457
Regards
Pavel Stehule
> and return:
>
> 'String with pattens: 13, abc';
>
I need something like that
SELECT sprintf('String with pattens: %d, %s',13,'abc');
and return:
'String with pattens: 13, abc';
Thanks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
unsubscribe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Bosco Rama writes:
> Hi folks,
> I've been using large objects in 8.4.x for some time now and have noticed that
> some operations on large objects appear to take an inordinate amount of time.
> For example, the \lo_list command in psql seems slow for what it does (many
> seconds before first prin
Hi folks,
I've been using large objects in 8.4.x for some time now and have noticed that
some operations on large objects appear to take an inordinate amount of time.
For example, the \lo_list command in psql seems slow for what it does (many
seconds before first printed line with only a few thou
At 2011-01-12 23:22:40,"Bill Moran" wrote:
>In response to zab08 :
>
>> we have e test db server, we use jdbc to contect.
>> but after a whie, The test db server can not accept connect.
>>
>>
>> useps aux | grep postgrescommand :
>> postgres 16904 0.0 0.0 46036 3948 ?S17:03
On Wed, Jan 12, 2011 at 12:03 AM, Dan Birken wrote:
> If I commit asynchronously and then follow that with a synchronous commit,
> does that flush the asynchronous commit as well?
I'm pretty sure it does, because it has to flush the write-ahead log
to disk, and there's only one. You can think of
In response to zab08 :
> we have e test db server, we use jdbc to contect.
> but after a whie, The test db server can not accept connect.
>
>
> useps aux | grep postgrescommand :
> postgres 16904 0.0 0.0 46036 3948 ?S17:03 0:00
> /usr/local/pgsql/bin/postgres -D /usr/local/pgs
On 2011-01-12 13.13, zab08 wrote:
we have e test db server, we use jdbc to contect.
but after a whie, The test db server can not accept connect.
useps aux | grep postgrescommand :
postgres 16904 0.0 0.0 46036 3948 ?S17:03 0:00
/usr/local/pgsql/bin/postgres -D /usr/local/pgs
Yes, we require SSL connections, because we have multiple clients that
access the database external from the server where the database resides.
Michael
On Tue, Jan 11, 2011 at 10:36 PM, Kenneth Buckler wrote:
> Something to think about heredoes your database actually require
> encryption? Or
we have e test db server, we use jdbc to contect.
but after a whie, The test db server can not accept connect.
useps aux | grep postgrescommand :
postgres 16904 0.0 0.0 46036 3948 ?S17:03 0:00
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
postgres 16906 0.0 0.0 4614
11 matches
Mail list logo