Обсуждение: pgadmin3 - Tables?

Поиск
Список
Период
Сортировка

pgadmin3 - Tables?

От
Douglas Eckert
Дата:
I have installed pgAdmin3 on my PC and run the msi installer file, but I do not see the tables anywhere.  Where might they have gone?

Also, previously I installed both PostgreSQL9.6 and pgAdmin4.  Do I need to remove them?  If so, how?  Will PostgreSQL9.6 work with pgAdmin3?  Also, my PC is a 64-bit system.  Is that a problem?  If so, how do I fix it?

It is 10:27 AM Eastern time.  I shall be here until about 11:00.  Then, I am returning at around 2PM.  Please contact me soon and let me know how to get back to you.

Thank you sincerely,

Doug

Douglas Eckert
Red Lion PA
(316) 461-2351

Re: pgadmin3 - Tables?

От
Melvin Davidson
Дата:
<div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace,
sans-serif;font-size:24px"><divid="yui_3_16_0_ym19_1_1470752832054_14192"><span
id="yui_3_16_0_ym19_1_1470752832054_14199">>...</span>butI do not see the tables anywhere.  Where might they have
gone?</div><divid="yui_3_16_0_ym19_1_1470752832054_14200"><div dir="ltr" id="yui_3_16_0_ym19_1_1470752832054_14202"><b
id="yui_3_16_0_ym19_1_1470752832054_14521">Youfirst have to <br /></b></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1470752832054_14219"><bid="yui_3_16_0_ym19_1_1470752832054_14520">1. Connect to the
server/cluster</b></div><divdir="ltr" id="yui_3_16_0_ym19_1_1470752832054_14277"><b
id="yui_3_16_0_ym19_1_1470752832054_14519">2.Expand Databases</b></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1470752832054_14278"><bid="yui_3_16_0_ym19_1_1470752832054_14518">3. Click on a database and
expandit<br /></b></div><div dir="ltr" id="yui_3_16_0_ym19_1_1470752832054_14296"><b
id="yui_3_16_0_ym19_1_1470752832054_14517">4.Click on Schemas and expand it</b></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1470752832054_14363"><bid="yui_3_16_0_ym19_1_1470752832054_14516">5. Click on the schema where
yourtables are.</b></div><div dir="ltr" id="yui_3_16_0_ym19_1_1470752832054_14419"><b
id="yui_3_16_0_ym19_1_1470752832054_14504">6.Click on Tables.</b></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1470752832054_14505"><bid="yui_3_16_0_ym19_1_1470752832054_14504"><br /></b></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1470752832054_14522"><bid="yui_3_16_0_ym19_1_1470752832054_14504">Also, it would be helpful if
youprovided exact PgAdmin version and O/S, otherwise, we cannot tell you how to remove anything.<br /></b></div><div
dir="ltr"id="yui_3_16_0_ym19_1_1470752832054_14564"><b id="yui_3_16_0_ym19_1_1470752832054_14504"><br /></b></div><div
dir="ltr"id="yui_3_16_0_ym19_1_1470752832054_14653"><b id="yui_3_16_0_ym19_1_1470752832054_14504">FYI, PostgreSQL 9.6
isstill Beta. You are better off using a supported release, ie: 9.5</b><br id="yui_3_16_0_ym19_1_1470752832054_14201"
/></div></div><divid="yui_3_16_0_ym19_1_1470752832054_14193"> </div><div class="signature"
id="yui_3_16_0_ym19_1_1470752832054_14043"><divid="RTEContent"><font id="yui_3_16_0_ym19_1_1470752832054_14316"
size="4"><spanid="yui_3_16_0_ym19_1_1470752832054_14317" style="font-weight:bold;font-family:arial;color:rgb(0, 0,
255);">MelvinDavidson </span></font><br /><font id="yui_3_16_0_ym19_1_1470752832054_14094" size="3"> </font><font
id="yui_3_16_0_ym19_1_1470752832054_14051"size="3" style="font-weight:bold;"><span
id="yui_3_16_0_ym19_1_1470752832054_14089"style="color:rgb(128, 0, 255);">I reserve the right to fantasize.  Whether or
notyou </span><br style="color:rgb(128, 0, 255);" /><span id="yui_3_16_0_ym19_1_1470752832054_14050"
style="color:rgb(128,0, 255);">wish to share my fantasy is entirely up to you. </span><img class=""
data-id="a41f8eee-0893-d76a-13da-1f493ab9ee14"id="yui_3_16_0_ym19_1_1470752832054_14670"
src="http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif"style="color:rgb(128, 0, 255);" /><br /></font><font
id="yui_3_16_0_ym19_1_1470752832054_14186"size="3"><span id="yui_3_16_0_ym19_1_1470752832054_14185"
style="font-weight:bold;font-family:courier;">FolkAlley - All Folk - 24 Hours a day </span><span
id="yui_3_16_0_ym19_1_1470752832054_14611"style="font-weight:bold;font-family:courier;"><br />www.folkalley.com<br
/><br/></span></font></div></div><div class="qtdSeparateBR" id="yui_3_16_0_ym19_1_1470752832054_14165"><br /><br
/></div><divclass="yahoo_quoted" id="yui_3_16_0_ym19_1_1470752832054_14169" style="display: block;"><div
id="yui_3_16_0_ym19_1_1470752832054_14168"style="font-family: Courier New, courier, monaco, monospace, sans-serif;
font-size:24px;"><div id="yui_3_16_0_ym19_1_1470752832054_14167" style="font-family: HelveticaNeue, Helvetica Neue,
Helvetica,Arial, Lucida Grande, sans-serif; font-size: 16px;"><div dir="ltr"
id="yui_3_16_0_ym19_1_1470752832054_14166"><fontface="Arial" id="yui_3_16_0_ym19_1_1470752832054_14430" size="2"><hr
id="yui_3_16_0_ym19_1_1470752832054_14445"size="1" /><b><span style="font-weight:bold;">From:</span></b> Douglas Eckert
<douglaseckertinpa@gmail.com><br/><b id="yui_3_16_0_ym19_1_1470752832054_14442"><span
id="yui_3_16_0_ym19_1_1470752832054_14441"style="font-weight: bold;">To:</span></b> pgadmin-support@postgresql.org <br
/><b><spanstyle="font-weight: bold;">Sent:</span></b> Tuesday, August 9, 2016 10:29 AM<br /><b><span
style="font-weight:bold;">Subject:</span></b> [pgadmin-support] pgadmin3 - Tables?<br /></font></div><div
class="y_msg_container"id="yui_3_16_0_ym19_1_1470752832054_14170"><br /><div id="yiv9397893285"><div dir="ltr"
id="yui_3_16_0_ym19_1_1470752832054_14171">Ihave installed pgAdmin3 on my PC and run the <span class="yiv9397893285"
id="yui_3_16_0_ym19_1_1470752832054_14172">msi</span> installerfile, but I do not see the tables anywhere.  Where might
theyhave gone?<div id="yui_3_16_0_ym19_1_1470752832054_14173"><br /></div><div
id="yui_3_16_0_ym19_1_1470752832054_14174">Also,previously I installed both PostgreSQL9.6 and pgAdmin4.  Do I need to
removethem?  If so, how?  Will PostgreSQL9.6 work with pgAdmin3?  Also, my PC is a 64-bit system.  Is that a problem? 
Ifso, how do I fix it?</div><div id="yui_3_16_0_ym19_1_1470752832054_14545"><br /></div><div
id="yui_3_16_0_ym19_1_1470752832054_14546">Itis 10:27 AM Eastern time.  I shall be here until about 11:00.  Then, I am
returningat around 2PM.  Please contact me soon and let me know how to get back to you.</div><div
id="yui_3_16_0_ym19_1_1470752832054_14549"><br/></div><div id="yui_3_16_0_ym19_1_1470752832054_14548">Thank you
sincerely,</div><divid="yui_3_16_0_ym19_1_1470752832054_14612"><br /></div><div
id="yui_3_16_0_ym19_1_1470752832054_14614">Doug<brclear="all" /><div id="yui_3_16_0_ym19_1_1470752832054_14618"><div
class="yiv9397893285gmail_signature"id="yui_3_16_0_ym19_1_1470752832054_14617"><div dir="ltr"
id="yui_3_16_0_ym19_1_1470752832054_14616"><divdir="ltr" id="yui_3_16_0_ym19_1_1470752832054_14615"><br /><div
id="yui_3_16_0_ym19_1_1470752832054_14619">Douglas<span class="yiv9397893285">Eckert</span></div><div
id="yui_3_16_0_ym19_1_1470752832054_14620">RedLion PA<br /></div><div id="yui_3_16_0_ym19_1_1470752832054_14621"><a
href="mailto:douglaseckertinpa@gmail.com"rel="nofollow" style="color:rgb(17,85,204);font-size:small;" target="_blank"
ymailto="mailto:douglaseckertinpa@gmail.com"><spanclass="yiv9397893285">douglaseckertinpa</span>@gmail.com</a><br
/></div><divid="yui_3_16_0_ym19_1_1470752832054_14622">(316) 461-2351</div><div
id="yui_3_16_0_ym19_1_1470752832054_14634"><br/></div></div></div></div></div></div></div></div><br /><br
/></div></div></div></div></div>

