Hi,
I'm trying to write an application (using libpqxx/C++) which creates graphical
images of large and complex relations between tables (basically an SVG image
with hot spots for drilling down on details). I need to essentially create
icons of tables and their columns, and then draw interconn
...snip...
For all tables and columns I get no output at all. Basically I need all tables
and columns for which the column is neither a regular primary key, nor a
foreign key. This will be marked as an attribute in the diagramming program.
Your query for primary keys which are not foreign keys
...
> Just to add that running psql with the -E switch is REALLY handy for seeing
> how psql executes queries to
> find how tables etc are put together.
I can't actually use that feature to gather the information I'm interested in
since all I have are tables and data with no formal informatio
SELECT table_name, column_name
FROM information_schema.columns
WHERE table_name = 'your_name';
- Original Message -From: hamann w To:
pgsql-general@postgresql.orgSent: Thu, 07 Sep 2017 07:18:12 - (UTC)Subject:
[GENERAL] column names query
Hi,
is there a simple way to retrieve co
Iavor Raytchev wrote:
Dear Tom,
We kind of read all documentation we could find, but that was the only way
we could get -
- export db structure into sql file
- export the records we need into another sql file
- import structure
- turn off triggers
- import the records
- turn on triggers
The main pr
of query and not at
the moment of connect. A pseudo-random generator using the same seed
will generate the same sequence.
D. Stimits, stimits AT comcast DOT net
---(end of broadcast)---
TIP 8: explain analyze is your friend
Vivek Khera wrote:
"DS" == D Stimits <[EMAIL PROTECTED]> writes:
DS> If it uses the same seed from the connection, then all randoms within
DS> a connect that has not reconnected will use the same seed. Which means
DS> the same sequence will be generated each time, whic
D. Stimits wrote:
I'm using a Redhat version of PostgreSQL 7.2.3 with the C API. Mostly
things work right, but I need more debug output, as I have a query that
works fine from psql, but fails with the C API (perhaps this is because
I use PQescapeString). The only way to know there is an err
Joe Conway wrote:
D. Stimits wrote:
> table field pair. E.G., if I had in table 'one':
> left right
> =
> a b
> a c
> b d
>
> ...then I'd need a list of a, b, c, d, and produce a new table:
> left right
> =
> a
nge to a newer version of PostgreSQL, then a newer version can't
be used]
D. Stimits
---(end of broadcast)---
TIP 8: explain analyze is your friend
Joe Conway wrote:
D. Stimits wrote:
> A google search shows very little concerning the pg_detoast_datum
> undefined reference link error. It is looking more like the V1 has to
> be skipped and I'll have to go back to V0 if I can't get this to work.
You haven't shown us
Tom Lane wrote:
> "D. Stimits" writes:
>
> >... My question is, where the heck is
> >CurrentMemoryContext and MemoryContextAlloc provided as an
> >implementation which I can link with?
>
>
> They're inside the backend, and you don't --- you a
12 matches
Mail list logo
