please
I have an application developed with my-sql , but iI want to migrate it to postgress.
What
can my do
Thanks
--
Lambert SONNA MOMO
Anyone know how to create auto incrementing fields?
--
Harry
[EMAIL PROTECTED]
http://www.doc.ic.ac.uk/~hw97/Nojer2
Nojer2 on chat.yahoo.com and zapidonia.com
ICQ number 18519769
ALTER USER postgres WITH PASSWORD '[enter password]'
http://www.postgresql.org/users-lounge/docs/7.0/user/sql-alteruser.htm
- Original Message -
From: "Leon van Dongen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 18, 2000 1:56 AM
Subject: [GENERAL] newbie question
Use the column type of SERIAL in your create table statement. This will
automatically create a sequence and default for the given column.
http://www.postgresql.org/users-lounge/docs/7.0/user/sql-createsequence.htm
for more on sequences.
- Original Message -
From: "Harry Wood" <[EMAIL P
On Tue, 19 Dec 2000, Harry Wood wrote:
> Anyone know how to create auto incrementing fields?
create sequence my_seq;
create table my_table (
my_id integer primary key default nextval('my_seq'),
another_field varchar(10),
...
);
OR, you can create an implicit sequence:
Harry Wood wrote:
>
> Anyone know how to create auto incrementing fields?
>
> --
> Harry
> [EMAIL PROTECTED]
> http://www.doc.ic.ac.uk/~hw97/Nojer2
> Nojer2 on chat.yahoo.com and zapidonia.com
> ICQ number 18519769
CREATE TABLE test (
teste_id SERIAL PRIMARY KEY,
namevarch
carolina writes:
> Can Postgres run in Windows 95 or Windows 98?
No. (You can compile the client library on Windows 95/98, but that's it.)
You can run PostgreSQL on Windows NT using the Cygwin toolkit, but getting
that to work can sometimes be a final project as well.
My advice would be to fi
Somebody knows how to get a sql "schema" of a Postgresql database??
Thanks!!
Gerardo Tagliani
Linux Registred User #139437
---
FREE! The World's Best Email Address @email.com
Reserve your name now at http://www.email.com
On Tue, Dec 19, 2000 at 12:51:26PM -0500, gerardo tagliani wrote:
> Somebody knows how to get a sql "schema" of a Postgresql database??
pg_dump -s -d
--
Adam Haberlach|A cat spends her life conflicted between a
[EMAIL PROTECTED] |deep, passionate, and profound desire for
htt
> You can run PostgreSQL on Windows NT using the Cygwin
> toolkit, but getting
> that to work can sometimes be a final project as well.
I disagree. Using the instructions on
http://people.freebsd.org/~kevlo/postgres/portNT.html it is almost a
no-brainer.
Joost Kraaijeveld
Askesis B.V.
Molukkenst
At 12:51 19/12/00 -0500, gerardo tagliani wrote:
>Somebody knows how to get a sql "schema" of a Postgresql database??
>
>Thanks!!
pg_dump -s databasename
--
thorNET - Internet Consultancy, Services & Training
Phone: 01454 854413
Fax: 01454 854412
http://www.thornet.co.uk
At 10:04 19/12/00 -0800, Adam Haberlach wrote:
>On Tue, Dec 19, 2000 at 12:51:26PM -0500, gerardo tagliani wrote:
>> Somebody knows how to get a sql "schema" of a Postgresql database??
>
>pg_dump -s -d
>
No.
-d does something to the INSERT strings
--
thorNET - Internet Consultancy, Services
El Mar 19 Dic 2000 10:29, Nick Fankhauser escribió:
> I believe it has to be each table- Oracle has a nice "all tables" option
> which might be worth the developer's consideration on the next round. I
> need to do this regularly, so I'll probably see if I can write a tool to
> create a SQL script.
I have a linux instalation (from rpm) of postgres-7.0.3, which puts the logs
of the server (AFAIK) in /var/log/postgresql.
But the file is empty, and I start making activity on the database and it
stays empty. Does anyone have an idea of what is happening?
Also, on a Solaris 8 machine, compiled
I have a table with columns
datetime timestamp,
valuefloat(8)
I want to delete rows 10 days older or 10 hours older by
delete from tablename where datetime < TODAY-10;
or
delete from tablename where datetime between CURRENT-10 and CURRENT;
So are there key words TODAY, CURRENT in Pos
On Tue, 19 Dec 2000, Joseph wrote:
> $dbh=DBI->connect("dbi:Pg:dbname=$dbname",$dbusername,$dbpassword) or die "can
I would assume that if you never disconnect and are running under
mod_perl, you will have problems.
Hi Raymond,
You might try something like this:
DELETE FROM tablename WHERE datetime < ('now'::timestamp - '10
days'::interval);
and
DELETE FROM tablename WHERE datetime BETWEEN ('now'::timestamp - '10
hours'::interval) AND 'now'::timestamp;
If you just want the date stamp, you can use 'now'::da
On Tue, Dec 19, 2000 at 10:37:42AM -0500, Raymond Chui wrote:
> delete from tablename where datetime < TODAY-10;
delete from tablename where datetime < timestamp 'now' - interval '10 days';
or
delete from tablename where age(datetime) > '10 days';
--
Mike Castle Life is like a cl
Hi all,
I'm pretty new in PostgreSQL and I have some problems and
questions. I'll list them here, maybe someone can help me :)
1) I wanted to use a binary type. I've seen in some place a
type called bytea which I can use, but I cannot use it
as a primary key. Is that possible somehow or with ano
Hi, all
Anobody could tell-me how can I make a Trigger thats execute some things
whith "postgres" superuser privileges (like INSERT INTO a table that the
user logged in don't have access)
regards,
Tulio Oliveira
--
==
AKACIA TECNOLOGIA
Des
I need to insert a bunch of records in a transaction. The transaction must
not abort if the a duplicate is found.
I know I have seen the syntax for the before. Can someone jog my memory?
Bryan White, ArcaMax.com, VP of Technology
The avalanche has already begun.
It is too late for the pebbles
> Anobody could tell-me how can I make a Trigger thats execute some things
> whith "postgres" superuser privileges (like INSERT INTO a table that the
> user logged in don't have access)
I think triggers should run with table-owner user permissions. That way you
could have a table owned by superus
> > Soma> All values called from the database are still padded with
> > Soma> extra spaces from the column size in the database. Is this
> > Soma> normal - I don't remember this happening when I was using
> > Soma> MySQL. I thought usually the database stripped the extra
> > S
Tom Lane wrote:
>"Johann Woeckinger" <[EMAIL PROTECTED]> writes:
>> But when using a Tcl-based interface (e.g. pgaccess or home made tcl
>> based programs) to insert such characters into a table, they are not corre
>ct
>> displayed on queries by use of psql - they appear as two 'un
Just recently added this functionality to phpPgAdmin. You can now update
the ACL of all the objects (tables, sequences, views) of a database at the
same time.
This will be part of the next release (2.2.1) which should happen this week
sometime. Look for the announcement.
-Dan
- Original M
Help me for "DBI->connect failed: Sorry, too
many clients already."my cgi program is
test.cgi:###require
"./connectdb.pl";&connectdatabase();$query="select count(*) from
messages";$sth=$dbh->prepare($query);$sth->execute();$count=$sth->fetchrow_array();print
"Content-typ
my cgi program is
test.cgi:###require
"./connectdb.pl";&connectdatabase();$query="select count(*) from
messages";$sth=$dbh->prepare($query);$sth->execute();$count=$sth->fetchrow_array();print
"Content-type: text/html\n\n";print
<<"TAG"; The count is
$count. TAGexit
0;#
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> According to "Postgres: Introduction and Concepts", varchar is slower
> than char. So if you (like me) want to use char and get rid of the
> padding spaces, you may use a regex replacement, as in
> while (@row=$result->fetchrow)
> {
On Wed, Dec 20, 2000 at 10:35:01AM +1100, Mark Cowlishaw wrote:
> > According to "Postgres: Introduction and Concepts", varchar is slower
> > than char. So if you (like me) want to use char and get rid of the
> > padding spaces, you may use a regex replacement, as in
> >
> > while (@row=$r
29 matches
Mail list logo