Re: pgadmin3 - Tables?

От
Melvin Davidson
Дата:
>..what is the server/cluster?
It is the instance of PostgreSQL that you have installed.
You can have multiple instances/copies of PostgreSQL on your PC,
each on a separate port #. If you only have one, it is usually on port 5432.
 
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com




From: Douglas Eckert <douglaseckertinpa@gmail.com>
To: Melvin Davidson <melvin6925@yahoo.com>
Sent: Tuesday, August 9, 2016 11:13 AM
Subject: Re: [pgadmin-support] pgadmin3 - Tables?

PS, what is the server/cluster?

Doug


Douglas Eckert, CMPE
760 Sterling Drive
Red Lion PA 17356
(717) 501-4053


On Tue, Aug 9, 2016 at 11:13 AM, Douglas Eckert <douglaseckertinpa@gmail.com> wrote:
Melvin:  Thanks.  I have to leave my home for a few hours, but I shall get back to you.  It looks like I shall have to remove PostgreSQL 9.6 and pgAdmin4.  When I get back, I shall try to reconnect with you to figure out how to proceed.

Thanks,
Doug


Douglas Eckert, CMPE
760 Sterling Drive
Red Lion PA 17356


On Tue, Aug 9, 2016 at 11:05 AM, Melvin Davidson <melvin6925@yahoo.com> wrote:
>...but I do not see the tables anywhere.  Where might they have gone?
You first have to
1. Connect to the server/cluster
2. Expand Databases
3. Click on a database and expand it
4. Click on Schemas and expand it
5. Click on the schema where your tables are.
6. Click on Tables.

Also, it would be helpful if you provided exact PgAdmin version and O/S, otherwise, we cannot tell you how to remove anything.

FYI, PostgreSQL 9.6 is still Beta. You are better off using a supported release, ie: 9.5
 
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com




From: Douglas Eckert <douglaseckertinpa@gmail.com>
To: pgadmin-support@postgresql.org
Sent: Tuesday, August 9, 2016 10:29 AM
Subject: [pgadmin-support] pgadmin3 - Tables?

I have installed pgAdmin3 on my PC and run the msi installer file, but I do not see the tables anywhere.  Where might they have gone?

Also, previously I installed both PostgreSQL9.6 and pgAdmin4.  Do I need to remove them?  If so, how?  Will PostgreSQL9.6 work with pgAdmin3?  Also, my PC is a 64-bit system.  Is that a problem?  If so, how do I fix it?

It is 10:27 AM Eastern time.  I shall be here until about 11:00.  Then, I am returning at around 2PM.  Please contact me soon and let me know how to get back to you.

Thank you sincerely,

Doug