Hi !
One of our customers has an MS Access DB (I think..)
He sent me a .mdb file.
Does anyone knows a way to convert this to postgreSQL db ?
thank you !
EuroVox
4, place Flix Eboue
75583 Paris Cedex 12
Tel : 01 44 67 05 05
Fax :
On Mon, 26 Mar 2001, bswiatek wrote:
Assuming you're doing these in this order, this can't
succeed. LECZENIE referenes WIZYTY which isn't
created yet as do some other tables, which causes
those tables not to exist later when you reference
them. If you want to make circular trees of
You can use some conversion tools that can be found on www.greatbridge.org
I've used PgAdmin (windows only) to convert MS Access files to PostgreSQL.
Poul L. Christiansen
On Tue, 27 Mar 2001, Jean-Arthur Silve wrote:
Hi !
One of our customers has an MS Access DB (I think..)
He sent me
On Tue, Mar 27, 2001 at 03:58:39PM +0200, Christian Marschalek wrote:
Pg DOES support it!
Oh... My fault :o)
However, it doesn't really have anything
to do with data redundancy. Data redundancy means storing
the same DATA in more than one table meaning that if it
changes in one
On Tue, Mar 27, 2001 at 09:52:05AM -0500, Bruce Momjian wrote:
On Mon, 26 Mar 2001 15:07:37 + (UTC), Mark Hamby
[EMAIL PROTECTED] wrote:
Here's a patch for a \cd (change dir) command in psql program.
It's very small and only adds a few lines.
Personally, I am surprised psql
will trillich writes:
and with it i'd imagine we'll also need
# return to previous directory, for the lazy
\cd -
# show current working directory
\cwd
\pwd
You can do this with
\!pwd
(Of course \!cd won't do what you want. This situation is similar to an
On Tue, 27 Mar 2001 [EMAIL PROTECTED] wrote:
Hi
Could someone tell me where I can download PostgreSQL for Windows and
MacOS from HTTP site other than ftp site, since the proxy server won't
allow me go to the ftp site?
Looking forward to your reply!
Yeah, I put a link up for this.
Oh yeah we've learned about the normal forms too :) It's all flying back
into my mind right now ;o)
Thx!
-Original Message-
From: Gregory Wood [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 5:04 PM
To: Christian Marschalek
Subject: Re: Supertypes?
Well we've
I am seeing something kinda weird when I am creating tables (or viewing
existing ones):
BEGIN SESSION
bash$ createdb test
CREATE DATABASE
bash$ psql test
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\?
Hello All,
I am writing my first C function for postgres and failing miserably. my C
function needs to get passed a username (char) , uid(int), and gid(int) and
what it does with those is builds a command string for an external app that
is called with system() and exits 0. I know this is
Patrick Aland writes:
test=# \dt
No relations found.
test=# CREATE TABLE mytable (
test(# id INT,
test(# stuff VARCHAR(10)
test(# );
CREATE
test=# \dt
List of relations
Name | Type | Owner
-+---+--
mytable | table | gmguest
mytable | table |
* Joel Dudley [EMAIL PROTECTED] [010327 11:29] wrote:
Hello All,
I am writing my first C function for postgres and failing miserably. my C
function needs to get passed a username (char) , uid(int), and gid(int) and
right, wrong and wrong.
char *, uid_t, gid_t.
--
-Alfred Perlstein -
Joel Dudley writes:
PG_FUNCTION_INFO_V1(ssh_exec);
Datum
ssh_exec(PG_FUNCTION_ARGS)
{
char sshcmd[255];
strncpy(sshcmd, "/usr/local/bin/plsshexec ", 255);
strncat(sshcmd, *uname, 255);
strncat(sshcmd, " ", 255);
strncat(sshcmd, *uid, 255);
Joel Dudley [EMAIL PROTECTED] writes:
what it does with those is builds a command string for an external app that
is called with system() and exits 0. I know this is strange and ugly but I
need to trigger this external app when an insert is made into a user table.
This seems an extremely
hi,
maybe this is somewhere in the docs but I couldn't find
it.
I am a beginner to postgresql and do not know much till now.
I have bought a book on SQL and now I want to
import the sample databases into postgresql
they are provided as *.sql.
in MySQL I can type something like in Bash on my
On Tue, Mar 27, 2001 at 09:42:39PM +, markus jais wrote:
hi,
maybe this is somewhere in the docs but I couldn't find
it.
I am a beginner to postgresql and do not know much till now.
I have bought a book on SQL and now I want to
import the sample databases into postgresql
they are
I believe that what you are looking for is
inheritance.
http://postgresql.readysetnet.com/devel-corner/docs/user/inherit.html
I hope this is helpful,
Jason Earl
--- Christian Marschalek [EMAIL PROTECTED] wrote:
In school we've learned about supertypes. I don't
know if the raw
translation is
Is there any way to have the server log the queries that are coming in so I
can see what's actually getting processed?
Start the postmaster with "-d 2" on the command line.
--
Alex Howansky
Wankwood Associates
http://www.wankwood.com/
---(end of
Back in the old days of 6.x, the use of alternate database locations (for
example, by defining $PGDATA2 wherever I wanted it to be located) didn't
work. This was scheduled to be fixed in 7.x. Has it?
I want to use postgres as the attribute-storing dbms for my GRASS (GIS)
projects. What I'd
Hello all,
I am having a bit of trouble getting my arguments formatted into a
command string for system(). Here is what I have so far for code.
#include string.h
#include stdlib.h
#include "postgres.h"
#include "fmgr.h"
PG_FUNCTION_INFO_V1(ssh_exec);
Datum
ssh_exec(PG_FUNCTION_ARGS)
{
On Tue, Mar 27, 2001 at 03:45:17PM -0700, Joel Dudley wrote:
Hello all,
I am having a bit of trouble getting my arguments formatted into a
command string for system(). Here is what I have so far for code.
#include string.h
#include stdlib.h
#include "postgres.h"
#include "fmgr.h"
This seems pretty out-of-date, since we seem to have had a 'CREATE GROUP' command
for as long as I can remember -- are there any more accurate docs out there?
How would I go about updating them?
http://www.postgresql.org/users-lounge/docs/7.0/postgres/security17760.htm
/***/
Currently, there
Adam Haberlach [EMAIL PROTECTED] writes:
This seems pretty out-of-date, since we seem to have had a 'CREATE GROUP' command
for as long as I can remember -- are there any more accurate docs out there?
How would I go about updating them?
On Tue, 27 Mar 2001, Adam Haberlach wrote:
This seems pretty out-of-date, since we seem to have had a 'CREATE GROUP' command
for as long as I can remember -- are there any more accurate docs out there?
How would I go about updating them?
24 matches
Mail list logo