On 11/28/22 00:04, Thomas Kellerer wrote:
Igor Korot schrieb am 27.11.2022 um 23:13:
I've never heard of a database referred to as a catalog. (That's always
been where a database's metadata -- i.e. the pg_catalog schema -- is stored.)
In the ODBC terminology the DB is usually referenced as cat
Igor Korot schrieb am 27.11.2022 um 23:13:
>> I've never heard of a database referred to as a catalog. (That's always
>> been where a database's metadata -- i.e. the pg_catalog schema -- is stored.)
>
> In the ODBC terminology the DB is usually referenced as catalog.
JDBC uses the same term and t
On 11/27/22 14:11, Igor Korot wrote:
David,
On Sun, Nov 27, 2022 at 12:55 PM David G. Johnston
wrote:
On Sun, Nov 27, 2022 at 11:42 AM Igor Korot wrote:
It doesn't say anything about "current" DB - only the DB.
Yes, but you must be connected to some database in order to execute this co
Ron,
On Sun, Nov 27, 2022 at 4:10 PM Ron wrote:
>
> On 11/27/22 15:55, Adrian Klaver wrote:
> > On 11/27/22 13:31, Ron wrote:
> >> On 11/27/22 11:22, Igor Korot wrote:
> >>> Hi, ALL,
> >>> Table pg_indexes does not contain a field for a catalog.
> >>>
> >>> So how do I get that?
> >>>
> >>> SELEC
David,
On Sun, Nov 27, 2022 at 12:55 PM David G. Johnston
wrote:
>
> On Sun, Nov 27, 2022 at 11:42 AM Igor Korot wrote:
>>
>>
>> It doesn't say anything about "current" DB - only the DB.
>
>
> Yes, but you must be connected to some database in order to execute this
> command: "the database" ref
On 11/27/22 15:55, Adrian Klaver wrote:
On 11/27/22 13:31, Ron wrote:
On 11/27/22 11:22, Igor Korot wrote:
Hi, ALL,
Table pg_indexes does not contain a field for a catalog.
So how do I get that?
SELECT 1 FROM pg_indexes WHERE indexname = $1 AND tablename = $2 AND
schemaname = $3
You did not
Thx, Adrian.
On Sun, Nov 27, 2022 at 3:56 PM Adrian Klaver wrote:
>
> On 11/27/22 13:31, Ron wrote:
> > On 11/27/22 11:22, Igor Korot wrote:
> >> Hi, ALL,
> >> Table pg_indexes does not contain a field for a catalog.
> >>
> >> So how do I get that?
> >>
> >> SELECT 1 FROM pg_indexes WHERE indexna
On 11/27/22 13:31, Ron wrote:
On 11/27/22 11:22, Igor Korot wrote:
Hi, ALL,
Table pg_indexes does not contain a field for a catalog.
So how do I get that?
SELECT 1 FROM pg_indexes WHERE indexname = $1 AND tablename = $2 AND
schemaname = $3
You did not look hard enough, or Google "postgresql
On 11/27/22 11:22, Igor Korot wrote:
Hi, ALL,
Table pg_indexes does not contain a field for a catalog.
So how do I get that?
SELECT 1 FROM pg_indexes WHERE indexname = $1 AND tablename = $2 AND
schemaname = $3
You did not look hard enough, or Google "postgresql pg_indexes".
test=# \d pg_inde
On Sun, Nov 27, 2022 at 11:53 AM Igor Korot wrote:
>
> On Sun, Nov 27, 2022 at 12:45 PM Christophe Pettus
> wrote:
> >
>
> > In PostgreSQL terminology, a single PostgreSQL instance (the cluster)
> can have multiple databases.
>
> Just like any other DBMS.
>
The point was the terminology - write
On 11/27/22 10:42, Igor Korot wrote:
Hi, Erik,
On Sun, Nov 27, 2022 at 11:59 AM Erik Wienhold wrote:
On 27/11/2022 18:22 CET Igor Korot wrote:
Table pg_indexes does not contain a field for a catalog.
So how do I get that?
SELECT 1 FROM pg_indexes WHERE indexname = $1 AND tablename = $2 A
> On Nov 27, 2022, at 10:53, Igor Korot wrote:
> Are you saying I can't run any query on other DB? Or connect to DB and
> run select?
The query you run only looks at the system catalogs for the database you are
connected to (with the exception of the small number of global catalogs, like
pg_
On Sun, Nov 27, 2022 at 11:42 AM Igor Korot wrote:
>
> It doesn't say anything about "current" DB - only the DB.
>
Yes, but you must be connected to some database in order to execute this
command: "the database" refers to this database you are connected to.
The catalogs are not information_sche
Hi, Christopher,
On Sun, Nov 27, 2022 at 12:45 PM Christophe Pettus wrote:
>
>
>
> > On Nov 27, 2022, at 10:42, Igor Korot wrote:
> >
> > It doesn't say anything about "current" DB - only the DB.
>
> In PostgreSQL terminology, a single PostgreSQL instance (the cluster) can
> have multiple datab
> On Nov 27, 2022, at 10:42, Igor Korot wrote:
>
> It doesn't say anything about "current" DB - only the DB.
In PostgreSQL terminology, a single PostgreSQL instance (the cluster) can have
multiple databases. The database the connection is currently open to is the
current database.
Hi, Erik,
On Sun, Nov 27, 2022 at 11:59 AM Erik Wienhold wrote:
>
> > On 27/11/2022 18:22 CET Igor Korot wrote:
> >
> > Table pg_indexes does not contain a field for a catalog.
> >
> > So how do I get that?
> >
> > SELECT 1 FROM pg_indexes WHERE indexname = $1 AND tablename = $2 AND
> > schemana
> On 27/11/2022 18:22 CET Igor Korot wrote:
>
> Table pg_indexes does not contain a field for a catalog.
>
> So how do I get that?
>
> SELECT 1 FROM pg_indexes WHERE indexname = $1 AND tablename = $2 AND
> schemaname = $3
Use SELECT current_database() if you need to know the catalog.
pg_indexes o
Hi, ALL,
Table pg_indexes does not contain a field for a catalog.
So how do I get that?
SELECT 1 FROM pg_indexes WHERE indexname = $1 AND tablename = $2 AND
schemaname = $3
Thank you.
18 matches
Mail list logo