Works perfect. I'll trap and show only our databases to the user.
all thanks
On Wed, 2012-03-07 at 21:00 +0100, Szymon Guz wrote:
> On 7 March 2012 20:36, Bret Stern
> wrote:
> Is it possible through ODBC to connect to a PostgreSql
> server and query for the available databases?
>
On 7 March 2012 20:36, Bret Stern wrote:
> Is it possible through ODBC to connect to a PostgreSql
> server and query for the available databases?
>
> When our application upgrades, we typically create a
> new database. I want to design a form which allows
> the user to select the old database, wh
Is it possible through ODBC to connect to a PostgreSql
server and query for the available databases?
When our application upgrades, we typically create a
new database. I want to design a form which allows
the user to select the old database, which then
migrates data to the new (currently connected
Thanks all for clarifying me... Good to know this...
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
2011/12/27 Filip Rembiałkowski
> so as long as actual logic is buried in the guts of psql, best you can
> do in SQL to get human-readable value is
>
> SELE
so as long as actual logic is buried in the guts of psql, best you can
do in SQL to get human-readable value is
SELECT name, setting, unit, case when unit='kB' then
pg_size_pretty(setting::int*1024) when unit='8kB' then
pg_size_pretty(setting::int*1024*8) else coalesce(setting||'
'||unit,setting)
On Tue, 2011-12-27 at 15:21 +0530, Raghavendra wrote:
>
>
> On Tue, Dec 27, 2011 at 3:16 PM, Guillaume Lelarge
> wrote:
> On Tue, 2011-12-27 at 14:56 +0530, Raghavendra wrote:
> > Respected,
> >
> > Am in PG 9.1. See below ouputs.
> >
>
>
On Tue, Dec 27, 2011 at 3:16 PM, Guillaume Lelarge
wrote:
> On Tue, 2011-12-27 at 14:56 +0530, Raghavendra wrote:
> > Respected,
> >
> > Am in PG 9.1. See below ouputs.
> >
> > *By query:*
> > postgres=# SELECT name, setting, unit,context FROM pg_settings WHERE
> > category like '%Resource Usage /
On Tue, 2011-12-27 at 14:56 +0530, Raghavendra wrote:
> Respected,
>
> Am in PG 9.1. See below ouputs.
>
> *By query:*
> postgres=# SELECT name, setting, unit,context FROM pg_settings WHERE
> category like '%Resource Usage / Memory%' ORDER BY name;
>name| setting | unit |
Respected,
Am in PG 9.1. See below ouputs.
*By query:*
postgres=# SELECT name, setting, unit,context FROM pg_settings WHERE
category like '%Resource Usage / Memory%' ORDER BY name;
name| setting | unit | context
---+-+--+
ma
Grant Maxwell writes:
> The error was that if "show all" was run on this postgresql (version
> 8.3) server, postgres would crash and then recover.
> The postgres log showed:
> Sep 10 23:55:36 theconsole postgres[31118]: [4-1] 0: LOG: 0:
> server process (PID 31145) was te
First of all thanks to those who provided input.
This problem is now fixed and I thought I would post this solution so
that others might benefit in the future.
For the sake of completeness:
The error was that if "show all" was run on this postgresql (version
8.3) server, postgres would cr
Grant Maxwell writes:
> On 11/09/2009, at 8:36 AM, Tom Lane wrote:
>> Did you restart the postmaster afterwards?
> yep - full restart.
okay, next step is to collect a stack trace ...
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgres
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
>> shared_preload_libraries = 'pgmemcache'
...
> Sounds like a smoking gun to me.
Yep, known problem with pgmemcache. Bruce and I poked around
with this about a year ago. Bruce, I think you were going
to throw the problem at some EDB people - di
On 11/09/2009, at 8:36 AM, Tom Lane wrote:
Grant Maxwell writes:
On the problem server:
shared_preload_libraries = 'pgmemcache'
#local_preload_libraries = ''
on the others both are emply.
Sounds like a smoking gun to me.
For good measure I removed pgmemcache but the pro
Grant Maxwell writes:
> On the problem server:
> shared_preload_libraries = 'pgmemcache'
> #local_preload_libraries = ''
> on the others both are emply.
Sounds like a smoking gun to me.
> For good measure I removed pgmemcache but the problem persists.
Did you restart the postmaster
On 11/09/2009, at 8:17 AM, Tom Lane wrote:
Grant Maxwell writes:
On 11/09/2009, at 1:09 AM, Richard Huxton wrote:
Hmm - some modules can provide their own config variables. Do you
have
the same modules installed in all three servers?
How can I determine what modules are
Grant Maxwell writes:
> On 11/09/2009, at 1:09 AM, Richard Huxton wrote:
>> Hmm - some modules can provide their own config variables. Do you have
>> the same modules installed in all three servers?
> How can I determine what modules are installed ?
The contents of the local_preloa
On 11/09/2009, at 1:09 AM, Richard Huxton wrote:
On this one server if I use the command "show all" in psql,
phpPgAdmin
or pgAdmin3 the postgresql server spits the dummy as follows:
postgres=# show all;
server closed the connection unexpectedly
Hmm - some modules can provide their ow
On Thu, Sep 10, 2009 at 8:37 AM, Grant
Maxwell wrote:
> Hi folks
> First time poster here so please extend grace if I don't initially provide
> what is needed to help.
> I am running postgresql 8.3.7 on debian lenny
> (postgresql-8.3_8.3.7-0lenny1_i386.deb).
> I have three of these servers and gene
Grant Maxwell wrote:
> Hi folks
>
> First time poster here so please extend grace if I don't initially
> provide what is needed to help.
>
> I am running postgresql 8.3.7 on debian lenny
> (postgresql-8.3_8.3.7-0lenny1_i386.deb)
Well that's useful.
> I have three of these servers and generally
Hi folks
First time poster here so please extend grace if I don't initially
provide what is needed to help.
I am running postgresql 8.3.7 on debian lenny
(postgresql-8.3_8.3.7-0lenny1_i386.deb).
I have three of these servers and generally they run well.
On this one server if I use the co
"Anderson dos Santos Donda" <[EMAIL PROTECTED]> writes:
> How can I show on terminal all commands executed by my postgre server?
You could turn on log_statements and then tail -f the postmaster log.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@
How can I show on terminal all commands executed by my postgre server?
Example: My system execute the comand : 'SELECT * FROM clients' and the
postgre show this commando on the terminal ?
Thanks
Willy-Bas Loos wrote:
Hi,
I´m on a slow internet connection, but i want to optimize a view on a
server. I have console access, so psql seems the right way - pgAdmin from
the client is just way biassed.
How can i make psql report the amount of time that was consumed in the
query??
I´ve seen a cou
am Wed, dem 13.02.2008, um 10:22:29 +0100 mailte Willy-Bas Loos folgendes:
> How can i make psql report the amount of time that was consumed in the query??
> IŽve seen a couple of posts that refer to this, but everyone seems to solve it
> in some other way. Is this not a feature of psql? (it shoul
Hi,
I´m on a slow internet connection, but i want to optimize a view on a
server. I have console access, so psql seems the right way - pgAdmin from
the client is just way biassed.
How can i make psql report the amount of time that was consumed in the
query??
I´ve seen a couple of posts that refer
[EMAIL PROTECTED] writes:
> Is there a way to see what the connection limit is set to for various
> users?
Look in pg_authid.
regards, tom lane
---(end of broadcast)---
TIP 5: don't forget to increase your free space map set
I have set the connection limit of a user with the ALTER ROLE command in
8.1. Is there a way to see what the connection limit is set to for various
users?
Thanks,
Ken
On 1/23/07, Jorge Godoy <[EMAIL PROTECTED]> wrote:
> select cal.date, coalesce(foo.x, 0) AS x
> from (select (date_trunc('day', current_timestamp) + (s.s * interval '1
> day'))::date AS date
> from generate_series(1,365) AS s) AS cal
> left join foo ON cal.date = foo.create_date;
Why
"Chad Wagner" <[EMAIL PROTECTED]> writes:
> Most people do this with a "calendar" table, worst case is you could use
> generate_series to do it (but it's ugly, and it may not scale well --
> haven't tested it) and left join it to your data table.
>
> select cal.date, coalesce(foo.x, 0) AS x
> fro
On 1/22/07, deepak pal <[EMAIL PROTECTED]> wrote:
i am fatching record's from data base between two date range for
registration_date coloum and than group by an count it using
count(registration_date) i have to show all dates even if date is not there
in registration_date ,it should show date an
i am fatching record's from data base between two date range for
registration_date coloum and than group by an count it using
count(registration_date) i have to show all dates even if date is not there
in registration_date ,it should show date and 0 in count.,how can i do it
plz healp...
Hi, Is there a way to send a "show all" to a specific backend? Thanks! Benkendorf!
Yahoo! doce lar. Faça do Yahoo! sua homepage.
BITCHES!
All that I'm doing for you fucking people. Be grateful!
Mike Cox
Mike Cox
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED]
Hi Joe.
>
> Start up psql with the -E on the command line. Then do \d TABLE. This will
> show you the actual SQL commands used by psql.
Doesn't change nothing.
> See the psql man page for more details.
No hints to find there respective to the libpq's PQexec.
Greetings
Steve
---
> > > What is the equivalent to the mysql's:
> > > SHOW COLUMNS FROM [TABLENAME];
> >
> > in psql, \d will show you all tables and \d TABLE will show you the
> > columns in the table. If you need it as a sql command, you can check
the
> > system tables.
>
> OK. That works for ./bin/psql, but NO
Hi!
>
> > What is the equivalent to the mysql's:
> > SHOW COLUMNS FROM [TABLENAME];
>
> in psql, \d will show you all tables and \d TABLE will show you the
> columns in the table. If you need it as a sql command, you can check the
> system tables.
OK. That works for ./bin/psql, but NOT on th
You can get a list of all triggers in the system
as
select * from pg_trigger;
You can get the source for a PL function a trigger
calls with:
select prosrc from pg_trigger,pg_proc where
pg_proc.oid=pg_trigger.tgfoid
and pg_trigger.tgname = ''
[Note, in the case of C functions, I think this
r
Forgive me if I am missing the obvious, but can someone please tell me how
to show a list of triggers, or the code in a specific trigger, via the pgsql
utility?
Thank you,
Bryan
39 matches
Mail list logo
