Try this: http://sqlmanager.net/products/postgresql/manager/
It's an application that includes a lot of tools for importing and
exporting databases. It's the best tool i've used for these kind of
actions, and to manage postgreSQL databases
Venkat Rao Tammineni escribió:
I've made a routine in VB to insert a image into a table. The code
is:
Set cmd = New ADODB.Command
cmd.ActiveConnection = objconexion
cmd.CommandText = "INSERT INTO tb_tmp_ventanas (ventana)
VALUES (?)"
archivo = "c:\image.jpg"
fd =
I've got a problem with a function: It receives two parameters, the
first, the table name, and the second, a where condition. The function
looks like this:
DECLARE
cod bigint;
query TEXT;
BEGIN
query = 'SELECT codigo FROM ' || $1 || ' WHERE ' || $2;
EXECUTE qu
Hello everybody.
I've got an vb aplication that uses an Access database. I'm trying
to convert the database to postgres. The conversion was done ok, but
i've got a little problem that i don't know how to solve. Let's see if
anyone can help me.
The conversion from access database to
Can I create a table name alias?
What i want is to access the same table with two different names. An
example:
I've the table CITY with fields code and name. I want to know if i
can create an alternative name to table CITY, like LOCATION, to make
possible these two sentences:
Adrian Klaver escribió:
On Friday 20 June 2008 5:20 am, Tk421 wrote:
Hello everybody.
I''ve just converted an access database to postgres. The conversion
was ok, but when i'm trying to insert data on some tables with boolean
types from a Visual Basic applic
Hello everybody.
I''ve just converted an access database to postgres. The conversion
was ok, but when i'm trying to insert data on some tables with boolean
types from a Visual Basic application i receive an error. A sample:
table example, with firs field of integer, second of type tex
Gavin 'Beau' Baumanis escribió:
Hi Everyone,
I have a question about dates, please.
I am using Coldfusion and Postgres
I have a function that takes the ate entered in a form and converts it
into an odbc date format.
So the string ends up being;
{d '2008-04-10'}
Strangely, the function is us
Alvaro Herrera escribió:
Tk421 escribió:
The result is only record number 3. How can i search the entire
FOOBAR word? The result wanted must be all, excepting 5.
Something like this:
select code from table where text ~ '[[:<:]]foobar[[:>:]]'
Hello everybody
I'm trying to make a query in a table to find the records who
contains a full word 'im looking for.
Here is an example about i'm trying
code text
1foobar
2 foobar
3 foobar y
4foobar
10 matches
Mail list logo
