Hi-
I'm looking for information about storing binary data in postgres. I've
set up a few tests where in I stored bytea data, but I have a few other
questions and I'm wondering if postgres will meet my needs. Just to
start off, here's a couple of questions:
What are the differences
Peter Eisentraut wrote:
Is there any type of streaming support built into postgres'
binary datatype handling? For instance, can I specify a beginning
offset for the binary data that I want
substring and other such functions are available.
Thanks. I didn't realize that string functions
Alvaro Herrera wrote:
On Wed, Oct 05, 2005 at 10:04:10PM -0500, David Durham wrote:
is there a syntax that would look something like:
create table newTable like oldTable without indexes || records ||
constraints with indexes || records || constraints
built into postgres?
What do you
is there a syntax that would look something like:
create table newTable like oldTable without indexes || records ||
constraints with indexes || records || constraints
built into postgres?
---(end of broadcast)---
TIP 4: Have you searched
Cédric Buschini wrote:
- I would to synchrinize these 2 DB, how could I do that easily ? Maybe
with 'WAL' but I cannot figure out how . :s
I'm running 2 DB on 2 different servers : machines and versions (7.4.1
and 8.0.3)
I've setup the example rep in Slony-I and done some simple testing.
Adi Alurkar wrote:
Greetings,
There is no direct way to achieve what you want, the easiest hack is to
create a temp table with you query i.e.
create table tmp_foo as select col1, col4, col7 from table1, table2
where ;
copy table tmp_foo to [stdout|file_name]
HTH
I ended up using
This is kind of a pg-admin newbie question, so apologies in advance.
Anyway, I'd like to issue a command that dumps the results of a query to
a txt file in comma delimited format. Does PostgreSQL ship with
something to do this? I searched the web, but found what appeared to be
non-free
This is kind of a pg-admin newbie question, so apologies in advance.
Anyway, I'd like to issue a command that dumps the results of a query to
a txt file in comma delimited format. Does PostgreSQL ship with
something to do this? I searched the web, but found what appeared to be
non-free
