Yeah, I know about pg_dump. I just was curious if there was another way, since I always have two psql consoles already open at all times anyway. :-) On 4/25/05, John Browne <jkbrowne@xxxxxxxxx> wrote: > Hello, > > I was curious if there was a way to get the DDL for a particular table > from the psql client console? I have two postgres boxes (development > and production) and would like to copy & paste the DDL "CREATE TABLE" > statements from the development console to the production console when > I'm moving a particular table definition over. I tried \dt+ but it > didn't appear to show it. > > Any thoughts? > ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
