Search:

Type: Posts; User: shammat; Keyword(s):

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    10
    Views
    6,587

    As I have written: it is a commercial product,...

    As I have written: it is a commercial product, but it's not very expensive
  2. Replies
    10
    Views
    6,587

    DbSchema is pretty good and not too expensive. ...

    DbSchema is pretty good and not too expensive.

    https://www.dbschema.com/index.html
  3. Replies
    6
    Views
    7

    Just to make sure we are not missing the obvious:...

    Just to make sure we are not missing the obvious: you are editing that in postgresql.conf, right?

    Please post the content of the logfile in case the startup fails.
  4. Replies
    6
    Views
    7

    So you get the [FAILED] when restarting the...

    So you get the [FAILED] when restarting the service, but no error message in either log file? That sounds strange. If there is any error with the config files, it should be reported in the logfiles....
  5. Replies
    6
    Views
    7

    Do you see any errors in the Postgres logfile? ...

    Do you see any errors in the Postgres logfile?

    If yes, which one?
  6. Replies
    1
    Views
    584

    Your column is an array, not a varchar. Which...

    Your column is an array, not a varchar. Which element of the array do you want to use?

    Also: it's Postgres or PostgreSQL - there is no capital G in the name
  7. Replies
    2
    Views
    393

    That is not going to work. Storing binary data...

    That is not going to work.

    Storing binary data in a text column is always going to fail due to character set conversion applied to the data.

    You need to declare that column as bytea, otherwise...
  8. There is no such thing as "PostGre". It's either...

    There is no such thing as "PostGre". It's either Postgres or PostgreSQL
    You might want to read this:...
  9. Just update to that version. If you are using...

    Just update to that version. If you are using Linux, your package manager (yum, apt, rpm) will do that automatically.

    Quote from: https://www.postgresql.org/support/versioning/


    E.g.: yum...
  10. No there is no such feature. And it's really not...

    No there is no such feature. And it's really not needed. The order of columns in a table is meaningless. you can always re-order them through a view or simply in the query you are using.
  11. Replies
    2
    Views
    1,667

    Out of the box, Postgres only supports only hot...

    Out of the box, Postgres only supports only hot standby but the standby can be used for queries.

    So you can distribute read-queries across a cluster of hot standby servers (e.g. using pgBouncer)....
  12. Please show us the real execution plan. ...

    Please show us the real execution plan.
    Pre-formatted text please using [code] tags otherwise the very important indention is los.
  13. I don't understand the question: now() is a...

    I don't understand the question: now() is a timestamp.

    See here: https://www.postgresql.org/docs/current/static/datatype-datetime.html
    and here:...
  14. What are you trying to do with that? What is the...

    What are you trying to do with that? What is the expected integer value for "2017-07-16 19:42"?
    And why are you storing a "timestamp" as a integer and not as a proper timestamp?
  15. Replies
    4
    Views
    298

    You probably want to configure "trust" or "md5"...

    You probably want to configure "trust" or "md5" authentication for that user:

    https://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html
  16. Replies
    4
    Views
    298

    What is the exact error message you get when you...

    What is the exact error message you get when you try to restore the dump?

    Can you connect using psql?
  17. Replies
    2
    Views
    198

    psql --help psql is the PostgreSQL interactive...

    psql --help
    psql is the PostgreSQL interactive terminal.

    Usage:
    psql [OPTION]... [DBNAME [USERNAME]]

    General options:
    ...

    Input and output options:
  18. Replies
    2
    Views
    241

    https://www.postgresql.org/docs/current/static/bac...

    https://www.postgresql.org/docs/current/static/backup-dump.html
  19. You don't need to convert it. Create the new...

    You don't need to convert it.

    Create the new database with UTF-8 and simply run the dump file through psql. Postgres will take care of the conversion
  20. In Oracle you have two way to convert a varchar...

    In Oracle you have two way to convert a varchar to a number. to_number() (as already mentioned) and the CAST operator: cast ('-1' as number)

    See the manual for details:...
  21. I have no idea what the second parameter to...

    I have no idea what the second parameter to NUMERIC is doing in Netezza, but to convert a varchar to a number you use to_number() in Oracle:
    ...
  22. You need to use the recursive keyword and use the...

    You need to use the recursive keyword and use the standard SQL concatenation operator ||:


    with recursive edges as (
    select t1.company as node1, t2.company as node2
    from table1 t1 join
    ...
  23. You can't operate on a CSV file without making it...

    You can't operate on a CSV file without making it available in the database server.

    You can do this in two ways: either by using a foreign data wrapper (through file_fdw) or by simply importing...
  24. There is no problem. A sequence is expected to...

    There is no problem. A sequence is expected to skip values. There is nothing wrong with that.

    If you rely on a gapless numbering, then a sequence is the wrong choice.
  25. Replies
    1
    Views
    412

    And what does this have to do with the Oracle...

    And what does this have to do with the Oracle database?

    You should be asking this in a Solaris forum.
Results 1 to 25 of 182
Page 1 of 8 1 2 3 4