Command to import data from text file to postgresql table
1. Create table of the same order os text file. Then execute the command at
Query analyser.
copy tablename from textname (with path) CSV
eg: copy friends.office1 from 'C:/FRIENDS/ksebsouth.txt' CSV
regards
Beena
- Original Messag
Command to import data from text file to postgresql table
1. Create table of the same order os text file. Then execute the command at
Query analyser.
copy tablename from textname (with path) CSV
eg: copy friends.office1 from 'C:/FRIENDS/ksebsouth.txt' CSV
regards
Beena
- Original Message
From: Mainor Alonso Morales González Subject: [ADMIN] Change stored procedures schema nameTo: pgsql-admin@postgresql.orgDate: Thursday, August 6, 2009, 8:23 PM
There exist any way to change the name of my stored procedures schemas
but the code used inside of them???
for example:
I have this stor
Mike angelo wrote:
Is there a Postgres utility that allows data contained in a CSV file
to be loaded into the database?
You mean like psql?
\copy tablename from csvfilename CSV
or with a header:
\copy tablename from csvfilename CSV HEADER
or an alternate delimiter:
\copy tablename from csvf
Le jeudi 6 août 2009 à 23:29:00, bricklen a écrit :
> Take a look at the "CSV" option of "COPY". That should do what you're
> after.
>
> http://www.postgresql.org/docs/8.4/interactive/sql-copy.html
>
You can also use pgloader, a great python tool.
--
Guillaume.
http://www.postgresqlfr.org
htt
Take a look at the "CSV" option of "COPY". That should do what you're after.
http://www.postgresql.org/docs/8.4/interactive/sql-copy.html
On Thu, Aug 6, 2009 at 2:27 PM, Mike angelo wrote:
> Is there a Postgres utility that allows data contained in a CSV file to be
> loaded into the database?
>
>
Is there a Postgres utility that allows data contained in a CSV file to be
loaded into the database?
Mainor Alonso Morales González wrote:
> There exist any way to change the name of my stored procedures
> schemas but the code used inside of them???
No. You could try doing an UPDATE to pg_proc with a query that changed
the old schema for the new.
> sorry about my bad english :S
Perhaps you co
There exist any way to change the name of my stored procedures schemas
but the code used inside of them???
for example:
I have this stored procedure:
CREATE OR REPLACE FUNCTION schema1.example(double precision) RETURNS
numeric AS
$BODY$
DECLARE
pIn ALIAS FOR $1;
BEGIN
insert in
