Thread: Ocaml as a Postgresql Procedural Language?
I thought I saw somewhere a project to use Ocaml as a Procedural Language in Postgresql (so that you can write triggers and stored procedures in Ocaml), but I can't find this project at the moment. Does anyone know what happened to it, and wether the code is available anywhere? Thanks. Brian
Hi, In sqlite with SELECT * FROM sqlite_master WHERE table='a' I can obtain the complete CREATE TABLE ... commands, Wich is the equivalent in PostgeSQL ? I've been trying information_schema.tables without success ... thanks! raimon fernandez for example: for table 'comptes' I want to retrieve this: create table public.comptes( "codi_empresa" char(2) not null , "codi_compte" varchar not null , "comptes" varchar not null , "tipus" char(2) not null , "clau_compte" char(13) not null , "saldo_deure" numeric(12,2) not null , "saldo_haver" numeric(12,2) not null , "nivell" int2 not null , "saldo" numeric(12,2) not null , "ultim_moviment" date not null , "codi_437" int2 not null ) WITH OIDS; ALTER table "public"."comptes" OWNER TO "postgres"; ALTER table "public"."comptes" SET WITHOUT CLUSTER; alter table "public"."comptes" add primary key(clau_compte); create index "clau_compte1" on "public"."comptes" using btree (clau_compte) ; create index "comptes1" on "public"."comptes" using btree(comptes) ; create index "nivell" on "public"."comptes" using btree(nivell) ;
This works fine: SELECT COLUMN_NAME, CHARACTER_MAXIMUM_LENGTH, DATA_TYPE FROM information_schema.columns WHERE TABLE_NAME = Hope it helps Mike -----Original Message----- From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Raimon Fernandez Sent: Tuesday, May 15, 2007 7:29 AM To: pgsql-novice@postgresql.org Subject: [NOVICE] how to retrieve table definition Hi, In sqlite with SELECT * FROM sqlite_master WHERE table='a' I can obtain the complete CREATE TABLE ... commands, Wich is the equivalent in PostgeSQL ? I've been trying information_schema.tables without success ... thanks! raimon fernandez for example: for table 'comptes' I want to retrieve this: create table public.comptes( "codi_empresa" char(2) not null , "codi_compte" varchar not null , "comptes" varchar not null , "tipus" char(2) not null , "clau_compte" char(13) not null , "saldo_deure" numeric(12,2) not null , "saldo_haver" numeric(12,2) not null , "nivell" int2 not null , "saldo" numeric(12,2) not null , "ultim_moviment" date not null , "codi_437" int2 not null ) WITH OIDS; ALTER table "public"."comptes" OWNER TO "postgres"; ALTER table "public"."comptes" SET WITHOUT CLUSTER; alter table "public"."comptes" add primary key(clau_compte); create index "clau_compte1" on "public"."comptes" using btree (clau_compte) ; create index "comptes1" on "public"."comptes" using btree(comptes) ; create index "nivell" on "public"."comptes" using btree(nivell) ; ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
bhurt@janestcapital.com (Brian Hurt) writes: > I thought I saw somewhere a project to use Ocaml as a Procedural > Language in Postgresql (so that you can write triggers and stored > procedures in Ocaml), but I can't find this project at the moment. > Does anyone know what happened to it, and wether the code is available > anywhere? Thanks. What comes to mind is the pl/mono project: <http://gborg.postgresql.org/project/plmono/projdisplay.php> This would allow deploying stored functions written in F#, which is a language very similar to OCaml that runs on .NET... -- output = reverse("moc.enworbbc" "@" "enworbbc") http://linuxfinances.info/info/linuxxian.html Howe's Law: Everyone has a scheme that will not work.