Tom Lane a écrit :
> Denis BUCHER writes:
>> Yes that's correct. Therefore my "problem" is the "normal" behavior of
>> \dt. But "normal" means "expected". But I don't find it very
>> secure/handy, because you expect to see all your tables. Is there a way
>> to change the behavior of \dt so that it
Denis BUCHER writes:
> Yes that's correct. Therefore my "problem" is the "normal" behavior of
> \dt. But "normal" means "expected". But I don't find it very
> secure/handy, because you expect to see all your tables. Is there a way
> to change the behavior of \dt so that it lists ALL tables present
Hi Denis,
Le lundi 24 août 2009 à 10:21:33, Denis BUCHER a écrit :
> > [...]
> > I suppose you have something like 'rma, import, ...' for search_path, so
> > it only displays rma.customers and not impor.customers.
>
> Yes that's correct. Therefore my "problem" is the "normal" behavior of
> \dt. Bu
Hello,
Guillaume Lelarge a écrit :
>> I have a strange problem since I moved some tables to a schema, some
>> tables are missing from the list (with \d or \dt) but they are still
>> present anyway ???!
>>
>> Example :
>>> $ psql mybase
>>> Bienvenue dans psql 8.1.17, l'interface interactive de
Hello Tom,
Tom Lane a écrit :
> Denis BUCHER writes:
>> I really don't understand what's happening here ?
>
> "\dt customers" will show you the customers table that's visible
> according to your search_path setting. Apparently schema "import"
> is either not in your search path at all, or behin
Le dimanche 23 août 2009 à 14:26:06, Denis BUCHER a écrit :
> Hello,
>
> I have a strange problem since I moved some tables to a schema, some
> tables are missing from the list (with \d or \dt) but they are still
> present anyway ???!
>
> Example :
> > $ psql mybase
> > Bienvenue dans psql 8.1.
Denis BUCHER writes:
> I really don't understand what's happening here ?
"\dt customers" will show you the customers table that's visible
according to your search_path setting. Apparently schema "import"
is either not in your search path at all, or behind "rma".
regards,
, 2009 8:55 AM
>> To: Wojtek
>> Cc: pgsql-general@postgresql.org
>> Subject: Re: [GENERAL] Strange "missing tables" problem
>>
>> Hello,
>>
>> That's what I found, do you see something inside that looks interesting ?
>>
>> bw_rma=# SELE
Hello,
Wojtek a écrit :
>> It's even more strange :
>>
> why, looks logical to me :)
>> # \dt customers
>>Liste des relations
>> Schéma | Nom | Type | Propriétaire
>> +-+---+--
>> rma| customers | table | postgres
>> (1 ligne)
>>
> yo
Denis BUCHER wrote:
Hello,
It's even more strange :
why, looks logical to me :)
# \dt customers
Liste des relations
Schéma | Nom | Type | Propriétaire
+-+---+--
rma| customers | table | postgres
(1 ligne)
you have 1 'customers' tabl
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Strange "missing tables" problem
>
> Hello,
>
> That's what I found, do you see something inside that looks interesting ?
>
> bw_rma=# SELECT * FROM pg_catalog.pg_class WHERE relname = 'customers';
Hello,
It's even more strange :
# \dt customers
Liste des relations
Schéma | Nom | Type | Propriétaire
+-+---+--
rma| customers | table | postgres
(1 ligne)
# \dt import.customers
Liste des relations
Schéma | Nom
Hello,
That's what I found, do you see something inside that looks interesting ?
bw_rma=# SELECT * FROM pg_catalog.pg_class WHERE relname = 'customers';
relname | relnamespace | reltype | relowner | relam | relfilenode |
reltablespace | relpages | reltuples | reltoastrelid | reltoastidxid |
relh
hi,
You may try checking:
SELECT * FROM pg_catalog.pg_class WHERE relname = 'customers'
SELECT * FROM pg_catalog.pg_tables WHERE tablename = 'customers'
to what's the status of your table.
Regards,
foo
Denis BUCHER wrote:
Hello,
Small correction to my previous email :
I have a strange pr
Hello,
Small correction to my previous email :
> I have a strange problem since I moved some tables to a schema, some
> tables are missing from the list (with \d or \dt) but they are still
> present anyway ???!
>
> Example :
>> $ psql mybase
>> Bienvenue dans psql 8.1.17, l'interface interac
Hello,
I have a strange problem since I moved some tables to a schema, some
tables are missing from the list (with \d or \dt) but they are still
present anyway ???!
Example :
> $ psql mybase
> Bienvenue dans psql 8.1.17, l'interface interactive de PostgreSQL.
> Saisissez:
> mybase=#
> bw_rma=
16 matches
Mail list logo
