> On Oct 29, 2021, at 2:05 PM, Tom Lane wrote:
>
> "David G. Johnston" writes:
>> On Friday, October 29, 2021, Philip Semanchuk
>> wrote:
>>> I would appreciate help with the syntax for querying an array of strings
>>> declared as a psql variable. Here's an example.
>>>
>>> \set important_d
"David G. Johnston" writes:
> On Friday, October 29, 2021, Philip Semanchuk
> wrote:
>> I would appreciate help with the syntax for querying an array of strings
>> declared as a psql variable. Here's an example.
>>
>> \set important_days ARRAY['monday', 'friday']
> Not sure why the single quote
Hi
pá 29. 10. 2021 v 19:21 odesílatel Philip Semanchuk <
phi...@americanefficient.com> napsal:
> Hi,
> I would appreciate help with the syntax for querying an array of strings
> declared as a psql variable. Here's an example.
>
> \set important_days ARRAY['monday', 'friday']
>
> select 1 where 'm
On Friday, October 29, 2021, Philip Semanchuk
wrote:
> Hi,
> I would appreciate help with the syntax for querying an array of strings
> declared as a psql variable. Here's an example.
>
> \set important_days ARRAY['monday', 'friday']
Not sure why the single quotes are getting stripped out but t
Hi,
I would appreciate help with the syntax for querying an array of strings
declared as a psql variable. Here's an example.
\set important_days ARRAY['monday', 'friday']
select 1 where 'monday' = ANY(:important_days);
ERROR: 42703: column "monday" does not exist
LINE 1: select 1 where 'monday'
On 10/29/21 03:46, Shaozhong SHI wrote:
I used a DBeaver to connect to postgres but it does not show all tables
in a schema.
Can anyone shed light on this?
Not without:
1) Postgres version
2) DBeaver version
3) JDBC version
4) Example of what you expect to see vs what you are seeing
In ot
On 10/29/21 07:02, Pratik Mehta wrote:
Hi Postgres Community,
I am an Oracle DBA with 12 years experience. The example in Postgres
dblink_connect page seems incomplete. We find it difficult to
understand. How can I get access to more examples ?
Also, in dblink page
https://www.postgresql.or
On 10/29/21 09:43, Peter J. Holzer wrote:
On 2021-10-29 09:03:04 -0400, Mladen Gogala wrote:
On 10/29/21 08:49, Peter J. Holzer wrote:
I don't think that's equivalent. An Oracle instance is a runtime concept
(the collection of server processes on a single machine serving a single
database (th
Pratik Mehta writes:
> I am an Oracle DBA with 12 years experience. The example in Postgres
> dblink_connect page seems incomplete. We find it difficult to understand.
> How can I get access to more examples ?
If you're really confused, you could look at the module's regression
tests:
https://gi
On Fri, 29 Oct 2021 at 14:53, Ryan Booz wrote:
> In a recent update (not sure when), the default for DBeaver seems to have
> changed so that the navigator view is set to "simple", rather than
> "advanced" which shows all objects.
>
> Right-click the server -> edit connection -> Select "General" -
Hi Postgres Community,
I am an Oracle DBA with 12 years experience. The example in Postgres
dblink_connect page seems incomplete. We find it difficult to understand.
How can I get access to more examples ?
Also, in dblink page
https://www.postgresql.org/docs/12/contrib-dblink-function.html, can w
Peter J. Holzer schrieb am 29.10.2021 um 15:43:
>> Peter, Oracle instance manages collection of the databases and is ensuring
>> recoverabilty using redo logs, which are completely analogous to WAL logs,
>> if managed a bit differently. Let's not be nitpicking here. Oracle instance
>> is completely
In a recent update (not sure when), the default for DBeaver seems to have
changed so that the navigator view is set to "simple", rather than
"advanced" which shows all objects.
Right-click the server -> edit connection -> Select "General" -> verify
"Navigator View"
On Fri, Oct 29, 2021 at 9:48
It is a new installation with all permissions. Nothing has done to it.
Regards,
David
On Fri, 29 Oct 2021 at 14:14, negora wrote:
> Are you sure that you're not applying a filter in the "Database
> Navigator" panel of DBeaver?
>
> Sometimes, it occurs to me that I apply a filter for certain d
On 2021-10-29 09:03:04 -0400, Mladen Gogala wrote:
> On 10/29/21 08:49, Peter J. Holzer wrote:
> > I don't think that's equivalent. An Oracle instance is a runtime concept
> > (the collection of server processes on a single machine serving a single
> > database (the collection of files on the disk)
Are you sure that you're not applying a filter in the "Database
Navigator" panel of DBeaver?
Sometimes, it occurs to me that I apply a filter for certain database, I
forget to remove it, then open another database, and some or all tables
do not appear in the navigator.
On 29/10/2021 12:46,
On 10/29/21 08:49, Peter J. Holzer wrote:
I don't think that's equivalent. An Oracle instance is a runtime concept
(the collection of server processes on a single machine serving a single
database (the collection of files on the disk)) whereas a PostgreSQL cluster is
both a data and a runtime c
On 2021-10-29 08:38:47 -0400, Mladen Gogala wrote:
> On 10/29/21 03:30, Peter J. Holzer wrote:
> > I was not aware that Oracle even has something equivalent to a Postgres
> > cluster.
>
> It's called "Oracle instance".
I don't think that's equivalent. An Oracle instance is a runtime concept
(the
On 10/29/21 5:46 AM, Shaozhong SHI wrote:
I used a DBeaver to connect to postgres but it does not show all tables in
a schema.
Can anyone shed light on this?
Permissions?
--
Angular momentum makes the world go 'round.
On 10/29/21 03:30, Peter J. Holzer wrote:
I was not aware that Oracle even has something equivalent to a Postgres cluster.
hp
It's called "Oracle instance".
Regards
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
I used a DBeaver to connect to postgres but it does not show all tables in
a schema.
Can anyone shed light on this?
Regards,
David
On 2021-10-28 21:14:53 -0400, Mladen Gogala wrote:
> On 10/28/21 18:07, Andreas Joseph Krogh wrote:
> I think everybody agrees that incremental backup per database, and not
> cluster-wide, is nice, and it would be nice if PG supported it. But, given
> the way PG is architectured, having
22 matches
Mail list logo
