LinuxQuestions.org
Visit Jeremy's Blog.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices


Reply
  Search this Thread
Old 06-14-2016, 12:39 PM   #1
mtdew3q
Member
 
Registered: Mar 2006
Location: the next town over from siberia
Distribution: xubuntu
Posts: 481

Rep: Reputation: 18
pgadmin doesn't list my postgresql tables


T
HI -
in schema public my tables aren't listed pgadmin III.

here is some diagnostic info.

postgres=# alter table employee set schema public;
ERROR: table employee is already in schema "public"

postgres=# \dt
List of relations
Schema | Name | Type | Owner
--------+----------+-------+---------
public | employee | table | blaster
public | phone | table | blaster

postgres=# select * from employee;
id | fname | lname
----+-------+-------
(0 rows)

How come pgadmin can't see my table but the command line
tools can see the table?

thx. for any assistance - jim
 
Old 06-14-2016, 01:14 PM   #2
mtdew3q
Member
 
Registered: Mar 2006
Location: the next town over from siberia
Distribution: xubuntu
Posts: 481

Original Poster
Rep: Reputation: 18
Hi-

I skipped over the message that warned me another package was required. installing contrib for linux postgres package and running the pgadmin as root and hitting fixit button solved the problem.

thx.!
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Postgresql and Relationships between tables and Primary keys. fuzzytom Linux - Newbie 1 10-25-2011 06:19 PM
pgadmin postgresql install HeyAZ Fedora 5 12-22-2009 02:40 PM
Newbie question about PostgreSQL, Schemas & Tables! justemail Linux - Newbie 3 05-27-2009 09:25 AM
Is there a forum for postgresql, pgadmin? g.ky73 Linux - Newbie 3 03-23-2009 04:43 PM
Populating tables in Postgresql rickh Linux - Software 11 03-02-2005 10:34 PM

LinuxQuestions.org > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 12:20 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration