#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    4
    Rep Power
    0

    PostgreSQL Help for Windows 7


    Hello

    I am new to PostgreSQL and have recently installed it on my Windows 7 machine.
    I am currently trying to use it, but am struggling a bit to understand some of the fields & options and was wondering if anyone knows whether there is a help site or manual aimed for Windows 7 Users? I have tried to Google and look on YouTube but am only able to find help for Linux users.

    The other question I have is whether it is better to use the PostgreSQL CLI or the GUI to create & alter databases? In other words do I have more options & more power using the CLI or is it purely a matter of choice which one I prefer to use?

    TIA
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,781
    Rep Power
    348
    Originally Posted by pgsqlnoob
    I am currently trying to use it, but am struggling a bit to understand some of the fields & options
    I have no idea which "fields and options" you mean.

    and was wondering if anyone knows whether there is a help site or manual aimed for Windows 7 Users?
    You did see the manual?

    http://www.postgresql.org/docs/curre...tic/index.html

    The other question I have is whether it is better to use the PostgreSQL CLI or the GUI to create & alter databases?
    I prefer plain SQL (but I use a GUI tool to run it). If with "GUI" you mean "pgAdmin" - then the answer is: I don't use that.

    A list of available tools is available in the in the Postgres Wiki: http://wiki.postgresql.org/wiki/Comm...eSQL_GUI_Tools
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
    http://forums.devshed.com/misc.php?do=bbcode#code

    Tips on how to ask better questions:
    http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    4
    Rep Power
    0
    Hi Shammat

    Thank you for the reply. Just to answer the questions you had:

    Originally Posted by shammat
    I have no idea which "fields and options" you mean.
    The "fields" I referred to I think was a bit ambiguous. I am referring to a few areas within PostgreSQL. The first is the FTS fields listed under schemas -> public. What is FTS Dictionary for example.
    The other "field" I was referring to was the different definitions one can put in a column. You have date[] & you have date. Just like integer[] & integer - what is the meaning of the square bracket after the variable and how does it make the definition differ from the one without the square brackets?

    Originally Posted by shammat
    You did see the manual?
    Yes I did and am reading through it - although it is going slowly.
    Quite a big manual, but thank you for pointing it out.

    Originally Posted by shammat
    I prefer plain SQL (but I use a GUI tool to run it). If with "GUI" you mean "pgAdmin" - then the answer is: I don't use that.
    Is it possible to use the SQL Pane to create Databases, Tables & Columns etc? or is that pane only read-only?
    If it is not available for use, is there a place in PGSQL that has an SQL pane which can accept SQL-like commands?

    Originally Posted by shammat
    A list of available tools is available in the in the Postgres Wiki:
    From this wiki list I use pgAdmin III.
    However the thing I would like to ask is that I have added packages to PGSQL via the stack builder application but decided to install these packages later. Now I cannot install them as I cannot find them. What do I need to do to install these downloaded packages? Do I go back into the stack builder and select to have these installed?
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,781
    Rep Power
    348
    Originally Posted by pgsqlnoob
    Is it possible to use the SQL Pane to create Databases, Tables & Columns etc? or is that pane only read-only?
    If it is not available for use, is there a place in PGSQL that has an SQL pane which can accept SQL-like commands?
    As I said: I don't use pgAdmin, but a quick look into the manual reveals this: http://www.pgadmin.org/docs/1.16/query.html

    Now I cannot install them as I cannot find them. What do I need to do to install these downloaded packages? Do I go back into the stack builder and select to have these installed?
    Sorry, I have no idea what you are talking about.
    Which packages exactly do you mean? Did you try "create exentension"? (http://www.postgresql.org/docs/curre...extension.html)
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
    http://forums.devshed.com/misc.php?do=bbcode#code

    Tips on how to ask better questions:
    http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Location
    Usually Japan when not on contract
    Posts
    240
    Rep Power
    12
    Originally Posted by pgsqlnoob
    only able to find help for Linux users.
    The kind of questions you have don't have anything to do with Windows, really, they are just basic Postgres questions. (...and the reason you can't find Windows-specific help is because nobody does development on Windows anymore, especially not for data -- but don't let that stop you from being a rebel)

    If you really want to get a grip on Postgres I strongly suggest that you head over to the Postgres docs and read them -- or at least skim the first three sections or so -- straight through. The goal isn't to memorize everything in one go, it is to familarize you with the vocabulary of the system, what features are available, and where to find things in the documentation.

    And don't use pgAdmin or anything like that, at least not yet. Use psql directly if you really want to get a firm understanding of things (not just Postgres, but data design in general). You'll find it lets you visualize in your mind, which is the only place it is possible to render complex data -- especially data that includes the time dimension.

    You'll find the path above much more rewarding than asking one-off questions in a forum and feeling hopeless unless someone comes along with the spare time to help you out.

IMN logo majestic logo threadwatch logo seochat tools logo