Hi!
What about this?
(dirty hack, but worx)
#!/bin/bash
#sorry for syntax failures
tables_to_drop=`psql olddb -c "select * from pg_class where relkind =
'r' and name not like 'pg_%'"`;
for i in $tables_to_drop; do
psql newdb -c "drop table $i ";
done;
Of course it is very ri
Hi,
I'm using postgresql 7.2. While issuing the CLUSTER command on a table,
I got some notices telling me "drop would implicitly delete ...".
After the CLUSTER command, the table was like if was created again,
and the grants were not preserved.
The postgresql sql reference says "CLUSTER preserves
Hi,
I got a newsletter from www.techieindex.com
saying about PostgreSQL
Relational database management systems (RDBMS) may be the next field
to go open source, with fully SQL-compliant Ansi-(American National
Standards Institute) approved open source databases threatening to
enter the mainstream
Title: Delete accident
This is an almost embarrassing question, but I managed to delete all rows out of one of the tables by making a little typo in the WHERE statement.
Is there any way to restore these? the db was NOT vacuumed after that. but then, it wasn't backed up before either.
pleas
[EMAIL PROTECTED] (Steve Crawford) wrote in
news:[EMAIL PROTECTED]:
> IIRC I heard talk of new max and min array dimension functions in
> upcoming releases. I'm tired so there may be better or more elegant
> solutions but this one works (r is the array):
>
> r[rtrim(substring(array_dims(r), po
Not that it makes much of a difference, but i guess the following code
might work slightly better:
r[(substring(array_dims(r), strpos(array_dims(r), ':') + 1,
(length(array_dims(r)) - strpos(array_dims(r), ':')) - 1))::int]
Regards
Erwin Brandstetter
--
no z in my mail.
-
Hi all,
Ive got two databases, say full_db and sub_db.
sub_db is nothing but a subset of full_db.
What I would like to do is delete the data and tables
in sub_db from full_db. In essence, Im trying to
remove the redundant data and have distinct databases.
This is an attempt to archive the histor
Hi, everybody,
Please help me with an urgent problem.
I have PostgreSQL version: 7.3.1Alfa1 for Windows (the only Win version available)
I am training installation of ProgreSQL on various PC's WinNT, 2K, XP and 2003
installed. In some cases I've got such a problem (till now on W2K and W2003)
W
Eko Pranoto <[EMAIL PROTECTED]> writes:
> select datetime(now()) as result' LANGUAGE 'sql';
"datetime" isn't a standard type name anymore. Use "timestamp".
regards, tom lane
---(end of broadcast)---
TIP 4: Don't 'kill -9' t
On Wed, 1 Oct 2003, Eko Pranoto wrote:
> Hey folks..
> I have problem when upgrade from 7.2.1 to 7.3.4
> with function I create...
>
> How I can fix it ?
add this to template1 on the 7.3.4 database before importing into it:
create domain datetime as timestamptz;
---(en
On Wed, 2003-10-01 at 11:34, Gary Stainburn wrote:
> > In postgresql.conf:
> >
> > DATESTYLE = 'Postgres,European'
> When I did this, and then did 'service postgresql restart' the service failed
> to start.
> BTW, I'm running 7.2.3 from the RH RPMS.
The feature is available in 7.3
In 7.2 I see
On Wednesday 01 October 2003 11:13 am, Oliver Elphick wrote:
> On Wed, 2003-10-01 at 10:41, Gary Stainburn wrote:
> > I want to set the default date format to european dd-mm- format.
> >
> > Can someone tell me which file, and what I need to add.
>
> In postgresql.conf:
>
> DATESTYLE = 'Postgre
Gary Stainburn writes:
> I can remember that I used to do it by adding '-o -e' to the command line
> parameters but that was frowned upon a long time ago to be replaced by an
> entry in a config file (postgresql.conf?).
datestyle in postgresql.conf, starting in PostgreSQL 7.3. -o -e should
still
On Wed, 2003-10-01 at 10:41, Gary Stainburn wrote:
> I want to set the default date format to european dd-mm- format.
> Can someone tell me which file, and what I need to add.
In postgresql.conf:
DATESTYLE = 'Postgres,European'
--
Oliver Elphick[EMAIL PROTEC
Hi folks,
I'm kicking myself (gently) cos I can't remember/find how to do this.
I want to set the default date format to european dd-mm- format.
I can remember that I used to do it by adding '-o -e' to the command line
parameters but that was frowned upon a long time ago to be replaced by a
15 matches
Mail list logo
