Results 1 through
10
while searching for:
"postgresql"
How do you rename a PostgreSQL sequence?
You rename a sequence (a sequence is really a table) like this:
psql# ALTER TABLE tbl_foo_col_seq RENAME TO tbl_bar_col_seq;
If you want to change the sequence used to auto increment a field, do this:
psql# ALTER TABLE tbl_foo ALTER COLUMN
[...]
http://rockfloat.com/board/post/?id=553
December 31, 2006 @22:08
(Replies: 0)
(Rank: 0.061)
postgresql
How do you format a date or datetime object in PostgreSQL or Oracle?
Try this for PostgreSQL:
SELECT TO_CHAR(NOW(), 'DD/MM/YYYY HH:MI:SS');
Oracle:
SELECT TO_CHAR(sysdate, 'DD/MM/YYYY HH:MI:SS') FROM DUAL;
John M.
http://rockfloat.com/board/post/?id=600
October 15, 2008 @01:13
(Replies: 0)
(Rank: 0.061)
postgresql
How do you fix this problen: ERROR: could not find tsearch config by locale
Try this as a temporary fix (see reference below for more detail):
database=# SHOW lc_collate;
database=# UPDATE pg_ts_cfg SET locale = 'en_US.UTF-8' WHERE ts_name = 'default';
REFERENCE:
http://people.planetpostgresql.org/xzilla/index.php?/a
[...]
http://rockfloat.com/board/post/?id=564
April 01, 2007 @18:21
(Replies: 0)
(Rank: 0.061)
postgresql
How do you generate a schema diagram, or ER diagram of a database?
You can do this using the following two tools
1. PostgreSQL Autodoc
2. dot
Here's the quick and dirty howto (on gentoo):
user# sudo emerge -a graphviz
user# wget http://www.rbt.ca/autodoc/binaries/postgresql_autodoc-1.25.tar.gz
user# tar
[...]
http://rockfloat.com/board/post/?id=519
May 05, 2006 @16:59
(Replies: 0)
(Rank: 0.061)
postgresql
How do you execute an sql file from within the psql subsystem?
Like this:
user# psql -U postgres your-database
your-database=# \i '/path/to/file.sql'
John M.
http://rockfloat.com/board/post/?id=527
July 01, 2006 @15:04
(Replies: 0)
(Rank: 0.061)
postgresql
How do you enable logging per user/role/db?
Try:
ALTER USER foo SET log_statement to 'all';
ALTER USER foo SET log_line_prefix to '<%u@%h>';
See:
http://www.postgresql.org/docs/current/static/runtime-config-logging.html
John M.
http://rockfloat.com/board/post/?id=531
July 23, 2006 @17:49
(Replies: 0)
(Rank: 0.061)
postgresql
how do you insert live data from postgres into an openoffice spreadsheet?
first you need to prep openoffice for postgresql, I recommend my tutorial on the subject:
http://rockfloat.com/howto/openoffice-postgresql.html
- open new openoffice calc document
- Menu : Data : DataPilot : Start
- Data source registered in
[...]
http://rockfloat.com/board/post/?id=364
January 06, 2004 @02:29
(Replies: 0)
(Rank: 0.061)
postgresql
Looking for a good PostgreSQL cheat sheet?
http://www.petefreitag.com/cheatsheets/postgresql/
http://rockfloat.com/board/post/?id=40
September 09, 2005 @05:53
(Replies: 0)
(Rank: 0.061)
postgresql
How do you fix: authdaemond: could not translate host name "pgsql.example.com"?
In Gentoo land, this means you emerged net-libs/courier-authlib with the "postgres" use flag enabled. Courier's authentication logic essentially looks to several "data stores" to use for authentication. The problem is that you're rig thinks it shou
[...]
http://rockfloat.com/board/post/?id=539
September 30, 2006 @02:47
(Replies: 0)
(Rank: 0.061)
postgresql
How do you add something to the default runlevel on Ubuntu?
Try something like:
# See what's there now (there is a better way I'm sure)
user# tree -fi /etc | grep -E 'rc[0-9]+.d' | grep postgres
# Remove from the default runlevels
user# sudo update-rc.d -f postgresql-8.3 remove
# Put it back to the
[...]
http://rockfloat.com/board/post/?id=596
July 26, 2008 @00:23
(Replies: 0)
(Rank: 0.000)
