Bug#308553: psql does not return all relations on \d
Adam M wrote: That does not list them in a summary form, like just \d does. \dtv foo.* Anyway, I still consider this a bug, intended or not. I do not see any benefit in hiding relations in a given schema. After all, the summary displays which schema a given relation is in. The point is that if you don't specify a schema, you will only see those tables that you can access without a schema qualification. If you want to see all tables that you can access with schema qualification, then you specify that schema qualification in the \d command. I think that is perfectly reasonable. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#308553: psql does not return all relations on \d
Adam M. wrote: When the search_path is set to include more than one schema, and if two or more templates have the same relation, \d will only return the first instance of the relation. That is specifically intended that way. If you want to see the relations in a particular schema, use \d foo.*. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#308553: psql does not return all relations on \d
On 5/11/05, Peter Eisentraut [EMAIL PROTECTED] wrote: Adam M. wrote: When the search_path is set to include more than one schema, and if two or more templates have the same relation, \d will only return the first instance of the relation. That is specifically intended that way. If you want to see the relations in a particular schema, use \d foo.*. That does not list them in a summary form, like just \d does. Anyway, I still consider this a bug, intended or not. I do not see any benefit in hiding relations in a given schema. After all, the summary displays which schema a given relation is in. - Adam
Bug#308553: psql does not return all relations on \d
Package: postgresql-client Version: 7.4.7-6 Severity: normal When the search_path is set to include more than one schema, and if two or more templates have the same relation, \d will only return the first instance of the relation. For example, template1=# create database test; CREATE DATABASE template1=# \c test You are now connected to database test. test=# CREATE SCHEMA ts; CREATE SCHEMA test=# SET search_path=ts,public; SET test=# create table ts.test(); CREATE TABLE test=# create table public.test(); CREATE TABLE test=# \d List of relations Schema | Name | Type | Owner +--+---+-- ts | test | table | postgres (1 row) test=# set search_path=public; SET test=# \d List of relations Schema | Name | Type | Owner +--+---+-- public | test | table | postgres (1 row) It should list all relations on the search_path which includes public.ts and test.ts - Adam -- System Information: Debian Release: 3.1 APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Kernel: Linux 2.6.11-1-k7 Locale: LANG=en_CA.UTF-8, LC_CTYPE=en_CA.UTF-8 (charmap=UTF-8) Versions of packages postgresql-client depends on: ii debconf [debconf-2.0] 1.4.49 Debian configuration management sy ii debianutils 2.13.2 Miscellaneous utilities specific t ii libc6 2.3.2.ds1-21 GNU C Library: Shared libraries an ii libkrb531.3.6-3 MIT Kerberos runtime libraries ii libpam0g0.76-22 Pluggable Authentication Modules l ii libpq3 7.4.7-6 PostgreSQL C client library ii libreadline44.3-15 GNU readline and history libraries ii libssl0.9.7 0.9.7e-3 SSL shared libraries ii zlib1g 1:1.2.2-4compression library - runtime -- debconf information: postgresql-client/missing-postgresql.env: true -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]