All Questions
Tagged with postgresql-9.0 database
7 questions
10
votes
2
answers
224
views
Problematic nameless table in Postgresql
I actually don't know how I've done it : but I got a nameless table into my postgres DB. Needless to say that such a table is problematic, it doesn't get erased, neither could you change it in any way....
- 1,370
0
votes
2
answers
2k
views
Error in archive_command in Windows 7
I have done these steps:
Opened postgresql.conf
Set these parameters:
wal_level = archive
archive_mode =on
archive_command = ''copy %p \\\\192.168.1.10\\Archive\\wals\\%f''
Where 192.168.1.10 is my ...
- 518
3
votes
2
answers
2k
views
Postgres Join with LIKE
In PostgreSQL I have a table
tbl1
id -- RCODE -- COUNTRY --
1 US/MSR United states of America
2 GY/LSR Germany
3 CA/FSA Canada
tbl2
id -- Name -- CCODE
33 T1 US
44 ...
- 4,911
1
vote
1
answer
4k
views
sec_to_time() function in PostgreSQL?
MySQL has a cool function sec_to_time() which converts your number of seconds to hh:mm:ss
I've read through the mailing lists and am basically trying to implement the following:
MySQL:
select ...
- 4,723
25
votes
4
answers
74k
views
DATE_FORMAT in postgresql
I'm working in postgresql and I need to convert the date format in query itself,
in mysql there is option called DATE_FORMAT and I can use a query like this:
Select DATE_FORMAT(date_time, '%b %e, %Y, ...
- 4,723
2
votes
2
answers
4k
views
Exponential issue in postgresql
I'm facing an issue with the exponential function in postgresql. If I use this select statement select exp(5999), I'm getting:
ERROR: value out of range: overflow
SQL state: 22003
If I use this ...
- 4,723
2
votes
1
answer
2k
views
Replication of postgres database at table level
I am just wondering whether it would be possible to replicate only a table in a postgres database with another database instance. For example, lets say that I have a postgres instance running at hostA ...
