On Tue, 13 Jul 2004, evgeny tsurkin wrote:
> Hi All!
> That probably was already asked thousand times
> but i did not find an exact answer:
> I want to have two tables the second one will have
> all the columns from the first + some extra .The data
> should be complittly separate .I was trying to
On Wed, 2004-07-14 at 06:04, Claudia Dantas Procopio wrote:
> Hello,
>
> I have a problem. When I write "/usr/local/pgsql/bin/createdb
> producao" is showed ther error:
> "ld.so.1: /usr/local/pgsql/bin/psql: fatal: libgcc_s.so.1: open
> failed: No such file or directory
> Killed
> createdb: datab
I am but that is what actually want : to be able to add a column
to the first table and have the second to be added a coulumns
automatically.The target is realy simple :
i want to simplify management of the schema and thus be able to
manage only parantes - children should be managed aoutomagically
I am but that is what actually want : to be able to add a column
to the first table and have the second to be added a coulumns
automatically.The target is realy simple :
i want to simplify management of the schema and thus be able to
manage only parantes - children should be managed aoutomagically
Hi,
Is it possible to know the number of users connected
to a database ?
Regards
On Sun, 2004-07-18 at 20:52, Randall Perry wrote:
> This is a pain. Couldn't we gave something simple like
> GRANT ALL ON database.* TO JOE;
>
> Which would grant full access to all objects in the database to JOE for all
> time?
You can do it like this in psql:
\a
\t
\o /tmp/grant.sql
SELECT
We had an accident with a table where all tuples
where deleted. We have not run VACUUM yet and it seems like the datas are in
place in the base directory. Our backup were not
active when this happened.
I have seen some talk about that it is possible to
restore those missing data in this case
Hello,
I have a problem. When I write
"/usr/local/pgsql/bin/createdb producao" is showed ther
error:
"ld.so.1: /usr/local/pgsql/bin/psql: fatal: libgcc_s.so.1: open
failed: No such file or directoryKilledcreatedb: database creation
failed"
Thank you.
Claudia Dantas ProcópioEmbrapa Alg
This is a pain. Couldn't we gave something simple like
GRANT ALL ON database.* TO JOE;
Which would grant full access to all objects in the database to JOE for all
time?
> Ulrich Meis wrote:
>> 1. Write a script that queries the postgres internal tables for all
>> tables,schemas,sequences,views,fu
Thanks very much to all.
Dario.
Patrice Trognon wrote:
Hi,
If you have blobs you must split your SQL_ASCII to convert it
with iconv.
I export my full database.
I create a new SQL_ASCII database with only tables that don't
contains blobs. (db_without_blobs)
I create a new SQL_ASCII database with onl
Hi,
If you have blobs you must split your SQL_ASCII to convert it
with iconv.
I export my full database.
I create a new SQL_ASCII database with only tables that don't
contains blobs. (db_without_blobs)
I create a new SQL_ASCII database with only tables that contains
blobs. (db_with_blobs)
Export
Ð ÐÑÐ, 18.07.2004, Ð 01:34, Dario V. Fassi ÐÐÑÐÑ:
> Tom Lane wrote:
> > "Dario V. Fassi" <[EMAIL PROTECTED]> writes:
> >
> > > A simple question, we need to migrate many (>20) postgres databases from
> > > SQL_ASCII encoding to UNICODE encoding, over a 7.3.6 server.
> > >
> > SQL_ASCII is
12 matches
Mail list logo
