Skip site navigation (1) Skip section navigation (2)

psql

From: BPascal <pascal62fr(at)free(dot)fr>
To: pgsql-fr-generale(at)postgresql(dot)org
Subject: psql
Date: 2008-12-02 16:12:27
Message-ID: 49355E6B.4050601@free.fr (view raw or flat)
Thread:
Lists: pgsql-fr-generale
Bonjour,

Je veux créer des tables à l'aide de psql dans la base mabase d'owner 
mabase.


#su postgres
 > cd
 > psql < hclient.sql

La table est créée dans la base postgresql.
Finalement c'est normal, voici mon hclient.sql
comment ajouter la table dans la base mabase?


CREATE TABLE "HClient"
(
   "IdH_Client" serial NOT NULL,
   "HIdClient" integer,
   "HCliIdIdentite" integer,
   "HCliIdCharge" integer,
   "HServiceClient" character varying(128),
   "DateHistorique" timestamp without time zone,
   "IdIdentite" integer,
   CONSTRAINT "HClient_pkey" PRIMARY KEY ("IdH_Client")
)
WITH (OIDS=FALSE);
ALTER TABLE "HClient" OWNER TO mabase;



Merci
A+
-- 
Pascal




Responses

  • Re: psql at 2008-12-02 16:19:10 from Jean-Samuel Reynaud

pgsql-fr-generale by date

Next:From: Jean-Samuel ReynaudDate: 2008-12-02 16:19:10
Subject: Re: psql
Previous:From: David TokmatchiDate: 2008-12-02 15:40:34
Subject: Re: PostgreSQL 8. 1 et grosse volumétrie

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group