Why does \dt *. show me a list of relations in psql but \dt not show me a list of tables in my postgreSQL database? -

i working on postgresql version 8.4.20. cannot upgrade because of work issue , existing databases running on it.

i have created schema looks this:

-- -- name: bug tracking; type: comment; schema: bugtrackingdb; owner: aa2_role --  comment on database bugtrackingdb 'ccdd viewer web application bug tracking db.';  --- create database bugtrackingdb;  create schema bugtracking authorization aa2;  create table bugtracking.issues (     issueid bigserial primary key,     issue varchar(50) not null  );  create table bugtracking.users (     id bigserial primary key,     issueid bigint not null unique references bugtracking.issues(issueid),     username varchar(25) not null );  create table bugtracking.opendate (     issueid bigint not null unique references bugtracking.issues(issueid),     dateopened date not null );  create table bugtracking.closedate (     issueid bigint not null unique references bugtracking.issues(issueid),     dateclosed date not null );  create table bugtracking.priority (     priorityid bigserial primary key,     issueid bigint not null unique references bugtracking.issues(issueid),     priority varchar(15) not null );  create table bugtracking.status (     statusid bigserial primary key,     issueid bigint not null unique references bugtracking.issues(issueid),     status varchar(20) not null );  create table bugtracking.comments (     commentid bigserial primary key,     issueid bigint not null unique references bugtracking.issues(issueid),     description text not null ); 

i still new postgresql , trying figure out, although familiar how databases work, trying figure out if doing correctly.

i have connected database, , have created schema, believe.

after creating schema in database psql returned series of notices like:

bugtrackingdb.sql:14: notice:  create table create implicit sequence "issues_issueid_seq" serial column "issues.issueid"  bugtrackingdb.sql:14: notice:  create table / primary key create implicit index "issues_pkey" table "issues" create table  bugtrackingdb.sql:20: notice:  create table create implicit sequence "users_id_seq" serial column "users.id"  bugtrackingdb.sql:20: notice:  create table / primary key create implicit index "users_pkey" table "users"  bugtrackingdb.sql:20: notice:  create table / unique create implicit index "users_issueid_key" table "users" create table 

my issue when run psql comand \dt view list of tables no relations found message.

however, when run \dt *. get:

                        list of relations        schema       |          name           | type  |  owner    --------------------+-------------------------+-------+----------  bugtracking        | closedate               | table | aa2  bugtracking        | comments                | table | aa2  bugtracking        | issues                  | table | aa2  bugtracking        | opendate                | table | aa2  bugtracking        | priority                | table | aa2  bugtracking        | status                  | table | aa2  bugtracking        | users                   | table | aa2 

does mean have created , ready run insert commands , select statements???

if tables not created, have working properly?

also, schema written correctly or there better way it?

why no relations found when run \dt???

this how create data model:

create schema bugtracking authorization aa2;  create table bugtracking.issues (     issueid bigserial not null unique primary key,     issue varchar(50) not null,      dateopened date not null,     dateclosed date,     type varchar(25) not null,     priority varchar(15) not null,     status varchar(20) not null,     comments text not null );  create table bugtracking.users (     id bigserial not null unique primary key,     issueid bigint not null unique references bugtracking.issues(issueid),     username varchar(25) not null ); 

this output getting.

bugtrackingdb=# insert bugtracking.issues (issue, dateopened, type, priority, status, comments) values ('test issue data', '20 jul 2017', 'logic error', 'low', 'not started', 'enter key needs acctuate login button when pressed.'); insert 0 1 bugtrackingdb=# select * bugtracking.issues issueid; issueid |      issue      | dateopened | dateclosed |    type     | priority |   status    |                        comments                         ---------+-----------------+------------+------------+-------------+----------+-------------+--------------------------------------------------------        1 | test issue data | 2017-07-20 |            | logic error | low      | not started | enter key needs acctuate login button when pressed. (1 row) 

think it, 1 user have many issues report each issue has 1 instance of each of columns.

just 2 cents. you're going kill writing million queries doing way.